Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Current »

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




  • No labels