Viewing the Published Status of Object Properties

The sproc_GetPropertiesPublishStatusForObject stored procedure can be used to view the published status of properties of an object. To do so, use the following query:

EXEC sproc_GetPropertiesPublishStatusForObject @nObjectType = <Object type>, @nPropertyID = <property ID>, @nPublishStatus = <Status>

Type the following values for properties:

•   @nObjectType – The ID of the object. For example, the ID of the contact object is 3.

•   @nPropertyID – The ID of the property that you want to check. To view all properties of the object, pass -1.

•   @nPublishStatus – Type one of the following values:

◦   0 – Retrieves properties that are not published to OData. The value “disabled” is displayed.

◦   1 – Retrieves properties that are published to OData. The value “published” is displayed.

◦   2 – Retrieves properties that failed to be published to OData when CampusNexus CRM was upgraded or when the property was created. The value “failed” is displayed.

Scenarios

1.  To view all properties of the contact object regardless of whether its properties are published to OData, run the following query:

EXEC sproc_GetPropertiesPublishStatusForObject @nObjectType = 3, @nPropertyID = -1, @nPublishStatus = NULL

All properties of the contact object, regardless of their OData status, are retrieved. The following values are displayed:

◦   Published – Indicates that the properties are published to OData.

◦   Failed – Indicates that the properties failed to be published to OData.

◦   Disabled – Indicates that the property is unpublished from OData.

2.  To view properties of the contact object that have a specific status (published, failed, or disabled), run the following query:

EXEC sproc_GetPropertiesPublishStatusForObject @nObjectType = 3, @nPropertyID = -1, @nPublishStatus = 1

Properties of the contact object that are published to OData are retrieved.

Note

◦   To view properties that failed to be published to OData, change the value of @nPublishStatus to 2.

◦   To view properties that are unpublished from OData, change the value of @nPublishStatus to 0.

3.  To view the publish status of a specific property of the contact object, run the following query:

EXEC sproc_GetPropertiesPublishStatusForObject @nObjectType = 3, @nPropertyID = 56, @nPublishStatus = NULL

In the query, 56 is the ID of a contact property.