dhis2-devs team mailing list archive

[Morten Olav Hansen <mortenoh@xxxxxxxxx>]

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.

--
Morten

On Fri, Sep 4, 2015 at 3:46 PM, Harsh Atal <harsh.atal@xxxxxxxxx> 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
>
> On 4 September 2015 at 13:32, Morten Olav Hansen <mortenoh@xxxxxxxxx>
> 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@xxxxxxxxx> 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:int
>>>
>>> Is 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@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>