Skip to main content

Query link and query build datasource example in MSD axapta

Query link and query build datasource example

 static void QueryLinks(Args _args)  
 {  
 Query query = new Query(queryStr(custtable));//Give your query name as in AOT...  
 void getLinks(QueryBuildDatasource _qbds)  
 {  
 QueryBuildDataSource childDataSource;  
 QueryBuildLink queryBuildLink;  
 Counter links;  
 int i;  
 ;  
 if (_qbds.enabled())  
 {  
 setPrefix (tableId2Name(_qbds.table()));  
 if(_qbds.level() > 1)  
 {  
 while (links < _qbds.linkCount())  
 {  
 links++;  
 queryBuildLink = _qbds.link(links);  
 info(strFmt("%1.%2 --> %3.%4",  
 tableId2Name(queryBuildLink.relatedTable()),  
 fieldId2Name(queryBuildLink.relatedTable(), queryBuildLink.relatedField()),  
 tableId2Name(queryBuildLink.table()),  
 fieldId2Name(queryBuildLink.table(),queryBuildLink.field())));  
 }  
 }  
 for (i = 1; i <= _qbds.childDataSourceCount(); i++)  
 {  
 childDataSource = _qbds.childDataSourceNo(i);  
 getLinks(childDataSource);  
 }  
 }  
 }  
 ;  
 setPrefix(strFmt("Query: '%1'", query.name()));  
 getLinks(query.dataSourceNo(1));  
 }  

Popular posts from this blog

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

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)));

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

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);

Code to get customer Primary Address in Ax 2012

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