Apex Code Development You need to sign in to do that
Don't have an account?
Richard punctuation in queries
I'm using the 2.0 version of the api to query data using complex query filters.
I have not noticed this problem before but when I build a complex query using a phrase as the value to search for which contains punctuation such as a full stop, the query never returns any results.
should I expect this behaviour?
Should I be encoding my search values in some way?
If anyone can point me in the right direction on this one I would be very grateful.
All the best,
Richard
I have not noticed this problem before but when I build a complex query using a phrase as the value to search for which contains punctuation such as a full stop, the query never returns any results.
should I expect this behaviour?
Should I be encoding my search values in some way?
If anyone can point me in the right direction on this one I would be very grateful.
All the best,
Richard
Hi Richard,
I can duplicate the problem. Can you provide additional information? Are you using equals, contains, starts with or something else in your filter? By complex I assume you mean you have more that one criteria, correct? If correct, can you tell me what other criteria you are using? Is it possible for you to capture the xml-rpc request and post it here?
eeek!
I've resolved this! My query was removing some keywords and not the associated punctuation!!
Using a starts with condition it was never finding the account with the punctuation in the wrong place. appologies for wasting your time!
Richard