Community
Showing results for 
Search instead for 
Do you mean 
Reply

contains(name, value) eq false still does not work

Copper Contributor
Posts: 180
Country: Netherlands

contains(name, value) eq false still does not work

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'

Greetings,

ACT Certified Consultants
TendenZ
the Netherlands
Employee
Posts: 109
Country: USA

Re: contains(name, value) eq false still does not work

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.

Employee
Posts: 109
Country: USA

Re: contains(name, value) eq false still does not work

[ Edited ]

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’)

Employee
Posts: 109
Country: USA

Re: contains(name, value) eq false still does not work

I should also note, that this is only implemented on Companies and Contacts right now.  Are there other entities that you need this on at this time?