Finance | Project Operations, Human Resources, ...

how use OR Condition on multiple query Ranges in D365 F&O

(0) Share

Report

Posted on by Sachin Mittal

 query buildQuery()
    {
        
            QueryBuildDataSource	qbdsDistributorWorkerTarget,qbdsOAE1PSRHierarchy;
            Query query				= new Query(queryStr(OABCustomerReportLookupDetail));
            qbdsDistributorWorkerTarget =  query.dataSourceTable(tableNum(OAE1DistributorWorkerTarget));
            qbdsOAE1PSRHierarchy        =  query.dataSourceTable(tableNum(OAE1PSRHierarchy));
           
            qbdsDistributorWorkerTarget.addRange(fieldNum(OAE1DistributorWorkerTarget, ModifiedDateTime)).value(queryRange(fromDate,toDate));
   
            //Employee Code
            Employee = con2Str(EmployeeCon);

            if(Employee)
            {
                Employee = strReplace(Employee,';',',');
                qbdsOAE1PSRHierarchy.addRange(fieldNum(OAE1PSRHierarchy, ASM)).value(Employee) ;
                qbdsOAE1PSRHierarchy.addRange(fieldNum(OAE1PSRHierarchy, PSRSalesman)).value(Employee);
                qbdsOAE1PSRHierarchy.addRange(fieldNum(OAE1PSRHierarchy, OABSalesExecutivecode)).value(Employee);
                     
            }
        
            return query;
        }

I have added my query, now under if condition there are three ranges as of now I have passed, but I want if any of condition is true, query range work , now it works only when all three ranges are simultaneously passed

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

André Arnaud de Cal... 304,750 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi Sachin,

You can use an or statement by using an advanced query expression on e.g. the RecId field. See next example:

qbdsOAE1PSRHierarchy.addRange(fieldNum(OAE1PSRHierarchy, RecId)).value( '(OAE1PSRHierarchy.ASM == ' Employee ' || OAE1PSRHierarchy.PSRSalesman == ' Employee ' ' || OAE1PSRHierarchy.OABSalesExecutivecode == ' Employee ')';

Was this reply helpful? Yes No
Suggested answer

Anton Venter 20,670 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

To use an OR on different fields, you need to use "Expressions in query ranges", have a look at the link below. Also search for "Expressions in query ranges" for more information.

learn.microsoft.com/.../using-expressions-in-query-ranges

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Sachin, Please check this article

www.linkedin.com/.../

Was this reply helpful? Yes No
Sachin Mittal 4 on at

Like (0)

Report
Copy link

Link copied!

its not returning expected output

Was this reply helpful? Yes No
Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

Please share your code that you wrote after going through above suggestions.

Was this reply helpful? Yes No
Sachin Mittal 4 on at

Like (0)

Report
Copy link

Link copied!
qbdsOAE1PSRHierarchy.addRange(fieldNum(OAE1PSRHierarchy, RecId)).value('(OAE1PSRHierarchy.ASM == ' Employee ' || OAE1PSRHierarchy.PSRSalesman == ' Employee ' || OAE1PSRHierarchy.OABSalesExecutivecode == ' Employee ')');

this range is not working

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (1)

Report
Copy link

Link copied!
Can you try below code

Employee = strReplace(Employee,';',','); qbdsOAE1PSRHierarchy.addRange(fieldNum(OAE1PSRHierarchy, ASM)).value( strFmt('((%1.%2 == "%5") || (%1.%3 == "%5")) || (%1.%4 == "%5"))', qbdsOAE1PSRHierarchy.name(), fieldStr(OAE1PSRHierarchy, ASM), fieldStr(OAE1PSRHierarchy, PSRSalesman), fieldStr(OAE1PSRHierarchy, OABSalesExecutivecode), Employee));

Check this old thread

community.dynamics.com/.../how-to-add-range-on-multiple-field-with-same-value

Was this reply helpful? Yes No
Sachin Mittal 4 on at

Like (1)

Report
Copy link

Link copied!

Thankyou so much for helping !!

Was this reply helpful? Yes No