Use of query build datasource in job and range static void SelectCustomerJobQuery(Args _args) { Query query; QueryBuildDataSource queryBuildDatasource; QueryBuildRange queryBuildRange; QueryRun queryRun; Counter recordsFound; custTable cust; ; query = new Query(); queryBuildDataSource =query.addDataSource(tableNum(custTable)); queryBuildDataSource.addSortField(fieldNum(custTable,Name)); queryBuildRange =queryBuildDataSource.addRange(fieldNum(custTable,city)); queryRun = new QueryRun(query); /*while (queryRun.next()) { cust= queryRun.get(tablenum(custTable)); print cust.Name; }*/ if (queryRun.prompt()) { while (queryRun.next()) { recordsFound++; cust= queryRun.get(tablenum(custTable)); print cust.Name; } } info(strFmt("Customers found: %1", recordsFound)); pause; }
Microsoft Dynamics Ax,AIF,Axapta, Enterprise portal,,Microsoft , United State,U.S., SharePoint , BI Tools, Performance Tuning, SSRS,Business Logic,Ax ERP Errors and solution,Dynamics 365 Errors Solution,Business software .