Sunday, March 15, 2015

Notes (Annotationbase) entity in CRM

In CRM all the notes are attached with the annotation base entity. This means it should be having relationships with all the entities that we say yes to Notes.

So if we take the notes table we should be seeing all the relationships that notes are associated with. But is that the case?

When you take a look at the notes table you don't seems find any relationships. Then how is this possible?

In the notes entity we have 2 fields.

  • objecttype
  • objectid
The first field is the ones keeping the entity which the record is associated with.
The second field keeps the primary key of the record the notes records is associated with (associated entities primary key).

That is how this miracle is happening.

Retrieving Calendar of a Bookable Resource in Dynamics

There are occasions where we need to retrieve working days and working times of a resource in Dynamics grammatically. This is quite possible...