SemQL Filters
- Anna Rider (Deactivated)
- François-Xavier NICOLAS
- Peter Tse
Owned by Anna Rider (Deactivated)
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.
PersonType = 'CUSTOMER' AND NOT ANY PersonProducts HAVE ( ID is not null )
In Customer B2C, search for Customer records that come only from Marketing Publisher.
PersonType ='CUSTOMER' AND ANY MasterRecords HAVE (PublisherID = 'MKT') AND NOT ANY MasterRecords HAVE (PublisherID = 'CRM')
Related articles