Segmentation: Support "IS NULL" and "IS NOT NULL" type queries #3932

Closed
mattab opened this Issue May 12, 2013 · 2 comments

1 participant

@mattab
Piwik Open Source Analytics member

It would be useful to allow segments to match visitors for which a given value is "NULL" (empty). For example, select all visitors that do not have a "custom variable 1" set.

Similarly, it would be useful to select all visitors, where a particular field (eg. "referrer keyword") is NOT NULL, ie. not empty nor NULL.

This feature is available by doing:
referrerKeyword==
will select all visitors that don't have a keyword set, or
referrerKeyword!=
will select all visitors that have a keyword set.

@mattab
Piwik Open Source Analytics member

In d89a08b: Fixes #3932

  • you can now write browserCode==ff;referrerKeyword!= to select all visitors using firefox and that have a keyword set
  • or you can write referrerKeyword==;browserCode==ff to select all visitors using firefox and that did not have any keyword set Also fixes #3933

Refs #2135

  • fixing last bugs with segment selector encoding (working on chrome + FF + opera) - I 'hope' it will work on iE...
@mattab
Piwik Open Source Analytics member
@mattab mattab added this to the 1.12 - The Great 1.x Backlog milestone Jul 8, 2014
@mattab mattab self-assigned this Jul 8, 2014
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment