Skip to Content (Press Enter)
UserImage.jpg
Tung Nguyen
131Views
4Comments
Solved
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

0
0
12 Mar 2019
Copy Link
2018-12-17 04-50-28
Manish Pandey
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

1
0
12 Mar 2019
Copy Link
UserImage.jpg
Tung Nguyen

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


0
0
12 Mar 2019
Copy Link
2018-06-05 16-54-03
Maria da Graça Peixoto

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

0
0
12 Mar 2019
Copy Link
2016-04-21 18-13-58
Nuno Rolo
 
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.

0
0
12 Mar 2019
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.