How to use AND condition in query range

(1) Share

Report

Posted on by CU21091228-0

230

Hi Team,

In query range i need to use ABC_CombinationTable.Device is not equal to 1, 2, 5, 8

Below code i am using.

qbdsCombinationTable.addRange(fieldNum( ABC_CombinationTable, Device)).value(SysQuery::valueNot(1));qbdsCombinationTable.addRange(fieldNum( ABC_CombinationTable, Device)).value(SysQuery::valueNot(2));qbdsCombinationTable.addRange(fieldNum( ABC_CombinationTable, Device)).value(SysQuery::valueNot(5));qbdsCombinationTable.addRange(fieldNum( ABC_CombinationTable, Device)).value(SysQuery::valueNot(8));

But it is giving me OR condition.

And i want to set AND condition.

Please let me know how to set AND condition.

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

GirishS 27,829 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Try like below and let us know the results.

qbdsCombinationTable.addRange(fieldNum( ABC_CombinationTable, Device)).value(SysQuery::valueNot(1) + ',' + SysQuery::valueNot(2) + ',' + SysQuery::valueNot(5) + ',' + SysQuery::ValueNot(8));

If above one doesn't work, you need to use expression in query ranges.

Thanks,

Girish S.

Was this reply helpful? Yes No
CU21091228-0 230 on at

Like (0)

Report
Copy link

Link copied!

Thanks Girish, Working.

Was this reply helpful? Yes No