Microsoft CRM has a great tool for making custom queries to all the CRM entities available to the final CRM users: this tool is called "Advanced Find".
Customers have a great fantasy on making queries and some days ago I've received a request: how can I retrieve all the Accounts that doesn't have associated Contacts via the "Advanced Find" tool?
My first answer was to make a query like this (sorry but I've the italian CRM version installed on the production machine):
and after pushing the "Find" button... the query doesn't work!!
The "Advanced Find" tool doesn't provide a good solution for this type of query (not good! :( ). Obviously, you can always provide a report (Reporting Services or Excel) that makes the work with a simple SQL query like this:
select distinct accountid, name
from filteredaccount
where accountid not in
(select distinct accountid from filteredcontact where accountid is not null)
but it's not a good news to discover that the built-in Find tool doesn't help the end user on making these types of queries.
If anyone of you have a good idea on how to solve this query via the "Advanced Find" tool, please drop me a line... :)
Technorati Tag:
Dynamics CRM