equal
deleted
inserted
replaced
744 '''SELECT DISTINCT P.pkey, P.value |
744 '''SELECT DISTINCT P.pkey, P.value |
745 FROM EProperty AS P |
745 FROM EProperty AS P |
746 WHERE P.for_user IS NULL'''), |
746 WHERE P.for_user IS NULL'''), |
747 |
747 |
748 ('Any S WHERE NOT X in_state S, X is IN(Affaire, EUser)', |
748 ('Any S WHERE NOT X in_state S, X is IN(Affaire, EUser)', |
749 '''SELECT S.eid |
749 '''SELECT DISTINCT S.eid |
750 FROM Affaire AS X, State AS S |
750 FROM Affaire AS X, State AS S |
751 WHERE (X.in_state IS NULL OR X.in_state!=S.eid) |
751 WHERE (X.in_state IS NULL OR X.in_state!=S.eid) |
752 INTERSECT |
752 INTERSECT |
753 SELECT S.eid |
753 SELECT DISTINCT S.eid |
754 FROM EUser AS X, State AS S |
754 FROM EUser AS X, State AS S |
755 WHERE (X.in_state IS NULL OR X.in_state!=S.eid)'''), |
755 WHERE (X.in_state IS NULL OR X.in_state!=S.eid)'''), |
756 ] |
756 ] |
757 |
757 |
758 OUTER_JOIN = [ |
758 OUTER_JOIN = [ |