Skip to main content

How to build query object in axapta

Image
By 

 Query query;  
 QueryBuildDataSource qbds1;  
 QueryBuildDataSource qbds2;  
 QueryBuildRange qbr1;  
 QueryBuildRange qbr2;  
 QueryRun queryRun;  
 CustTable custTable;  
 ;  
 query = new Query();  
 qbds1 = query.addDataSource(tablenum(CustTable));  
 qbds1.addSortField(  
 fieldnum(CustTable, Name),  
 SortOrder::Ascending);  
 qbr1 = qbds1.addRange(fieldnum(CustTable,Blocked));  
 qbr1.value(queryvalue(CustVendorBlocked::No));  
 qbr2 = qbds1.addRange(fieldnum(CustTable,CustGroup));  
 qbr2.value(queryvalue('10'));  
 qbds2 = qbds1.addDataSource(tablenum(SalesTable));  
 qbds2.relations(false);  
 qbds2.joinMode(JoinMode::ExistsJoin);  
 qbds2.addLink(  
 fieldnum(CustTable,AccountNum),  
 fieldnum(SalesTable,CustAccount));  
 queryRun = new QueryRun(query);  
 while (queryRun.next())  
 {  
 custTable = queryRun.get(tablenum(CustTable));  
 info(strfmt(  
 "%1 - %2",  
 custTable.Name,  
 custTable.AccountNum));  
 }  
 }
Labels:

Popular posts from this blog

strScan and Find a first occurrence of a string in a string using x++

By
strScan (Find a first occurrence of a string in a string) info("int strScan(str _text1,str _text2,int _position,int _number)"); info("Searches a text string for the occurrence of another string."); info("_text1 - The text string to search."); info("_text2 - The string to find."); info("_position - The position at which the search should start."); info("_number - The number of characters that should be searched."); info(int2str(strScan("ABCDEFGHIJ","DE",1,10)));
Read more

Code to get customer Primary Address in Ax 2012

By
Below Code to get customer Primary Address in Ax 2012. CustTable custTable_P; DirPartyTable dirPartyTable_P; DirPartyLocation dirPartyLocation_P; DirPartyLocationRole dirPartyLocationRole_P; LogisticsLocation logisticsLocation_P; LogisticsLocationRole logisticsLocationRole_P; LogisticsPostalAddress logisticsPostalAddress_P; LogisticsPostalAddress primaryAddress_P; while select custTable_P where custTable_P.AccountNum =='ED_01029' join dirPartyTable_P where dirPartyTable_P.RecId == custTable_P.Party join dirPartyLocation_P where dirPartyLocation_P.Party == custTable_P.Party && dirPartyLocation_P.IsPrimary==NoYes::Yes join dirPartyLocationRole_P where dirPartyLocationRole_P.PartyLocation == dirPartyLocation_P.RecId join logisticsLocationRole_P where logisticsLocationRole_P.RecId == dirPartyLocationRole
Post a Comment
Read more

Get record from table on the basis of field id in Microsoft dynamics axapta x++

By
How to Get record from table on the basis of field id in dynamics axapta x++. just try following code in job to understand better way. emplTable emplTable; FieldId fieldId; ; fieldId = fieldNum(emplTable, Emplid); select emplTable; info(emplTable.(fieldId)); select emplTable where emplTable.(fieldId) == '1101'; info(emplTable.Name);
Read more