topic search in table rows in App Development

search in table rows

danaosjoin — Sat, 16 Nov 2024 19:57:36 GMT

Hello,

I want to search in table rows with the following expression and return to me the first row that matches

example: employee_code=5 and nationality='GRC'

I have already loaded a table, I don't want to run a select/where statement at load time, I need to process the rows afterwards (hint: lookup cannot take expressions)

many thanks

Noel

Re: search in table rows

StarinieriG — Fri, 04 Oct 2019 10:56:15 GMT

Hi,

try with firstvalue() or firstsortedvalue()

Re: search in table rows

jonathandienst — Fri, 04 Oct 2019 11:43:29 GMT

>> the first row that matches...

"First"' in terms of what? Load order, date order or some other order?

Re: search in table rows

danaosjoin — Tue, 08 Oct 2019 05:32:51 GMT

Lets say that i have load the following table...

LOAD employee_code, nationality;

and the rows that the table has are:

1,GRC

2,GRC

3,GRC

4,GRC

5,GRC

6,GRC

i want somehow to apply the following expression "employee_code=5 and nationality='GRC'" and return to me the first row that matches in this example is fifth row.

Best Regards

Re: search in table rows

danaosjoin — Thu, 10 Oct 2019 07:49:31 GMT

any ideas ?