This SQL View provides details regarding Form or Excel Solution dependencies on other types of solutions including Group, Data Connection, Reference, and Form Solutions. This view tells you where a specific solution is being used.
Back to Reporting SQL Views.
| Field Name | DB Type | Type | Nullable | Description |
|---|---|---|---|---|
| ReferenceEntitiesId | uniqueidentifier | Guid | 0 | Unique ID for this view/table. |
| TenantId | uniqueidentifier | Guid | 0 | ID of the tenant to which the object belongs. |
| ObjectId | uniqueidentifier | Guid | 0 | The ID of the object using the reference object/entity. |
| ObjectName | nvarchar | String | 0 | The name of the object using the reference object/entity. |
| ObjectTeamspaceId | uniqueidentifier | Guid | 1 | The app ID of the object using the reference object/entity. |
| ObjectStoreId | uniqueidentifier | Guid | 1 | the parent ID of the object using the reference object/entity. |
| RefObjectName | nvarchar | String | 0 | The name of the object being used. |
| RefObjectType | tinyint | Byte | 0 |
The type of object being used. Solution = 0, Connection = 1, AppGroup = 2, NameTemplate = 3, FileRepository = 4, SolutionDataSet = 5, SAPServer = 6, ExternalWebService = 7, User = 8, App = 9, DataConnectionLibrary = 10 |
| RefObjectTeamspaceId | uniqueidentifier | Guid | 1 | The app ID of object being used. |
| RefObjectStoreId | uniqueidentifier | Guid | 1 | Parent id of object being used. |
| CreatedDate | datetime | DateTime | 0 | Created date of this reference entry. |
| ModifiedBy | uniqueidentifier | Guid | 1 | Modified By of this reference entry. |
| CreatedBy | uniqueidentifier | Guid | 1 | Created By of this reference entry. |
| ModifiedDate | datetime | DateTime | 0 | Modified Date of this reference entry. |
| RefFeatureType | tinyint | Byte | 0 | The feature type in which the object reference is used. Solution = 0, WebService = 1 |
| AppName | nvarchar | String | 0 | Name of app where object exists. |