Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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. 

Code Block
PersonType = 'CUSTOMER' AND NOT ANY PersonProducts HAVE ( ID is not null )

In Customer B2C, search for Customer records that come only from Marketing Publisher.

Code Block
PersonType ='CUSTOMER' AND ANY MasterRecords HAVE (PublisherID = 'MKT') AND NOT ANY MasterRecords HAVE (PublisherID = 'CRM')


Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@140ea
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ("semql","filter","filters") and type = "page" and space = "SKB"
labelsfilter filters semql

...

Page Properties
hiddentrue


Related issues