Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Suggested answer

How can I search by GUID?

Posted on by Microsoft Employee

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

  • Suggested answer
    gdas Profile Picture
    gdas 50,083 on at
    RE: How can I search by GUID?

    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.

  • Suggested answer
    Flydancer Profile Picture
    Flydancer 1,332 on at
    RE: How can I search by GUID?

    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.

  • Suggested answer
    yleclerc Profile Picture
    yleclerc 1,545 on at
    RE: How can I search by GUID?

    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.

  • Suggested answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,041 on at
    RE: How can I search by GUID?

    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.

  • Suggested answer
    Rawish Kumar Profile Picture
    Rawish Kumar 13,752 on at
    RE: How can I search by GUID?

    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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans