Simple use case.

[fouedex]

Hi all,
Here's what i want to achieve as a training use case :
I want to build a page, which will be composed of 2 sub-elements :

A form to insert a data into a particular table.
Under the from, the raw display of the previous table content.

Of course i want this two sub-elements to be re-usable in other contexts.
Could someone give me a direction to do this ?
Thx in advance.

[jdixon]

You could do this with a JSP.

If you want to do this using only Pentaho components.

1. Create an action sequence that recieves all of the form inputs from the request. The action sequence uses the SecureFilterComponent to validate that the inputs have been provided or displays the parameter page (the form) if they have not. The sequence uses a SQLLookupRule with an insert statement to insert data into the table.

2. Create a second action sequence that has a SQLLookupRule that selects the contents of the table.

3. Create a JSP that calls both action sequence and displays their results.

The two action sequences are you two re-usable elements.

I hope this is enough information to get you started on this.

James

[anbu4friends@gmail.com]

Hi,

I have 4 tables
Library - > Book, Video, Magzine
Book -> BookID, BookName, Author, Quantity
Video -> VideoID, VideoName,Type,category
Magazine-> MagID, MagName, publishdate,quantity

want to use Pentaho BI component, to inset/update new record in each table:
The Screen should display:

Libraray: <combobox> ( to list Book, Video, Magazine - which should be dynamically pulled from Library table).

Based on the selection, it should open a new form like:

BookID : <text box >
BookName : <textbox >
Author : <textbox>
Quantity: <textbox>
Save Button, Cancel Button.

Could you pls help me by giving example XACtion or jsp file. I want it to be generic , so that it can be used irrespective of table names, columns (configurable parameter).

Thanks & Regards,
Anbu.