Dynamics AX/D365FO Technical

http://shafeaa.blogspot.in/p/di.html

static void vij_fulltextIndexJob(Args _args) {     //A full text index can improve the speed of queries that search for words that are embedded in string and memo fields on tables. [MS help]     Query   query;     QueryBuildDataSource  qbds;     QueryBuildRange   qbr;     CountryTable    ct;     QueryRun        qr;           query = new Query();     qbds =query.addDataSource(tableNum(CountryTable));     qbr = qbds.addRange(fieldNum(CountryTable,Country));     qbr.rangeType(QueryRangeType::FullText);     qbr.value('ind  usa  aus ');//space means OR  condition     //in x++ select statements we cant use fulltextindex     //we can only create fulltextindex for tablegroup main or group     //we can create maximum one full text index for table     ...

Some Times you cannot use the debugger in the all environments. But without using the debugger you can get call stack. The following x++ code will help you in this case. Add the example code to a method that is throwing an error. container callStackCon; int i; Str msg; callStackCon = xSession::xppCallStack(); for(i=1;i<=conlen(callStackCon);i++) { msg+ = conpeek(callStackCon,i); } info(msg);

Hi Guys, The following code will helps you to read Excel file using x++ code.   static void howToReadExcelSheet(Args _args)   {             SysExcelApplication                    application;             SysExcelWorkbooks                     workbooks;             SysExcelWorkbook                      workbook;             SysExcelWorksheets                    worksheets;             SysExcelWorksheet                      worksheet;             SysExcelCells                       ...

Hi Guys, Below are the few links help you to start learning AX7. http://viraldax.blogspot.in/2016/03/microsoft-dynamics-ax-7-how-to.html https://blogs.msdn.microsoft.com/axsupport/2016/03/23/get-started-developing-in-ax-7/ https://stoneridgesoftware.com/differences-in-development-for-microsoft-dynamics-ax-7/ https://community.dynamics.com/ax/b/axilitynet/archive/2015/12/10/ax7-sneak-peek-the-new-aot Thanks

How to get AOS Details in ax 2012:- Hello All,The following is the information will help to get AOS details. Session is the class having useful methods to get AOS name and Port number,UserName. Session contains static methods which can be called without creating object. Session extends xSession class is having more information. The following is the code. Session   session; session = new Session(); info(strFmt("%1 %2  %3",session.AOSName(),session.aosPort(),session.UserId())); SysClientSessions , SysServerSessions , SysUsersonline are the classes and SysUsersOnline is the form to get more information regarding Users,Sessions,etc., Hope this will helps you.

static void  customerAddress(Args _args) {     DirPartyPostalAddressView           dirPartyPostalAddrlocal;     DirPartyLocationRolesView           dirPartyLocationRoleslocal;     LogisticsLocationRole                   logisticsLocRole;     select firstOnly   * from dirPartyPostalAddrlocal order by RecId desc         exists join dirPartyLocationRoleslocal             where dirPartyLocationRoleslocal.Location   == dirPartyPostalAddrlocal.Location                 && dirPartyLocationRoleslocal.Party     ==     CustTable::find(_accountNum).Party//_dirpartyRecid                 //&& dirPartyPostalAddrlocal.IsPrimary == NoYes::No         exists j...