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

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

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

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


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

mvp_badge
MVP

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.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.