Difference between Query Expression AND Query by Attribute?

 

Query Expression

• Query Expression is an object oriented, strongly typed approach to developing queries against the CRM database.
• We need to specify the condition Expression and Condition Operators while designing the queries.
• Query Expression is preferable if we want to query the CRM data with complex conditions.
• It supports the complex conditions with “AND” and “OR” operators
• It supports different condition operators like “Begins with, doesn’t begin with, End switch”
• It supports to retrieve the data based on Link entities.

 Query by Attribute:

• Query by Attribute class is a simple class compared to Query Expression class. Hence, we can select Query by Attribute if the query is simple.
• No need to enter the conditions expression, condition operators while designing the criteria for Query by Attribute.
• It queries the CRM data from specified entity by specifying criteria with set of attributes and value pairs.
• It automatically consider “AND” between specified attributes as it doesn’t support “OR”.
• It supports only “Equal” condition operator