We have a query built on which students should get admission cards, this is based on parent balances, certain staff and if children are on certain programs. So there could be a family that has one child that was issued an Admission card because that kid is in a program that triggers that he should get and there could be a second child in the family that shouldn’t get.
How can we query to get a parent list of ones that require follow ups because one or more kids didn’t get the card.
If we exclude an account that has the admission card type and value or single flag printed, it will exclude the above mentioned account because there is a child that has that flag or type and value.
An option to INCLUDE and account that doesn’t have this flag or value would resolve this. This comes up many times when we want to get a list of people that don’t have a certain flag flagged which can be different per different children in the family.