Monday, November 18, 2013

Dynamics CRM 2013 - Extension tables removed

Prior to Dynamics 2013 each entity mapped onto two SQL Server tables. One was the base table and the other was an extension table. The base table contained all the system fields while the extension contained the user defined fields.

In Dynamics 2013 extension tables have been removed and user defined fields are now added to the base table as shown below. This will improve performance as the filtered views no longer need to do a join between the base and extension tables.

 

Tuesday, November 05, 2013

Dynamics CRM 2013 - Business Rules Limitations

Business rules were introduced in Dynamics 2013 to make it easier to write logic to control the appearance and values of fields on an entity form.  Using business rules prevents you having to write JavaScript for simple UI logic such as setting the value of a field based on the contents of another field.  

In the example below the annual revenue of the account, the condition, determines if the account category field value is set to preferred customer, the action.