Thursday, October 1, 2009

What is the property deletionstatecode ?

How can I remove from crm database record and not with delete command?

Each entity in CRM 4.0 includes two tables, base and extension.
In base table the columns are the same. statecode,guid,createdon...

One of the columns is deletationstatecode.

Deletionstatecode define if record is live in CRM or should be deleted.

Deletionstatecode = 0 record exist and live in CRM
Deletionstatecode = 2 record should e removed.

One of the services responsoble to remove all the record where deletionstatecode =2.
The if I need to remove many records in crm direct from database change the deletionstatecode to 2 and record will be removed after job finished.

Thanks,
Rami Heleg