How to display two result data for table record get by SQL

Hi every body

I'm doing implement search function and i have a problems

i don't know how to display data for table record get from two event ,init display and click search button because each event use difference SQL to get data from DB(init display SQL is not contain condition search)

somebody can help me suggest solution or relate topic to resolve it?

Thanks

Solution

Hi Tung,


There are other ways too to handle this case.

One is like, create one local variable(with your list Datatype) and assign this variable to your table.

And in each case preparation or in search, assign result list to this variable and ajax refresh your table.

Thanks,

Manish

Solution

Hi! 

I would create a list to use in the screen to display the results.

 In the preparation and in the search action use the System action "ListAppendAll" to put the sql results in the list.

(don't forget to use the "ListClear" before the "ListAppendAll" )

Hope this helps

Regards 

Graça

Hi Tung,


Did you check the online content in the Learn menu?

I strongly advise you to follow the training here. After you do it all be much clearer.

Manish Pandey wrote:

Hi Tung,


There are other ways too to handle this case.

One is like, create one local variable(with your list Datatype) and assign this variable to your table.

And in each case preparation or in search, assign result list to this variable and ajax refresh your table.

Thanks,

Manish

Thanks it worked