Examples of complex SemQL Filters to supplement the sparse examples in the SemQL Reference Guide.
In Customer B2C, search for Customer records that have zero customer products associated.
| Code Block |
|---|
PersonType = 'CUSTOMER' AND NOT ANY PersonProducts HAVE ( ID is not null ) |
In Customer B2C, search for Customer records that come only from Marketing Publisher.
| Code Block |
|---|
PersonType ='CUSTOMER' AND ANY MasterRecords HAVE (PublisherID = 'MKT') AND NOT ANY MasterRecords HAVE (PublisherID = 'CRM') |
...