907 FROM cw_Note AS _G LEFT OUTER JOIN cw_State AS _S ON (_G.cw_in_state=_S.cw_eid AND _S.cw_name=hop)) AS _T0 ON (rel_tags0.eid_to=_T0.C0)'''), |
907 FROM cw_Note AS _G LEFT OUTER JOIN cw_State AS _S ON (_G.cw_in_state=_S.cw_eid AND _S.cw_name=hop)) AS _T0 ON (rel_tags0.eid_to=_T0.C0)'''), |
908 |
908 |
909 ('Any O,AD WHERE NOT S inline1 O, S eid 123, O todo_by AD?', |
909 ('Any O,AD WHERE NOT S inline1 O, S eid 123, O todo_by AD?', |
910 '''SELECT _O.cw_eid, rel_todo_by0.eid_to |
910 '''SELECT _O.cw_eid, rel_todo_by0.eid_to |
911 FROM cw_Note AS _S, cw_Affaire AS _O LEFT OUTER JOIN todo_by_relation AS rel_todo_by0 ON (rel_todo_by0.eid_from=_O.cw_eid) |
911 FROM cw_Note AS _S, cw_Affaire AS _O LEFT OUTER JOIN todo_by_relation AS rel_todo_by0 ON (rel_todo_by0.eid_from=_O.cw_eid) |
912 WHERE (_S.cw_inline1 IS NULL OR _S.cw_inline1!=_O.cw_eid) AND _S.cw_eid=123''') |
912 WHERE (_S.cw_inline1 IS NULL OR _S.cw_inline1!=_O.cw_eid) AND _S.cw_eid=123'''), |
|
913 |
|
914 ('Any X,AE WHERE X multisource_inlined_rel S?, S ambiguous_inlined A, A modification_date AE', |
|
915 '''SELECT _X.cw_eid, _T0.C2 |
|
916 FROM cw_Card AS _X LEFT OUTER JOIN (SELECT _S.cw_eid AS C0, _A.cw_eid AS C1, _A.cw_modification_date AS C2 |
|
917 FROM cw_Affaire AS _S, cw_CWUser AS _A |
|
918 WHERE _S.cw_ambiguous_inlined=_A.cw_eid |
|
919 UNION ALL |
|
920 SELECT _S.cw_eid AS C0, _A.cw_eid AS C1, _A.cw_modification_date AS C2 |
|
921 FROM cw_CWUser AS _A, cw_Note AS _S |
|
922 WHERE _S.cw_ambiguous_inlined=_A.cw_eid) AS _T0 ON (_X.cw_multisource_inlined_rel=_T0.C0) |
|
923 UNION ALL |
|
924 SELECT _X.cw_eid, _T0.C2 |
|
925 FROM cw_Note AS _X LEFT OUTER JOIN (SELECT _S.cw_eid AS C0, _A.cw_eid AS C1, _A.cw_modification_date AS C2 |
|
926 FROM cw_Affaire AS _S, cw_CWUser AS _A |
|
927 WHERE _S.cw_ambiguous_inlined=_A.cw_eid |
|
928 UNION ALL |
|
929 SELECT _S.cw_eid AS C0, _A.cw_eid AS C1, _A.cw_modification_date AS C2 |
|
930 FROM cw_CWUser AS _A, cw_Note AS _S |
|
931 WHERE _S.cw_ambiguous_inlined=_A.cw_eid) AS _T0 ON (_X.cw_multisource_inlined_rel=_T0.C0)''' |
|
932 ), |
|
933 |
913 ] |
934 ] |
914 |
935 |
915 VIRTUAL_VARS = [ |
936 VIRTUAL_VARS = [ |
916 |
937 |
917 ('Any X WHERE X is CWUser, X creation_date > D1, Y creation_date D1, Y login "SWEB09"', |
938 ('Any X WHERE X is CWUser, X creation_date > D1, Y creation_date D1, Y login "SWEB09"', |