Filtering out for multiple values in query range using addrange

(0) Share

Report

Posted on by Community Member

Hello,

I'm trying to filter out for two values. In SQL this would be where prodtable.fieldname not in ('hold', 'delete')

I have the two lines below, but it acts as an "or" operator. I need the two lines only using an "and" operator

Thanks in advance for any help you can provide

qbdsProdTable.addRange(fieldNum(ProdTable,ProdPoolId)).value(queryNotValue(BOT_ProdPoolID::Hold ));

qbdsProdTable.addRange(fieldNum(ProdTable,ProdPoolId)).value(queryNotValue(BOT_ProdPoolID::Delete ));

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

Mea_ 60,286 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi SSRSGuy,

You can try next code

qbdsProdTable.addRange(fieldNum(ProdTable, ProdPoolId)).value(strFmt('((ProdPoolId != "%1") && (ProdPoolId != "%2"))', queryValue(BOT_ProdPoolID::Hold), queryValue(BOT_ProdPoolID::Delete)));

Please find additional details about expressions in query ranges here http://www.axaptapedia.com/Expressions_in_query_ranges

Please note that ProdPoolId is not enum but string and usually we don't use enums to create a range by a string field.

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much ievgen!!!!!!!! I spent too many hours trying to figure that out. Have a great day.

Was this reply helpful? Yes No
Community Member on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you Crispin!!!!!!!!!!! Have a great day.

Was this reply helpful? Yes No
Dang Vo 31 on at

Like
a
(1)

Report
Copy link

Link copied!

queryBuildRange.value(strFmt('%1,%2',
queryValue(queryNotValue(BOT_ProdPoolID::Hold )),
queryValue(queryNotValue(BOT_ProdPoolID::Delete)));

Was this reply helpful? Yes No
Deo 10 on at

Like
a
(0)

Report
Copy link

Link copied!

THanks, very nice

Was this reply helpful? Yes No
Suggested answer

Mikhail Lakhvich 23 on at

Like
a
(1)

Report
Copy link

Link copied!
I'll leave it here.

qbdsProdTable.addRange(fieldNum(ProdTable, ProdPoolId)).value( queryRangeConcat(SysQuery::valueNot(BOT_ProdPoolID::Hold), SysQuery::valueNot(BOT_ProdPoolID::Delete)));

Was this reply helpful? Yes No