Finance | Project Operations, Human Resources, ...

How can I filter multiple values on the same field in a execute query method?

(0) Share

Report

Posted on by Siddharth Muju

hello ,

can anyone help me out with this query that How can I filter multiple values on the same field in a execute query method and in form it should be shown as is one of in filter.

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Martin Dráb 236,796 Most Valuable Professional on at

Like (0)

Report
How can I filter multiple values on the same field in a execute query method?

You can simply add one range for each value. For example:

FieldId fieldId = fieldNum(MyTable, MyField); QueryBuildDataSource qbds = this.queryBuildDataSource(); qbds.addRange(fieldId).value(queryValue('a')); qbds.addRange(fieldId).value(queryValue('b')); qbds.addRange(fieldId).value(queryValue('c'));

Don't forget to remove existing ranges, otherwise you'd keep adding more and more ranges in executeQuery() and you'd be getting wrong results.

Was this reply helpful? Yes No
Siddharth Muju 18 on at

Like (0)

Report

How can I filter multiple values on the same field in a execute query method?

hello martin,

i have tried this but its not working.

Was this reply helpful? Yes No
Martin Dráb 236,796 Most Valuable Professional on at

Like (0)

Report

How can I filter multiple values on the same field in a execute query method?

I'm sorry, but I have no solution for "not working". Please describe the behavior, what you've found when you debugged it and show us your code.

Was this reply helpful? Yes No
Siddharth Muju 18 on at

Like (0)

Report

How can I filter multiple values on the same field in a execute query method?

qbds = this.query().dataSourceTable(tableNum(customtable));
qbds.clearRanges();
qbds.addRange(fieldNum(customtable,InventLocationId)).value('value1');
qbds.addRange(fieldNum(customtable,InventLocationId)).value('value2');

i have written this code before super.

Was this reply helpful? Yes No
Martin Dráb 236,796 Most Valuable Professional on at

Like (0)

Report

How can I filter multiple values on the same field in a execute query method?

Okay, the remaining part is describing the problem and telling us what you found when you debugged it, e.g. how the query string looks like.

Assuming that your code is in executeQuery() of CustomTable data source, you can replace qbds = this.query().dataSourceTable(tableNum(CustomTable)) with mere qbds = this.queryBuildDataSource().

Also, using queryValue() may be necessary even with text values, because it escapes some special characters.

Was this reply helpful? Yes No
Siddharth Muju 18 on at

Like (0)

Report

How can I filter multiple values on the same field in a execute query method?

{Query object 2f967200: SELECT FIRSTFAST FORUPDATE * FROM customTable(customtabe) WHERE ((InventLocationId = N'value1') OR (InventLocationId = N'value2')) OUTER JOIN FORUPDATE Person, Person FROM HcmWorker(Ref_HcmWorker_customField) ON customtabe.customField= HcmWorker.RecId OUTER JOIN FORUPDATE Name, RecId FROM DirPerson(Ref_DirPerson_customField_DirPerson_FK) ON HcmWorker.Person = DirPerson.RecId}

this query was generated.

Was this reply helpful? Yes No
Martin Dráb 236,796 Most Valuable Professional on at

Like (0)

Report

How can I filter multiple values on the same field in a execute query method?

As you see, the ranges are correct, therefore the code does work.

Your problem lies somewhere else, but I can't help you with it, because the only information your gave me is that "it doesn't work". That could mean anything.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How can I filter multiple values on the same field in a execute query method?

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How can I filter multiple values on the same field in a execute query method?

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates