'Not In' object query
'Not In' object query
If I have a client object and a transaction object, is there a query I can run to return all clients that do not have a transaction on a specified date ?
-
- Posts: 595
- Joined: Sun Apr 24, 2005 2:22 am
- Contact:
Yes. Your query could look like this:
FIND Client WHERE NOT(EXISTS Transaction WHERE (Transaction.Client = Client AND Transaction.MadeOn = ?'Transaction Date'))
This query will display a window to let the user specify the desired date. You can, of course, replace the prompt (the ?'Transaction Date' part) with a date that, for example, is an attribute of an object available in the context, or a function that produces result of type Date.
FIND Client WHERE NOT(EXISTS Transaction WHERE (Transaction.Client = Client AND Transaction.MadeOn = ?'Transaction Date'))
This query will display a window to let the user specify the desired date. You can, of course, replace the prompt (the ?'Transaction Date' part) with a date that, for example, is an attribute of an object available in the context, or a function that produces result of type Date.
Aware IM Support Team