Advance search function

i have question, if i have 2 field for search as like :

i want have dropdown and then after i choose drop down, the search field will search from the column of table, how can i do it in outsystems?

the result want like this:

Please help :D

Hi Grace,

You will need to use SQL queries with Expand Inline input parameters, so you can dynamically build your filters/WHERE clause.

You can check this post for similar requirements and how people handled them. 

Note: the output structure(s)/entity(ies) of a SQL statement are always static: the result set data type cannot be dynamically defined (shouldn't be relevant in your scenario though).