Truncating CRM tables

Is it possible to truncate CRM table data?

The answer is for some it's Yes. you can truncate the extensionbase tables in the CRM cause mostly they contain data and foreign keys. We can truncate these tables.

But we cannot truncate the base tables as they contain the references to other tables. You need to use the delete command to delete data in these tables.

Site map XML

Do you guys now where CRM stores the site map?

Recently I had to check orgnaizationbase entity in the CRM for some reason and i found that it contains a field named Sitemap in the table. When checked the data in this field i found that the current site map is being stored there.

So if anyone wants to check the site map you should check the organizationbase table in the CRM database.

String map entity

This table in the CRM is holding valuable information regarding all the pick lists that we add to CRM. it contains the attributename and the entity object type code with the values that we specify to the attributes.

But probably we don't think that doing a change that is not accurate here would cause the CRM to give the unauthorized access error. Well, it does. Recently we did some data insertions to a CRM server with wrong object type codes and it caused the system to give errors. What we didn't realise is that it caused the system failure. When we deleted those records from the string map entity(Luckily we knew the data we have inserted) CRM started working fine.This was a very good lesson for us and would be for you all out there.

NEW YEAR

It’s a new year. I haven’t been bloging for some time. There are some things that I want to publish here, but couldn’t do it as there was not much time for me. Hoping to publish more information regarding CRM 3.0 and CRM 4.0 in the future.

Hope that this New Year brings happiness and joy to all of you out there.

Retreiving Link Entitiy attributes from CRM 3.0

We have 2 methods to retreive information from CRM.

1. Using Fetch Statements
2. Using QueryExpressions

although we can use to join entities in queryexpression we cannot use it to retreive link entity attributes. we need to use Fetch statements to do this task.

Also if we are trying to retreive more then one link entities attributes from a fetch statement we need to use alias, else the fecth statements will not be executed properly. below you can find an example.