I have an external object from which I want to retrieve certain values avoiding some other ones depending on certain conditions.
The problem is that when I apply the NOT IN filter like in the following
SELECT Id, VALUE__c, DESCRIPTION__c, FROM ZSDFMarcolor__x WHERE VALUE__c NOT IN :valuesToAvoidLIST
It doesn't work and I can see that query is getting me the same values I specify not to retrieve.
Is this some kind of bug or unexpected behavior with external objects? Because I haven't worked that much with them and I don't know what to do.
valuesToAvoidLISTis populated correctly? or if the query is fetching the same results when you hardcode the values in the query like
NOT IN ('value1', 'value2')?
valuesToAvoidLIST(refer this)? Also, are you seeing the same behavior when querying fields other than