Hi, I’m using Dynamics AX 2012. I’ve got a List of parameters coming in from an RDP report. I’ve built my Query object, and want to filter by this list. Basically replicating the following line in SQL.
SELECT * FROM INVENTSITE ISI
WHERE ISI.SITEID IN (SELECT SITEID FROM @BranchTable))
What’s the proper way to setup a filter (where clause) that accomplishes the same functionality? Do I need to loop through my List?
siteFilter = query.addQueryFilter(inventDim,fieldStr(InventDim,InventSiteId));
siteFilter.value(SysQuery::value( …?.. ));