Monday, February 1, 2010

"Like" with "AND" Operator through Query in Dynamics Ax

static void RAJ_AndLikeOperator(Args _args)
{
Query query = new Query();
QueryRun queryRun;
InventTable inventTable;
;

query.addDataSource(tableNum(InventTable)).addRange(fieldNum(InventTable, ItemId)).value("100*, 110*, 120*");
queryRun = new QueryRun(query);
while(queryRun.next())
{
inventTable = queryRun.get(tableNum(InventTable));
info(inventTable.ItemId);
}
}

No comments: