Filter OData query with not contains

(0) Share

Report

Posted on by Community Power Pla...

Hi,

Trying to create a filter on my get items to filter out results that don't fit the below criteria.

Entries need to have a ship date (Field9) of yesterday (-1 day)

Entries doesn't contain C-EXV in field 2

This is my query so far which isnt working

field_9 eq '@{formatDateTime(addDays(utcNow(),-1), 'dd-MM-yyyy')}' and not(contains(item()?['field2'], 'C-EXV'))

The query to filter out all items where the ship date wasnt yesterday works by its self (field_9 eq '@{formatDateTime(addDays(utcNow(),-1), 'dd-MM-yyyy')}') but when i add in the latter part this doesnt work.

Any help would be appreciated.

Categories:

Recommendations

All responses (2)

Answers (0)

mvn 32 on at

Like (0)

Report
Re: Filter OData query with not contains

not contains doesn't work with odata filter query but can use 'not' like this:

$filter=not(startswith(fieldName,'text to search'))
RobElliott 10,138 Super User 2025 Season 1 on at

Like (1)

Report

Re: Filter OData query with not contains

@hodgson41 you can't use not(contains) in a filter query. Have a look at the blog post by Tom Riha here which shows what you can do instead.