Microsoft Dynamics CRM (Archived)

How can I search by GUID?

(0) Share

Report

Posted on by Community Member

How can I search by GUID in CRM On Premise 2016?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Rawish Kumar 13,758 on at

Like (1)

Report
Copy link

Link copied!

you cant in frontend but you will have to use webAPI to get the required field in javascript from that record.

or a simple way below : crmtipoftheday.com/.../find-a-record-using-id

Was this reply helpful? Yes No
Suggested answer

Mahendar Pal 45,095 on at

Like (0)

Report
Copy link

Link copied!

Are you just want to check it one time ?? you have access to Db, you can look for related entity table and search for GUID.

Was this reply helpful? Yes No
Suggested answer

yleclerc 1,549 on at

Like (2)

Report
Copy link

Link copied!

You would need to add a new field to your form. Then populate this field using an on-demand workflow on all records for your entity.

There are a few tools to help you populate this field.

Once the field is populated, you will be able to search it using Advanced Find.

Was this reply helpful? Yes No
Suggested answer

Flydancer 1,332 on at

Like (0)

Report
Copy link

Link copied!
I've written a little bookmarklet for that opens a record by guid.

Just add the following code as a bookmark (tested in chrome only)

javascript:var loc = window.location; var crmurl = loc.protocol + "//" + loc.host + loc.pathname; var entity = prompt("Enter the records entity typecode or internalname (1 / account)", 1); var etcetn = isDigit(entity) ? "?etc=" : "?etn="; var guid = prompt("Enter the records GUID"); var fullurl = crmurl + etcetn + entity + "&id=" + guid + "&pagetype=entityrecord"; console.log("Opening " + fullurl); window.location = fullurl;

You have to be on any side of your CRM, first it asks for entity typecode or entity name (like 1 or account) then for the guid.

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Michael,

There is many way you could found if you know the Entity name(WEB API , FetchXML , Query Expression , Organization Service etc ) . I believe you are not aware the entity name in that case you can search in you database as you are on-premise . Try to execute below reference query , which will search complete database .

www.sqlmatters.com/.../Searching%20all%20columns%20in%20all%20tables%20in%20a%20database.aspx

Hope this helps.

Was this reply helpful? Yes No