Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

How are notes linked?

Posted on by

How are notes linked into the records they are assigned to? There doesn't seem to be any lookup field or link between them and anything else?

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How are notes linked?

    Good article Priyadarshi,

    We can use below query to fetch Annotation data based on Custom Entity/ Out of box entity.

    * join Filterednew_EntityName A on Annotation.ObjectId = A.new_EntityNameId

  • purwar purwar Profile Picture
    purwar purwar 2,836 on at
    RE: How are notes linked?

     Annotation STORE data based on Object type code and Objectid.

    Objecttypecode explain entity type like account,case,etc. In below ex Annotation is created for case(objectype code:112) and in objectid it storing case id.

    AnnotationId

    ObjectTypeCode

    ObjectId

    Subject

    IsDocument

    NoteText

    CreatedOn

    FileName

    1EFCB2DB-89F8-E411-941E-005056BB77BC

    112

    3276-C2E4-G43-E411-941E-005056BB77BC

    Hi

    1

    ABC

    32:51.0

    aaa.txt

  • Verified answer
    Aileen Gusni Profile Picture
    Aileen Gusni 44,522 on at
    RE: How are notes linked?

    Frang,

    Note and object Id basically has relationship, if you go to the Note entity, then find the N:1 Relationship, you can have plenty of list.

    Then if you create an entity, you check the Note capability to Yes (tick it), then it will auto create the relationship.

    "However, you can associate annotations with only those custom entities that are created with the HasNotes property set to true. You can update a custom entity, which is not enabled for notes, to have notes by setting the HasNotes property to true."

    While, the field that stored the relationship is RegardingObjectId (Object Id), means primary entity id related, that can link to any entity with Note-setting enable.

    To get the GUID I think you need to export it out and then tick the make as re-import feature.

    Or you can use OData Query or PowerQuery in Excel or SQL Query if you are onpremise user.

    Thanks.

  • Mahadeo Matre Profile Picture
    Mahadeo Matre 17,021 on at
    RE: How are notes linked?

    You will not get GUID's of lookup from advanced find.

    but you will related entity details..

    e.g. You have some notes attached to account,contact and some other entities, and you want to find out which note is attached to which entity using advanced find.

    To get this information in advanced find you need to add Regarding(account) or similar entity columns then you will get notes and related entity.

    But if you want guid of record from advanced find, then it is not possible.

    Hope this will give some idea.

  • Franglais Profile Picture
    Franglais on at
    RE: How are notes linked?

    Is there any way of getting the GUIDs of the lookup on an advanced find rather than just the topic or description?

  • Verified answer
    Mahadeo Matre Profile Picture
    Mahadeo Matre 17,021 on at
    RE: How are notes linked?

    In MS CRM notes are stored in Annotation entity.

    When you enable notes for any custom entity, then one 1:N relationship will be created between custom entity and Annotation entity.

    This link / relationship is always tided together with Regarding (ObjectId) field.

    For CRM native entities, this relationship is already created.

    Here is more details on Notes /Annotation entity.

    [View:https://msdn.microsoft.com/en-us/library/gg334398.aspx:550:50]

    [View:https://msdn.microsoft.com/en-us/library/gg328535.aspx:550:50]

    [View:https://msdn.microsoft.com/en-us/library/gg328429.aspx:550:50]

    Hope this will help..

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans