You’re offline. This is a read only version of the page.
623
Hi I created a class in which I use a SysQuery. The init looks like this:
void initQuery()
{
Query query = new Query();
QueryBuildDataSource qbdsOrders, qbdsOrderLines, qbdsInventTable, qbdsCustomers;
;
//Aufträge
qbdsOrders = query.addDataSource(tablenum(SalesTable));
qbdsOrderLines = qbdsOrders.addDataSource(tablenum(SalesLine));
qbdsOrderLines.joinMode(JoinMode::InnerJoin);
qbdsOrderLines.relations(true);
qbdsInventTable = qbdsOrders.addDataSource(tablenum(InventTable));
qbdsInventTable.relations(false);
qbdsInventTable.addLink(fieldnum(InventTable, ItemId), fieldnum(SalesLine, ItemId));
SysQuery::findOrCreateRange(qbdsOrders, fieldnum(SalesTable, CreatedDate));
SysQuery::findOrCreateRange(qbdsOrders, fieldnum(SalesTable, SalesStatus));
SysQuery::findOrCreateRange(qbdsOrders, fieldnum(SalesTable, CustAccount));
SysQuery::findOrCreateRange(qbdsOrders, fieldnum(SalesTable, SalesOriginId));
SysQuery::findOrCreateRange(qbdsOrderLines, fieldnum(SalesLine, SalesStatus));
//Kunden
qbdsCustomers = query.addDataSource(tablenum(CustTable));
SysQuery::findOrCreateRange(qbdsCustomers, fieldnum(CustTable, AccountNum));
SysQuery::findOrCreateRange(qbdsCustomers, fieldnum(CustTable, CreatedDate));
SysQuery::findOrCreateRange(qbdsCustomers, fieldnum(CustTable, LineDisc));
SysQuery::findOrCreateRange(qbdsCustomers, fieldnum(CustTable, Blocked));
SysQuery::findOrCreateRange(qbdsCustomers, fieldnum(CustTable, CountryRegionId));
SysQuery::findOrCreateRange(qbdsCustomers, fieldnum(CustTable, EndDisc));
SysQuery::findOrCreateRange(qbdsCustomers, fieldnum(CustTable, MOCTotalVolume));
queryrun = new SysQueryRun(query);
}
now I call 2 methods in the run-method of my class to work with the data.
method one wants to process the data from the custtable part of the query and the second method I use for the SalesTable,SalesLine and InventTable data.
CustTable returns with no values (even if they are in the table in my ax.
For SalesTable there is something found but for salesline I get a runtime error.
Here my code to get SaleTable, SalesLine and INventtable:
while(this.queryrun().next())
{
salesTable = this.queryrun().get(tableNum(SalesTable));
salesLine = this.queryrun().get(tableNum(SalesLine));
inventTable = this.queryrun().get(tableNum(InventTable));
*This post is locked for comments
I don't think it's a very good design to have one functionality export to totally different things. And you definetely need two separate queries.
But let's assume your query would work. What is the expected outcome when you iterate your query?
We can assume that you have 8 customers in your database: A, B, C, D, E, F, G, H and I.
And two sales orders, SO1 and SO2.
Now, let's start iterating your query (by calling queryRun.next()).
1. How many iterations do you expect to get? 8 or 2?
2. What CustTable would you expect to get on first iteration?
3. What SalesTable would you expect to get on first iteration?
4. What SalesTable would you expect to get on iterations 3-8?
Like I already suggested, please write an x++ job where you can concentrate only on understanding the Query class, query data sources etc. Once your job produces an expected result, you can apply your learnings to your actual classs.
I want to create 2 files. one for customers (exported to csv) and one for salesTable,salesline and inventtable to export some data
my run method is very simple....it calls 2 methods. 1 to export the custtable data and one for the salestable plus linked tables.
and how I try to get the data in those methods is already posted
I still would like to hear the business requirement. You are only describing your technical solution but it limits us from providing best help.
What is the purpose of the CustTable range? If it's not related to the sales orders that you are iterating?
How does your run method look like? How about all methods that are called from the run method?
#1
Mohamed Amine Mahmoudi
100
Super User 2025 Season 1
#2
Community Member
48
#3
Zain Mehmood
6
Moderator
Share
Report
All responses (
Answers (
