534 WHERE NOT (EXISTS(SELECT 1 WHERE _X.cw_description=parent)) AND NOT (EXISTS(SELECT 1 WHERE _X.cw_description=_X.cw_name))'''), |
534 WHERE NOT (EXISTS(SELECT 1 WHERE _X.cw_description=parent)) AND NOT (EXISTS(SELECT 1 WHERE _X.cw_description=_X.cw_name))'''), |
535 ('CWEType X WHERE X name CV, X description V HAVING V!=CV AND V != "parent"', |
535 ('CWEType X WHERE X name CV, X description V HAVING V!=CV AND V != "parent"', |
536 '''SELECT _X.cw_eid |
536 '''SELECT _X.cw_eid |
537 FROM cw_CWEType AS _X |
537 FROM cw_CWEType AS _X |
538 WHERE _X.cw_description!=parent AND _X.cw_description!=_X.cw_name'''), |
538 WHERE _X.cw_description!=parent AND _X.cw_description!=_X.cw_name'''), |
|
539 |
|
540 ('DISTINCT Any X, SUM(C) GROUPBY X ORDERBY SUM(C) DESC WHERE H todo_by X, H duration C', |
|
541 '''SELECT DISTINCT rel_todo_by0.eid_to, SUM(_H.cw_duration) |
|
542 FROM cw_Affaire AS _H, todo_by_relation AS rel_todo_by0 |
|
543 WHERE rel_todo_by0.eid_from=_H.cw_eid |
|
544 GROUP BY rel_todo_by0.eid_to |
|
545 ORDER BY 2 DESC'''), |
|
546 |
539 ] |
547 ] |
540 |
548 |
541 ADVANCED_WITH_GROUP_CONCAT = [ |
549 ADVANCED_WITH_GROUP_CONCAT = [ |
542 ("Any X,GROUP_CONCAT(TN) GROUPBY X ORDERBY XN WHERE T tags X, X name XN, T name TN, X is CWGroup", |
550 ("Any X,GROUP_CONCAT(TN) GROUPBY X ORDERBY XN WHERE T tags X, X name XN, T name TN, X is CWGroup", |
543 '''SELECT _X.cw_eid, GROUP_CONCAT(_T.cw_name) |
551 '''SELECT _X.cw_eid, GROUP_CONCAT(_T.cw_name) |