Skip to content

$filter using tolower() and 'and' not working as expected #222

@nkim-radley

Description

@nkim-radley

Odata toLower is not implemented.

Does not work:
...?$filter=(contains(tolower(FieldA),'a))

Works:
...?$filter=(contains(tolower(FieldA),'A'))



And $filter using and aren't returning correct records for the following:

...?$filter=(contains(tolower(FieldA),'A')) and ((FieldB eq 'B') and (FieldC eq 'C'))

Which I would expect should return a record with values like the following:

{
            "FieldA": "A",
            "FieldB ": "B",
            "FieldC ": "C",
}

I get the above record when I separate the filter in the following ways:

...?$filter=(contains(tolower(FieldA),'A'))

...?$filter=((FieldB eq 'B') and (FieldC eq 'C'))

But when I run the $filter separating the two with an and, I get no records back.

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions