Hi
In the documentation it says (1.6. Meta-data object filter) :-
Get all data elements with aggregation operator “sum” and value type “int”:
/api/dataElements.json?filter=aggregationOperator:eq:sum&filter=type:eq:int
Is this really possible, can I do an AND over multiple filters? may be with another syntax if not this one…
regards
harsh
Hi,
Sorry, seems the docs are a bit out of date. It was sent out on the mailing list a while that this actually changed, all operators are now AND, it is not possible to do any kind of OR operation (but you can use :in:)
On Fri, Sep 4, 2015 at 2:58 PM, Harsh Atal harsh.atal@gmail.com wrote:
Hi
In the documentation it says (1.6. Meta-data object filter) :-
Get all data elements with aggregation operator “sum” and value type “int”:
/api/dataElements.json?filter=aggregationOperator:eq:sum&filter=type:eq:intIs this really possible, can I do an AND over multiple filters? may be with another syntax if not this one…
regards
harsh
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
–
Morten
Thank You Morten,
Could you clarify just this one more thing please :-
What does it mean for the operator gt,lt,ge,le to be applied on a field which is of type string?
For eg what would be compared if I write api/programs?filter=validationCriteria.value:gt:4 ? And the type of validationCriteria.value is string…
Can I achieve this somehow from the API?..comparing a string as though it was an integer through the gt,lt…operators?
regards
harsh
On 4 September 2015 at 13:32, Morten Olav Hansen mortenoh@gmail.com wrote:
Hi,
Sorry, seems the docs are a bit out of date. It was sent out on the mailing list a while that this actually changed, all operators are now AND, it is not possible to do any kind of OR operation (but you can use :in:)
–
Morten
On Fri, Sep 4, 2015 at 2:58 PM, Harsh Atal harsh.atal@gmail.com wrote:
Hi
In the documentation it says (1.6. Meta-data object filter) :-
Get all data elements with aggregation operator “sum” and value type “int”:
/api/dataElements.json?filter=aggregationOperator:eq:sum&filter=type:eq:intIs this really possible, can I do an AND over multiple filters? may be with another syntax if not this one…
regards
harsh
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 Harsh
String also has a numeric value, i.e. “1” is smaller than “2”, so for those simple cases you can use it. But don’t be fooled, this is -string- comparing, not comparing integers.
On Fri, Sep 4, 2015 at 3:46 PM, Harsh Atal harsh.atal@gmail.com wrote:
Thank You Morten,
Could you clarify just this one more thing please :-
What does it mean for the operator gt,lt,ge,le to be applied on a field which is of type string?
For eg what would be compared if I write api/programs?filter=validationCriteria.value:gt:4 ? And the type of validationCriteria.value is string…
Can I achieve this somehow from the API?..comparing a string as though it was an integer through the gt,lt…operators?
regards
harsh
–
Morten
On 4 September 2015 at 13:32, Morten Olav Hansen mortenoh@gmail.com wrote:
Hi,
Sorry, seems the docs are a bit out of date. It was sent out on the mailing list a while that this actually changed, all operators are now AND, it is not possible to do any kind of OR operation (but you can use :in:)
–
Morten
On Fri, Sep 4, 2015 at 2:58 PM, Harsh Atal harsh.atal@gmail.com wrote:
Hi
In the documentation it says (1.6. Meta-data object filter) :-
Get all data elements with aggregation operator “sum” and value type “int”:
/api/dataElements.json?filter=aggregationOperator:eq:sum&filter=type:eq:intIs this really possible, can I do an AND over multiple filters? may be with another syntax if not this one…
regards
harsh
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