31.01.2024, 18:53 | #11 |
Участник
|
X++: (@P1 bigint,@P2 bigint,@P3 int,@P4 int,@P5 int,@P6 int,@P7 int,@P8 int) SELECT T1.CHILDPARTY,T1.LEGALENTITYDATAAREAID,T1.PARENTPARTY,T1.RELATIONSHIPTYPEID, T1.VALIDFROM,T1.VALIDFROMTZID,T1.VALIDTO,T1.VALIDTOTZID,T1.SCHEMAVERSION,T1.RECVERSION, T1.PARTITION,T1.RECID,T2.CHILDPARENTNAME,T2.CHILDPARTYTYPE,T2.DESCRIPTION, T2.ISSYMMETRIC,T2.PARENTCHILDNAME,T2.PARENTPARTYTYPE,T2.RELATIONSHIPTYPEID,T2.SYSTEMTYPE, T2.RECVERSION,T2.PARTITION,T2.RECID,T3.NAME,T3.RECVERSION,T3.RECID,T3.INSTANCERELATIONTYPE,T4.NAME,T4.RECVERSION,T4.RECID, T4.INSTANCERELATIONTYPE FROM DIRPARTYRELATIONSHIP T1 CROSS JOIN DIRRELATIONSHIPTYPETABLE T2 LEFT OUTER JOIN DIRPARTYTABLE T3 ON ((T3.PARTITION=5637144576) AND (T1.CHILDPARTY=T3.RECID)) LEFT OUTER JOIN DIRPARTYTABLE T4 ON ((T4.PARTITION=5637144576) AND (T1.PARENTPARTY=T4.RECID)) WHERE ((T1.PARTITION=5637144576) AND ((T1.PARENTPARTY=@P1) OR (T1.CHILDPARTY=@P2))) AND ((T2.PARTITION=5637144576) AND (((T2.SYSTEMTYPE<@P3) OR (T2.SYSTEMTYPE>@P4)) AND (T1.RELATIONSHIPTYPEID=T2.RELATIONSHIPTYPEID))) AND (EXISTS (SELECT 'x' FROM DIRPARTYRELATIONSHIPSUNIONVIEW T5 WHERE ((T5.PARTITION=5637144576) AND (((T5.SYSTEMTYPE<@P5) OR (T5.SYSTEMTYPE>@P6)) AND (T1.CHILDPARTY=T5.OTHERPARTY))))) AND (EXISTS (SELECT 'x' FROM DIRPARTYRELATIONSHIPSUNIONVIEW T6 WHERE ((T6.PARTITION=5637144576) AND (((T6.SYSTEMTYPE<@P7) OR (T6.SYSTEMTYPE>@P8)) AND (T1.PARENTPARTY=T6.OTHERPARTY))))) ORDER BY T1.VALIDFROM DESC OPTION(FAST 8) В dirPartyRelationship 284046 записи В dirRelationshipTypeTable 42 записи В трейспарсере то же самое, но с подставленными значениями Последний раз редактировалось Lankey; 31.01.2024 в 18:57. |
|
Теги |
d365 |
|
|