Юлия Кузнецова вот программный вариант предложенный Максимом:
PHP код:
Query query = new Query();
QueryBuildDataSource inventTableDS, purchLineDS,salesLineDS;
PurchPrice purchPriceValue;
SalesPrice salesPriceValue;
;
salesPriceValue = 10;
purchPriceValue = 20;
inventTableDS = query.addDataSource(tablenum(InventTable));
purchLineDS = inventTableDS.addDataSource(tablenum(PurchLine));
purchLineDS.relations(true);
purchLineDS.fetchMode(QueryFetchMode::One2Many);
purchLineDS.joinMode(JoinMode::ExistsJoin);
purchLineDS.addRange(fieldnum(PurchLine,PurchPrice )).value(SysQuery::value(purchPriceValue));
salesLineDS = purchLineDS.addDataSource(tablenum(salesLine));
salesLineDS.addLink(fieldnum(PurchLine,ItemId),fieldnum(SalesLine,ItemId));
salesLineDS.joinMode(JoinMode::ExistsJoin);
salesLineDS.addRange(fieldnum(SalesLine,SalesPrice)).value(SysQuery::value(salesPriceValue));
Если подходит - берите и пользуйтесь!