In general is the way i wrote the ranges for date and TransType correct?ġ.
TransType is an extensible enum, and in the range i used sth like Transtype =15, etccc so would this cause any issue?, because i read that extensible enums would result in different numbers when using different environmentĤ. would there be any difference in performance when using AOT query or x++ query?ģ. I also noticed that there are 3 relations between CustTrans and CustTableĢ. However, in d365, i used use relations(true) instead of specifying the relation myself and i got this: "FROM CustTable(CustTable) ON CustTrans.AccountNum = CustTable.AccountNum"ĭoes that make a difference? why they are different. As you can see in AX12 code, use relations was set to yes, and the query ended with this "FROM CustTable(CustTable_1)}" JOIN EnterpriseCode, AccountNum, Party FROM CustTable(CustTable) ON CustTrans.AccountNum = CustTable.AccountNum}ġ.
If(dateFrom || dateTo) //coming from Contract QueryBuildDSCustTrans = query.addDataSource(tablenum(custTrans)) QueryBuildDataSource queryBuildDSCustTable QueryBuildDataSource queryBuildDSCustTrans So i have 2 contract parameters (fromDate, andToDate) and i have an x++ query that was used in ax 12, And i want to do it again in d365
0 kommentar(er)
