X++:
Query query = new Query();
QueryBuildDataSource calendarDep_qbds = query.addDataSource(tableNum(RPayCalendarDeport));
QueryBuildDataSource emplTable_qbds = calendarDep_qbds.addDataSource(tableNum(EmplTable));
QueryBuildDataSource emplCompany_qbds = emplTable_qbds.addDataSource(tableNum(sysCompanyUserInfo));
;
emplTable_qbds.relations(false);
//тут точно определите связь
emplTable_qbds.addLink(fieldNum(RPayCalendarDeport, PayHRMOrganizationId_RU), fieldNum(EmplTable, PayHRMOrganizationId_RU));
emplCompany_qbds.addRange(fieldNum(SysCompanyUserInfo, UserId)).value(queryValue(curUserId()));
emplCompany_qbds.relations(true);
// Should return the same values as Query
while select calendarDep
where calendarDep.PayHRMOrganizationId_RU == emplTbl.PayHRMOrganizationId_RU
exists join emplTbl
exists join emplCompany
where emplCompany.UserId == curUserId()
&& emplCompany.EmplId == emplTable.EmplId
{
//....
}
Это тот query, который можно вставить в форму лукапа, запрос приведен для проверки, по идее это одно и тоже.