08-30-2018 01:57 AM
Hi, we've posted this before but I cannot find the topic anymore.
When will contains(name, value) eq false be supported? We need this for our Exact/Act! sync to give the customer the ability to filter out companies for syncing (for example all companies whose field XX does NOT contain 'nosync'
11-02-2018 12:46 PM
I don't see any support for that in the OData version we are using. However, I could implement a substringof(name, 'Office') eq false.
I will research how we can do this, but I don't think I will be able to get this in the next release, but I will try.
11-05-2018 06:50 AM - edited 11-05-2018 06:51 AM
I have added “not contains” at its simplest form. Meaning you can’t use functions in junction with each other, but you can use other filters.
Supports things like:
/api/companies?$filter=not contains(name, 'Brass')
/api/companies?$filter=not contains(name, 'Brass') and description eq ‘RTS Games’
But does not support:
/api/companies?$filter=not contains(name, 'Brass') or contains(description, ‘Test’)