topic Re: File match : filter data in a table in App Development

File match : filter data in a table

Dembegomes — Wed, 09 Oct 2019 11:58:20 GMT

Hello everyone,,

I have a table with fields ID name and sales with over 400k records

I get files with ID usually having 300 IDs in each file.

I need to filter the table as per these IDs

It is a published app and there is no provision to store the excel file on the server

Can I use variable extension or qsvariable ?

martinpohl — Wed, 09 Oct 2019 12:30:06 GMT

hi,

I would load the ID as a concat-string

load concat(distinct Field,',') as Concat
from your table;

then get the string as a variable
let vFilter = peek('Concat');

and use this variable as a filter in the select

select * from table

where ID in ($(vFilter));

Or something similar

Regards