axapta - Multiple values in query range value in Dynamics AX 2012 -
How to Prepare a Query with Multiple Values I need to create a filter which displays only active BOMs in the grid and I I'm looking for This is my code that is not working:
public invalid executeQuery () {QueryBuildRange qbr; QueryRun queryRun; Query q = new query (); Qbr = SysQuery :: findOrCreateRange (BOMTable_q.dataSourceTable) (Filename (BOMTable)), FieldName (BOMTable, BOMId)); If (activeButton == incorrect) {qbr.value (SysQuery :: valueUnlimited ()); } Other {When selecting BOMVersion where BOMVersion.Active == true & amp; Amp; BOMVersion.Approved == true {qbr.value (queryView (BOMVersion.BOMId)); } Super();
You have two options:
- Multiple
Option 1:
queryBuildData source qbds = q.dataSourceTable ( BOMTable); QueryBuildRange qbr; While (...) {qbr = qbds.addRange (FieldName (BOMTable, BOMId)); Qbr.value (queryValue (BOMVersion.BOMId)); }
option 2:
querybuildrenz qbr = q.dataSourceTable (BOMTable) .addRange (FieldName (BOMTable , Bomid)); Container C; Whereas (...) {c + = queryValue (BOMVersion.BOMId); } Qbr.value (con2str (c));
Comments
Post a Comment