Program indicator "hasValue"

Hi devs, I’m trying (in 2.25) to make a program indicator counting events where a specific data element has not been filled.

Tested so far:

  • d2:hasValue(‘wmSb9TmevMn.jeK5z6acB3N’) => not supported in program indicators, only program rules

  • #{wmSb9TmevMn.jeK5z6acB3N} == ‘’ => no data

  • #{wmSb9TmevMn.jeK5z6acB3N} != ‘’ => counts the events WITH data, but I’m unable to «invert» this:

    – !(#{wmSb9TmevMn.jeK5z6acB3N} != ‘’) => no data, catalina.out shows: ERROR: operator does not exist: ! boolean

    – (#{wmSb9TmevMn.jeK5z6acB3N} != ‘’) != true => no data

  • #{wmSb9TmevMn.jeK5z6acB3N} is null => works, but is not a supported format from what I understand.

In general, what is displayed in «Filter description» and what actually works is not consistent - some things are invalid, but work, others are valid but don’t work…

Any advice?

Regards

Olav

Hi again, any advice on this?

Olav

···
  1. feb. 2017 kl. 13.40 skrev Olav Poppe olav.poppe@me.com:

Hi devs, I’m trying (in 2.25) to make a program indicator counting events where a specific data element has not been filled.

Tested so far:

  • d2:hasValue(‘wmSb9TmevMn.jeK5z6acB3N’) => not supported in program indicators, only program rules
  • #{wmSb9TmevMn.jeK5z6acB3N} == ‘’ => no data
  • #{wmSb9TmevMn.jeK5z6acB3N} != ‘’ => counts the events WITH data, but I’m unable to «invert» this:

– !(#{wmSb9TmevMn.jeK5z6acB3N} != ‘’) => no data, catalina.out shows: ERROR: operator does not exist: ! boolean

– (#{wmSb9TmevMn.jeK5z6acB3N} != ‘’) != true => no data

  • #{wmSb9TmevMn.jeK5z6acB3N} is null => works, but is not a supported format from what I understand.

In general, what is displayed in «Filter description» and what actually works is not consistent - some things are invalid, but work, others are valid but don’t work…

Any advice?

Regards

Olav


Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

Hi Olav,
the following syntax is now supported:

  • #{wmSb9TmevMn.jeK5z6acB3N} == ‘’

Jira issue: https://jira.dhis2.org/browse/DHIS2-1185

Best regards,

Markus

···
  1. feb. 2017 kl. 13.40 skrev Olav Poppe olav.poppe@me.com:

Hi devs, I’m trying (in 2.25) to make a program indicator counting events where a specific data element has not been filled.

Tested so far:

  • d2:hasValue(‘wmSb9TmevMn.jeK5z6acB3N’) => not supported in program indicators, only program rules
  • #{wmSb9TmevMn.jeK5z6acB3N} == ‘’ => no data
  • #{wmSb9TmevMn.jeK5z6acB3N} != ‘’ => counts the events WITH data, but I’m unable to «invert» this:

– !(#{wmSb9TmevMn.jeK5z6acB3N} != ‘’) => no data, catalina.out shows: ERROR: operator does not exist: ! boolean

– (#{wmSb9TmevMn.jeK5z6acB3N} != ‘’) != true => no data

  • #{wmSb9TmevMn.jeK5z6acB3N} is null => works, but is not a supported format from what I understand.

In general, what is displayed in «Filter description» and what actually works is not consistent - some things are invalid, but work, others are valid but don’t work…

Any advice?

Regards

Olav


Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

Hi, late follow-up on this - is there a «is empty» syntax for dates as well? I get

ERROR: invalid input syntax for type timestamp: ‘’

and

ERROR: COALESCE types timestamp without time zone and integer cannot be matched

if I use == ‘’ or == 0 respectively for dates.

Olav

···
  1. mar. 2017 kl. 15.24 skrev Markus Bekken markus@dhis2.org:

Hi Olav,
the following syntax is now supported:

  • #{wmSb9TmevMn.jeK5z6acB3N} == ‘’

Jira issue: https://jira.dhis2.org/browse/DHIS2-1185

Best regards,

Markus

  1. feb. 2017 kl. 13.40 skrev Olav Poppe olav.poppe@me.com:

Hi devs, I’m trying (in 2.25) to make a program indicator counting events where a specific data element has not been filled.

Tested so far:

  • d2:hasValue(‘wmSb9TmevMn.jeK5z6acB3N’) => not supported in program indicators, only program rules
  • #{wmSb9TmevMn.jeK5z6acB3N} == ‘’ => no data
  • #{wmSb9TmevMn.jeK5z6acB3N} != ‘’ => counts the events WITH data, but I’m unable to «invert» this:
-- !(#{wmSb9TmevMn.jeK5z6acB3N}  != ‘’) 		=> no data, catalina.out shows: ERROR: operator does not exist: ! boolean
-- (#{wmSb9TmevMn.jeK5z6acB3N}  != '') != true 	=> no data
  • #{wmSb9TmevMn.jeK5z6acB3N} is null => works, but is not a supported format from what I understand.

In general, what is displayed in «Filter description» and what actually works is not consistent - some things are invalid, but work, others are valid but don’t work…

Any advice?

Regards

Olav


Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

Hey Olav,
if you’re on 2.26 or later, d2:hasValue() should work: https://jira.dhis2.org/browse/DHIS2-1245

Markus

···
  1. apr. 2017 kl. 13.09 skrev Olav Poppe olav.poppe@me.com:

Hi, late follow-up on this - is there a «is empty» syntax for dates as well? I get

ERROR: invalid input syntax for type timestamp: ‘’

and

ERROR: COALESCE types timestamp without time zone and integer cannot be matched

if I use == ‘’ or == 0 respectively for dates.

Olav

  1. mar. 2017 kl. 15.24 skrev Markus Bekken markus@dhis2.org:

Hi Olav,
the following syntax is now supported:

  • #{wmSb9TmevMn.jeK5z6acB3N} == ‘’

Jira issue: https://jira.dhis2.org/browse/DHIS2-1185

Best regards,

Markus

  1. feb. 2017 kl. 13.40 skrev Olav Poppe olav.poppe@me.com:

Hi devs, I’m trying (in 2.25) to make a program indicator counting events where a specific data element has not been filled.

Tested so far:

  • d2:hasValue(‘wmSb9TmevMn.jeK5z6acB3N’) => not supported in program indicators, only program rules
  • #{wmSb9TmevMn.jeK5z6acB3N} == ‘’ => no data
  • #{wmSb9TmevMn.jeK5z6acB3N} != ‘’ => counts the events WITH data, but I’m unable to «invert» this:
-- !(#{wmSb9TmevMn.jeK5z6acB3N}  != ‘’) 		=> no data, catalina.out shows: ERROR: operator does not exist: ! boolean
-- (#{wmSb9TmevMn.jeK5z6acB3N}  != '') != true 	=> no data
  • #{wmSb9TmevMn.jeK5z6acB3N} is null => works, but is not a supported format from what I understand.

In general, what is displayed in «Filter description» and what actually works is not consistent - some things are invalid, but work, others are valid but don’t work…

Any advice?

Regards

Olav


Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

Great, thanks.

Olav

···
  1. apr. 2017 kl. 21.27 skrev Markus Bekken markus@dhis2.org:

Hey Olav,
if you’re on 2.26 or later, d2:hasValue() should work: https://jira.dhis2.org/browse/DHIS2-1245

Markus

  1. apr. 2017 kl. 13.09 skrev Olav Poppe olav.poppe@me.com:

Hi, late follow-up on this - is there a «is empty» syntax for dates as well? I get

ERROR: invalid input syntax for type timestamp: ‘’

and

ERROR: COALESCE types timestamp without time zone and integer cannot be matched

if I use == ‘’ or == 0 respectively for dates.

Olav

  1. mar. 2017 kl. 15.24 skrev Markus Bekken markus@dhis2.org:

Hi Olav,
the following syntax is now supported:

  • #{wmSb9TmevMn.jeK5z6acB3N} == ‘’

Jira issue: https://jira.dhis2.org/browse/DHIS2-1185

Best regards,

Markus

  1. feb. 2017 kl. 13.40 skrev Olav Poppe olav.poppe@me.com:

Hi devs, I’m trying (in 2.25) to make a program indicator counting events where a specific data element has not been filled.

Tested so far:

  • d2:hasValue(‘wmSb9TmevMn.jeK5z6acB3N’) => not supported in program indicators, only program rules
  • #{wmSb9TmevMn.jeK5z6acB3N} == ‘’ => no data
  • #{wmSb9TmevMn.jeK5z6acB3N} != ‘’ => counts the events WITH data, but I’m unable to «invert» this:
-- !(#{wmSb9TmevMn.jeK5z6acB3N}  != ‘’) 		=> no data, catalina.out shows: ERROR: operator does not exist: ! boolean
-- (#{wmSb9TmevMn.jeK5z6acB3N}  != '') != true 	=> no data
  • #{wmSb9TmevMn.jeK5z6acB3N} is null => works, but is not a supported format from what I understand.

In general, what is displayed in «Filter description» and what actually works is not consistent - some things are invalid, but work, others are valid but don’t work…

Any advice?

Regards

Olav


Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp