Filter lookup with XML and special character '&' does not work

(1) Share

Report

Posted on by Thibaut C

Hello,

I am currently trying to filter a lookup field in dynamics 365 crm using a fetchXML in a javascript. I have to view all the products with a custom text field ('my_variantstatus') not equal to 'R&D Stage' (and some other values).

Here is my filter xml:

var filterXml = ''<filter type='and'><condition attribute='my_variantstatus' operator='ne' value='R&D stage'/><condition attribute='my_variantstatus' operator='ne' value='Discontinued'/></filter>'';

I have already tried remplacing the ampersand '&' with : '&', '&', '&', but none of them worked.

Please note that the script works well when I try to filter without the ampersand ('RD stage') and that it does not work with any other special character as well (quote, <, >, etc).

I am really confused so thank you in advance