SemQL Filters

Owned by Anna Rider (Deactivated)
Last updated: Jul 15, 2019 by FX NicolasVersion comment
1 min read

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')