QueryBuildDataSource AddRange with or condition

(0) Share

Report

Posted on by Peter Kou

Hello,

I'm trying to filter this:

need to get the ' % of commission' field or 'justification for not commission' field

But my result is comming with AND condicion...

I did the following:

Query querySalesLine;

QueryBuildDataSource qbds

;

qbds = qbds.addDataSource(tablenum(HistoryControlGrouped));

qbds.addLink(fieldnum(SalesLine, RecId), fieldnum(HistoryControlGrouped, RecIdSource));
qbds.addRange(fieldnum(HistoryControlGrouped, commission)).value("3");
qbds.addRange(fieldnum(HistoryControlGrouped, CommissionPercentage)).value(">0");

But the result is:

SELECT FIRSTFAST * FROM SAG_HistoryControlGrouped WHERE SalesLine.RecId = SAG_HistoryControlGrouped.RecIdSource AND ((Comissao = 3)) AND ((SAG_CommissionPercentage>0.E0))

How can I change the AND to OR?

Thanks!!

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

Look at Expressions in query ranges. It's ugly and error-prone code, but it works.

Was this reply helpful? Yes No
Peter Kou 5 on at

Like (0)

Report

Ok, Thanks Martin!

Was this reply helpful? Yes No