How to pass multiple values in an execute query to filter?

(1) Share

Report

Posted on by RSX

204

Hi,
I have a table 1 with a field emp id. and example it has 3 values. 001, 002, 003.

I have a fast tab, with table 2 which as all emp ids updated.

I need to write a query in table 2, where it can filter only 3 values from table 1 i,e 001, 002, 003.

For example: I need to filter as is one of values.

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Martin Dráb 239,953 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
You talk about adding a writing a query in a table, but you likely mean adding ranges to a form query.

If you know how to add a range for a single value, you're almost there. Just add two more ranges in the same way:

QueryBuildDataSource myTableQbds = myTable_ds.queryBuildDataSource(); myTableQbds.addRange(fieldNum(MyTable, MyField)).value(queryValue('001')); myTableQbds.addRange(fieldNum(MyTable, MyField)).value(queryValue('002')); myTableQbds.addRange(fieldNum(MyTable, MyField)).value(queryValue('003'));

Was this reply helpful? Yes No
RSX 204 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Martin,

Yes, I understand how to add ranges. The examples I provided—001, 002, 003—were merely illustrative.

My main concern is that "Table 1" could contain any number of employee IDs. I want "Table 2" to filter out all the employee IDs present in "Table 1."

Currently, if I Override an execute query in Table 2 like this:

this.query().dataSourceTable(tableNum(table2)).addRange(fieldNum(table2, empid)).value(queryValue(Table1.Empid));

it only filters out a single employee ID from Table 1, rather than all relevant employee IDs.

Could you please advise on how to achieve the desired filtering?

Thank you!

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,953 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Your code shows a single employee because you added a range for a single employee. My code would show three, because there are ranges for three values. To see more, you could simply add more ranges. You could iterate relevant (whatever it is) records in Table1 and add a range for each employee. That answers what you asked for, but what you really need may be something else.

But if you want to show all Table2 records that have a related record in Table1, using query ranges is a bad approach. Use a join instead, probably an exist join.

Was this reply helpful? Yes No