Interface IDatasetQueryableItemFieldInfo
The system entity for a DataSet Queryable Item field, which belongs to a IDataset and IDatasetQueryableItem
This ties a field from a queryable item to its definition in a ISQLTypeWrapper against the SQL Wrapper for this dataset. This way the system knows which queryable item field should be described by which result column in the sql
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/datasets/columns-view.html for more information
Inherited Members
Namespace: LemonEdge.API.Entities
Assembly: API.dll
Syntax
[EntityDefinition(EntityID.DatasetQueryableItemFieldInfo, "dbo.LT_DatasetQueryableItemFieldInfos", "DatasetQueryableItemFieldInfo")]
[DefaultEntityIcon(ImageType.Dataset)]
[EntityLinkToAnyParentRelationshipModifier(EntityID.SQLWrapper, "OwnerEntityID", "ID", ExcludeFromRelationship = true)]
[EntityLinkToAnyParentRelationshipModifier(EntityID.Transaction, "ParentItemID", "ID", ExcludeFromRelationship = true)]
[EntityLinkToAnyParentRelationshipModifier(EntityID.DataSourceIDs, "EntityID", "ID", ExcludeFromRelationship = true)]
public interface IDatasetQueryableItemFieldInfo : IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackPropertiesProperties
DatasetID
Links to IDataset. The parent data set this entity belongs to
Declaration
[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.Dataset, "ID", SingleJoinType.One, "DatasetQueryableItem", "Dataset", DeleteWithRelationship = true, PartOfParentSet = true, InheritPermissions = true)]
Guid DatasetID { get; set; }Property Value
| Type | Description |
|---|---|
| System.Guid |
DatasetQueryableItemID
Links to IDatasetQueryableItem. The parent dataset queryable item this field is from
Declaration
[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.DatasetQueryableItem, "ID", SingleJoinType.One, "DatasetQueryableItem", "DatasetQueryableItemFieldInfo", DeleteWithRelationship = true, PartOfParentSet = true, InheritPermissions = false)]
Guid DatasetQueryableItemID { get; set; }Property Value
| Type | Description |
|---|---|
| System.Guid |
QueryableCalculatedField
The calculated field for this queryable item if it is a custom calculation
Declaration
[EntityProperty(SQLType.NVarChar, true)]
[EntityDescription("The calculated field for this queryable item.")]
string QueryableCalculatedField { get; set; }Property Value
| Type | Description |
|---|---|
| System.String |
QueryableFieldUniqueKey
The unique key of the field from within the parent queryable item
Declaration
[EntityProperty(SQLType.NVarChar, (short)50, true)]
[EntityDescription("The unique key of this queryable field within the queryable item.")]
string QueryableFieldUniqueKey { get; set; }Property Value
| Type | Description |
|---|---|
| System.String |
SQLWrapperTypeID
Links to ISQLTypeWrapper. The ISQLTypeWrapper that describes this column for the dataset stored against the ISQLWrapper for the dataset
Declaration
[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.SQLTypeWrapper, "ID", SingleJoinType.One, "SQLTypeWrapper", "DatasetQueryableItemFieldInfo", DeleteWithRelationship = true, PartOfParentSet = true, InheritPermissions = false)]
Guid SQLWrapperTypeID { get; set; }Property Value
| Type | Description |
|---|---|
| System.Guid |