CODEWITHSUNDEEP
dynamics-crm-2011
jimminybob
jimminybob

Reputation: 1442

Do a global search on records by GUID

In CRM 2011 I have some code that is looking to some accounts to do some processing, but it is coming back with an error and only referencing the record that has the problem by its GUID. I've tried looking into the accounts and none of them have the GUID that it is returning. Is there a way that I can do a global search in CRM (or its SQL database) to find a record by its GUID?

Thanks

Upvotes: 3

Views: 1942

Answers (2)

Abel
Abel

Reputation: 57169

On CodePlex, Demian Rasko created a project that allows you to search all entities based on a guid, which then shows a result of the tables where the guid was (or was not) found. See Guid Finder Solution for Microsoft Dynamics CRM 2011.

I have not (yet) tried it myself, but it looks promising. It is a plugin for CRM.

Upvotes: 1

Peter Majeed
Peter Majeed

Reputation: 5362

Every entity is stored in a separate table. There's no entity/table that stores GUIDs and table names (= EntityReference) from every table. As with SQL, to find all GUIDs for all tables, you have to search each entity/table separately.

Alternatively, you can make an entity that stores this kind of information and create a Create plugin for every accessible entity in the system, but this kind of overhead is likely unwanted and unnecessary.

Upvotes: 1

Related Questions