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') |
Related articles
| Filter by label (Content by label) |
|---|
| showLabels | false |
|---|
| max | 5 |
|---|
| spaces | com.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@140ea |
|---|
| showSpace | false |
|---|
| sort | modified |
|---|
| reverse | true |
|---|
| type | page |
|---|
| cql | label in ( "semql" , "filter" , "filters" ) and type = "page" and space = "SKB" |
|---|
| labels | filter filters semql |
|---|
|
...