Error Using "Count" in a Read

[Louis Pace]

The following code successfully finds tasks that are not associated with any agencies:

(Task'read '() '(= (count (@ agencies)) 0) '() '() '() '())

1	(Task'read '() '(= (count (@ agencies)) 0) '() '() '() '())

This, however, does not work:

(TaskEntity'read '() '(= (count (@ act agencies)) 0) '() '() '() '())

1	(TaskEntity'read '() '(= (count (@ act agencies)) 0) '() '() '() '())

The “act” attribute of TaskEntity is a task. The error is “ORA-00934: group function is not allowed here”. The generated SQL is:

; 16:14:07,483 DEBUG [SQLAdapter] (NexJ Main) select A.entityId, A.actId, A.locking from NJTaskEntity A, NJAct B where A.actId = B.id and B.deletedFlag = :1 and B.viewPrincipalId in (:2, :3, :4, :5, :6) and count(D.id) = :7 ; 16:14:07,485 DEBUG [SQLAdapter] (NexJ Main) Bind[0] = 0 ; 16:14:07,487 DEBUG [SQLAdapter] (NexJ Main) Bind[1] = 31DE7B1B9BDA4DE180FC6829966FF9C0 ; 16:14:07,489 DEBUG [SQLAdapter] (NexJ Main) Bind[2] = 5D90A8F1047146918A140D49D4238E60 ; 16:14:07,490 DEBUG [SQLAdapter] (NexJ Main) Bind[3] = 00000000000010008000BEEF0000000C ; 16:14:07,493 DEBUG [SQLAdapter] (NexJ Main) Bind[4] = 5DC3A6C7ED43413BB19B011727DECBE0 ; 16:14:07,495 DEBUG [SQLAdapter] (NexJ Main) Bind[5] = 00000000000010008000BEEF0000000A ; 16:14:07,497 DEBUG [SQLAdapter] (NexJ Main) Bind[6] = 0

1 2 3 4 5 6 7 8

; 16:14:07,483 DEBUG [SQLAdapter] (NexJ Main) select A.entityId, A.actId, A.locking from NJTaskEntity A, NJAct B where A.actId = B.id and B.deletedFlag = :1 and B.viewPrincipalId in (:2, :3, :4, :5, :6) and count(D.id) = :7 ; 16:14:07,485 DEBUG [SQLAdapter] (NexJ Main) Bind[0] = 0 ; 16:14:07,487 DEBUG [SQLAdapter] (NexJ Main) Bind[1] = 31DE7B1B9BDA4DE180FC6829966FF9C0 ; 16:14:07,489 DEBUG [SQLAdapter] (NexJ Main) Bind[2] = 5D90A8F1047146918A140D49D4238E60 ; 16:14:07,490 DEBUG [SQLAdapter] (NexJ Main) Bind[3] = 00000000000010008000BEEF0000000C ; 16:14:07,493 DEBUG [SQLAdapter] (NexJ Main) Bind[4] = 5DC3A6C7ED43413BB19B011727DECBE0 ; 16:14:07,495 DEBUG [SQLAdapter] (NexJ Main) Bind[5] = 00000000000010008000BEEF0000000A ; 16:14:07,497 DEBUG [SQLAdapter] (NexJ Main) Bind[6] = 0

I’m assuming this is a bug? Only the A and B aliases are declared. Where did the D in the count come from? A and B join the TaskEntity table with the Act table (where tasks are stored), but agencies don’t seem to be referenced. What is going wrong, and is there some other way to read from the TaskEntity level?

Thanks for your help!

0

[Steve]

That is indeed a bug.  You can probably work around it by using the “any” function, e.g.
(TaskEntity’read ‘() `(not (any (@ act agencies))) ‘() ‘() ‘() ‘())

 

 

0

[Louis Pace]

Thanks, Steve. The “any” trick appears to work. Is there anything I need to do to report this bug, or does this forum post suffice?

0

[Author]

Posts