How can I tell if an entity is disabled in Dynamics CRM 4.0?

From what I've read, StateCode is not necessarily the same for every entity. It varies per entity I'm not aware of a way to disable an entity. I double checked our install, but don't see any option to disable.

Google also yields no results to this end Do you mean perhaps individual entity records? If so, you'll have to check the StateCode for the entity you're looking at. I think most entities use StateCode as you describe, but for some entities, such as Activities, it seems to vary a little Here is some SQL I found to pull back the StateCode/StatusCode details of a particular entity: select AttributeName, AttributeValue, Value from dbo.

StringMap where (dbo.StringMap. AttributeName = 'statuscode' or dbo.StringMap. AttributeName = 'statecode') and dbo.StringMap.

ObjectTypeCode = 1 ObjectTypeCode 1 maps to the Account entity Hope this helps EDIT: Just saw your addition. I think you'll be safe using StateCode in most instances. I personally use it in one of my projects to exclude disabled records on the Lead and Contact entities.

Just double check the value mapping as I've described and then implement.

From what I've read, StateCode is not necessarily the same for every entity. It varies per entity. I'm not aware of a way to disable an entity.

I double checked our install, but don't see any option to disable. Google also yields no results to this end. Do you mean perhaps individual entity records?

If so, you'll have to check the StateCode for the entity you're looking at. I think most entities use StateCode as you describe, but for some entities, such as Activities, it seems to vary a little. Here is some SQL I found to pull back the StateCode/StatusCode details of a particular entity: select AttributeName, AttributeValue, Value from dbo.

StringMap where (dbo.StringMap. AttributeName = 'statuscode' or dbo.StringMap. AttributeName = 'statecode') and dbo.StringMap.

ObjectTypeCode = 1 ObjectTypeCode 1 maps to the Account entity. Hope this helps. EDIT: Just saw your addition.

I think you'll be safe using StateCode in most instances. I personally use it in one of my projects to exclude disabled records on the Lead and Contact entities. Just double check the value mapping as I've described and then implement.

I've updated the question to make it more readable. It's the records I want to check but in a generic manner for any entity type. The problem with checking for "active" is that some entities don't have "active" and some have "active" when the record is disabled for editing (in these cases "draft" means editable).

– Richard Feb 18 at 15:49 You may have to make it more complicated then. If 0 maps to "Published" on an entity and "draft" is the editable setting, you're going to have conflict as 0 for Contact and Lead would mean editable. – clifgriffin Feb 18 at 15:53.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.