X++:
CustTable custTable;
SalesTable salesTable;
Query query;
QueryBuildDataSource qbdsCustTable;
QueryBuildDataSource qbdsSalesTable;
QueryBuildRange qbr;
QueryBuildRange qbr2;
QueryRun queryRun;
int idx;
;
query = new Query();
qbdsCustTable = query.addDataSource(tableNum(CustTable));
qbdsSalesTable = qbdsCustTable.addDataSource(tableNum(SalesTable));
qbdsSalesTable.relations(true);
qbr = qbdsSalesTable.addRange(fieldNum(SalesTable, TableId));
qbr.value(strfmt('((%1.%2 like "%3") || (%4.%5 like "%6"))',
qbdsCustTable.name(),
fieldStr(CustTable, AccountNum),
'*000018',
qbdsSalesTable.name(),
fieldStr(SalesTable, CustAccount),
'*000018'));
queryRun = new QueryRun(query);
while (queryRun.next())
{
custTable = queryRun.get(tableNum(CustTable));
salesTable = queryRun.get(tableNum(SalesTable));
idx++;
if (idx == 5)
{
break;
}
info(strFmt("%1 %2", salesTable.SalesId, custTable.AccountNum));
}
info(strFmt("%1", idx));
Вот это у меня в Ах4 не работает, в Ах12 работает