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)

Suggested answer

André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report
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,346 Super User 2025 Season 2 on at

Like (1)

Report

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,565 Moderator on at

Like (0)

Report

Hi Sachin, Please check this article

www.linkedin.com/.../

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

Like (0)

Report

its not returning expected output

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

Like (0)

Report

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

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

Like (0)

Report
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,565 Moderator on at

Like (1)

Report
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 2 on at

Like (1)

Report

Thankyou so much for helping !!

Was this reply helpful? Yes No