The CRM query builder won’t allow you to do everything you can do in SQL, but you can get close.
Here are some of the common issues encountered when creating a CRM Query.
How do I say not equal to, ‘<>’ will not work?
This is correct, the CRM FetchXML won’t accept <>. It will accept != so you will want your query to look like the one below.
Using multiple ‘Or’ statements are not being grouped correctly.
Here is a picture of the incorrect way to use multiple ‘Or’ statements.
This method won’t work, because the SQL statement will be put together as:
Notice that the 1 is only with Primary, and the 2 is only with Secondary. I want the statement to look like this:
Here is how you enter multiple ‘Or’ statements in the query builder.
If you are encountering something not listed here, email support@eonesolutions.com.