SemQL Filters

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

Semarchy Knowledge Base