Skip to main content

Posts

Showing posts with the label add range wildcard

How to use like in range with wildcard character in MSD axapta

 How to use like in range with wildcard character in axapta Using wildcard "Like" //The "*" symbolises the like in the statement static void useWildCards(Args _args) { Query custQuery = new Query(); QueryRun queryRun; CustTable CustTable; ; custQuery.addDataSource(tablenum(CustTable)).addRange(fieldnum(CustTable, Name)).value('L*'); queryRun = new QueryRun(custQuery); while (queryRun.next()) { custTable = queryRun.get(tablenum(CustTable)); info(custTable.Name); } }