Hi All
qbds1 = q.addDataSource(tableNum(ProjCategory));
qbr1 = qbds1.addRange(fieldNum(ProjCategory, CategoryType));
// qbr1.value(SysQuery::value(categoryType));
I need two range so i used below line code rather above but it is not working.
qbr1.value(strfmt(’(categoryType == %1) && (categoryType == %2)’,any2int(ProjCategoryType::Item),any2int(ProjCategoryType::Cost)));
qbds2 = qbds1.addDataSource(tableNum(CategoryTable));
qbds2.relations(true);
qbds2.joinMode(JoinMode::InnerJoin);
qbr2 = qbds2.addRange(fieldNum(CategoryTable, IcCategory));
qbr2.value(enum2str(NoYes::Yes));
so kindly let me know is there any way that in a single data source can i put couple of range filter .
Regards
Sumit
What do you want to achieve? Your current code is logically wrong, because no category can be both Item and Cost in the same time.
If you want categories with type equal either Item or Cost, use two ranges:
qbds1.addRange(fieldNum(ProjCategory, CategoryType))
.value(queryValue(ProjCategoryType::Item));
qbds1.addRange(fieldNum(ProjCategory, CategoryType))
.value(queryValue(ProjCategoryType::Cost))
Hi Martin Dráb
Thanks for your reply But i need both range should work .
In detail There is customized List page form look up with four field
If a customer choose the cost then Item && cost range will work in a single look up.
I am taking all data from Category Table , Range as Transaction Type and my Lookup is
Category Id and Name .
req. If Cost will selected then in the look up there are cost related category id and item related category id will select in a single field look up .
Kindly let me know how it will possible or not
if possible give me some hints .
Regards
Sumit
If I understand what you want, I already gave you a solution in my previous answer. Have you tried it? What’s exactly works differently than expected?
Hi Martin ,
U r a Hero in Ax Thanks a lot .
Regards
Sumit