equal
deleted
inserted
replaced
181 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))))'''), |
181 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))))'''), |
182 |
182 |
183 ] |
183 ] |
184 |
184 |
185 |
185 |
186 ADVANCED= [ |
186 ADVANCED = [ |
187 ("Societe S WHERE S nom 'Logilab' OR S nom 'Caesium'", |
187 ("Societe S WHERE S nom 'Logilab' OR S nom 'Caesium'", |
188 '''SELECT _S.cw_eid |
188 '''SELECT _S.cw_eid |
189 FROM cw_Societe AS _S |
189 FROM cw_Societe AS _S |
190 WHERE ((_S.cw_nom=Logilab) OR (_S.cw_nom=Caesium))'''), |
190 WHERE ((_S.cw_nom=Logilab) OR (_S.cw_nom=Caesium))'''), |
191 |
191 |
570 ORDER BY T1.C2'''), |
570 ORDER BY T1.C2'''), |
571 |
571 |
572 ('Any 1 WHERE X in_group G, X is CWUser', |
572 ('Any 1 WHERE X in_group G, X is CWUser', |
573 '''SELECT 1 |
573 '''SELECT 1 |
574 FROM in_group_relation AS rel_in_group0'''), |
574 FROM in_group_relation AS rel_in_group0'''), |
|
575 |
|
576 ('CWEType X WHERE X name CV, X description V HAVING NOT V=CV AND NOT V = "parent"', |
|
577 '''SELECT _X.cw_eid |
|
578 FROM cw_CWEType AS _X |
|
579 WHERE NOT (EXISTS(SELECT 1 WHERE _X.cw_description=parent)) AND NOT (EXISTS(SELECT 1 WHERE _X.cw_description=_X.cw_name))'''), |
575 ] |
580 ] |
576 |
581 |
577 |
582 |
578 MULTIPLE_SEL = [ |
583 MULTIPLE_SEL = [ |
579 ("DISTINCT Any X,Y where P is Personne, P nom X , P prenom Y;", |
584 ("DISTINCT Any X,Y where P is Personne, P nom X , P prenom Y;", |