Showing objects with empty childobject

Rem

(Maybe a simple question, or we may overthink this a bit so bear with us..)

We are trying to run query wich will show all objects thas has a certain childobject as undefined.

The childobject is multiple.

We have tried several approached but the best we can come up with is a calculated field which SHOWS the object which HAS somthing in this child object (which is the opposite of what we are trying to do).

Basically we are writing an errand system and we want to show which customer that has no errands, which could indicate that something in wrong, since there should be no customers with 0 errands

weblike

FIND Parent_BO WHERE COUNT Child_BO WHERE (Child_BO IN Parent_BO.Childs)=0

tford

You can add an attribute to the parent BO to count the children and add a rule to keep that attribute up to date with the number of children.

Use that counter in your query.

I typically use the counter approach as I find that I want to know that info @ multiple times.

Rem

Thanks!

Solved the problem!

Been away for 7 years so have to wrap my head arround this again!

Rem

weblike wrote
FIND Parent_BO WHERE COUNT Child_BO WHERE (Child_BO IN Parent_BO.Childs)=0

Thanks!

This also helped!