/
SemQL Filters

SemQL Filters

By Anna Rider (Deactivated)
Jul 15, 2019

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 content