162 ("Any X WHERE X prenom 'lulu'," |
162 ("Any X WHERE X prenom 'lulu'," |
163 "NOT EXISTS(X owned_by U, U in_group G, G name 'lulufanclub' OR G name 'managers');", |
163 "NOT EXISTS(X owned_by U, U in_group G, G name 'lulufanclub' OR G name 'managers');", |
164 '''SELECT _X.cw_eid |
164 '''SELECT _X.cw_eid |
165 FROM cw_Personne AS _X |
165 FROM cw_Personne AS _X |
166 WHERE _X.cw_prenom=lulu AND NOT EXISTS(SELECT 1 FROM owned_by_relation AS rel_owned_by0, in_group_relation AS rel_in_group1, cw_CWGroup AS _G WHERE rel_owned_by0.eid_from=_X.cw_eid AND rel_in_group1.eid_from=rel_owned_by0.eid_to AND rel_in_group1.eid_to=_G.cw_eid AND ((_G.cw_name=lulufanclub) OR (_G.cw_name=managers)))'''), |
166 WHERE _X.cw_prenom=lulu AND NOT EXISTS(SELECT 1 FROM owned_by_relation AS rel_owned_by0, in_group_relation AS rel_in_group1, cw_CWGroup AS _G WHERE rel_owned_by0.eid_from=_X.cw_eid AND rel_in_group1.eid_from=rel_owned_by0.eid_to AND rel_in_group1.eid_to=_G.cw_eid AND ((_G.cw_name=lulufanclub) OR (_G.cw_name=managers)))'''), |
|
167 |
|
168 |
|
169 |
167 ] |
170 ] |
168 |
171 |
169 ADVANCED= [ |
172 ADVANCED= [ |
170 ("Societe S WHERE S nom 'Logilab' OR S nom 'Caesium'", |
173 ("Societe S WHERE S nom 'Logilab' OR S nom 'Caesium'", |
171 '''SELECT _S.cw_eid |
174 '''SELECT _S.cw_eid |
865 FROM cw_Affaire AS _O LEFT OUTER JOIN todo_by_relation AS rel_todo_by0 ON (rel_todo_by0.eid_from=_O.cw_eid), cw_Note AS _S |
868 FROM cw_Affaire AS _O LEFT OUTER JOIN todo_by_relation AS rel_todo_by0 ON (rel_todo_by0.eid_from=_O.cw_eid), cw_Note AS _S |
866 WHERE NOT EXISTS(SELECT 1 WHERE _S.cw_inline1=_O.cw_eid) AND _S.cw_eid=123''') |
869 WHERE NOT EXISTS(SELECT 1 WHERE _S.cw_inline1=_O.cw_eid) AND _S.cw_eid=123''') |
867 ] |
870 ] |
868 |
871 |
869 VIRTUAL_VARS = [ |
872 VIRTUAL_VARS = [ |
870 ("Personne P WHERE P travaille S, S tel T, S fax T, S is Societe;", |
873 |
|
874 ('Any X WHERE X is CWUser, X creation_date > D1, Y creation_date D1, Y login "SWEB09"', |
|
875 '''SELECT _X.cw_eid |
|
876 FROM cw_CWUser AS _X, cw_CWUser AS _Y |
|
877 WHERE _X.cw_creation_date>_Y.cw_creation_date AND _Y.cw_login=SWEB09'''), |
|
878 |
|
879 ('Any X WHERE X is CWUser, Y creation_date D1, Y login "SWEB09", X creation_date > D1', |
|
880 '''SELECT _X.cw_eid |
|
881 FROM cw_CWUser AS _X, cw_CWUser AS _Y |
|
882 WHERE _Y.cw_login=SWEB09 AND _X.cw_creation_date>_Y.cw_creation_date'''), |
|
883 |
|
884 ('Personne P WHERE P travaille S, S tel T, S fax T, S is Societe', |
871 '''SELECT rel_travaille0.eid_from |
885 '''SELECT rel_travaille0.eid_from |
872 FROM cw_Societe AS _S, travaille_relation AS rel_travaille0 |
886 FROM cw_Societe AS _S, travaille_relation AS rel_travaille0 |
873 WHERE rel_travaille0.eid_to=_S.cw_eid AND _S.cw_fax=_S.cw_tel'''), |
887 WHERE rel_travaille0.eid_to=_S.cw_eid AND _S.cw_tel=_S.cw_fax'''), |
874 |
888 |
875 ("Personne P where X eid 0, X creation_date D, P datenaiss < D, X is Affaire", |
889 ("Personne P where X eid 0, X creation_date D, P datenaiss < D, X is Affaire", |
876 '''SELECT _P.cw_eid |
890 '''SELECT _P.cw_eid |
877 FROM cw_Affaire AS _X, cw_Personne AS _P |
891 FROM cw_Affaire AS _X, cw_Personne AS _P |
878 WHERE _X.cw_eid=0 AND _P.cw_datenaiss<_X.cw_creation_date'''), |
892 WHERE _X.cw_eid=0 AND _P.cw_datenaiss<_X.cw_creation_date'''), |