Opened 11 months ago

Closed 11 months ago

Last modified 11 months ago

#3932 closed New feature (fixed)

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

Reported by: matt Owned by: mattab
Priority: normal Milestone: 1.12 - The Great 1.x Backlog
Component: Core Keywords:
Cc: Sensitive: no

Description

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.

Change History (2)

comment:1 Changed 11 months ago by matt (mattab)

  • Owner set to mattab
  • Resolution set to fixed
  • Status changed from new to closed

In d89a08b8b27ef9a7293e9f8cf351bedbd838e2cb:

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...
Note: See TracTickets for help on using tickets.