-
Improvement
-
Resolution: Unresolved
-
Neutral
-
None
When filtering events using the webhooks module, you're unable to use the NOT LIKE expression
See the expected use case below for an example:
filter: "(@nodeType = 'mgnl:folder' or @nodeType = 'dotcom:our-product') and not (@path LIKE '/sanofi-br%' or @path LIKE '/sanofi-cn%' or @path LIKE '/sanofi-de%' or @path LIKE '/sanofi-fr%' or @path LIKE '/sanofi-jp%' or @path LIKE '/sanofi-uk%' or @path LIKE '/sanofi-us%')"
Context:
The light module developer would like to have the following filter:
- nodeType is 'mgnl:folder' or 'dotcom:our-product'
- The path should NOT CONTAIN /sanofi-br, /sanofi-cn, /sanofi-de, /sanofi-fr, /sanofi-jp, /sanofi-uk, /sanofi-us
The reason for this filter is that specifying the OK paths would result in a longer filter (there are 40 paths), instead of just negating these 7 paths.
Acceptance criteria