开发者

Filtering through multiple dimesion Values

开发者 https://www.devze.com 2023-03-02 16:03 出处:网络
I have a dropdown(Dimesions) and a stringEdit LookUp(dimensionValue)When I select a dimension suppose \'Branch\' and a Value e.g. \'B001\' I filter the result with the following query

I have a dropdown(Dimesions) and a stringEdit LookUp(dimensionValue) When I select a dimension suppose 'Branch' and a Value e.g. 'B001' I filter the result with the following query

queryRun.query().dataSourceTable(tablenum(LedgerTrans)).addange(fieldId2Ext(fieldNum(LedgerTrans, Dimensions), dimensions)).value(dimensionValue);

where dimensions is enumValue, in the above query the enumValue for branch is 3 and dimensionValue is a string EDT.

Now I want to filter with multiple dimensionValues e.g. 'B001, B002, B002开发者_高级运维' etc. What modifications do I have to make in the query? Kindly assist.


With this code you should be able to simply enter "B001, B002, B002" (without the quotes) in your Value StringEdit control.

By the way I would advise you to modify your code as follows so that same ranges wouldn't be added over and over again:

SysQuery::findOrCreateRange(queryRun.query().dataSourceTable(tablenum(LedgerTrans)), fieldId2Ext(fieldNum(LedgerTrans, Dimensions), dimensions)).value(dimensionValue);
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号