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.Reporting
Assembly: LemonEdge.API.dll
Syntax
[EntityDefinition(EntityID.DatasetQueryableItemFieldInfo, "dbo.LT_DatasetQueryableItemFieldInfos", "DatasetQueryableItemFieldInfo")]
[DefaultEntityIcon(ImageType.Dataset)]
[EntityLinkToAnyParentRelationshipModifier(EntityID.SQLWrapper, "OwnerEntityID", "ID", ExcludeFromRelationship = true)]
[EntityLinkToAnyParentRelationshipModifier(EntityID.DataSourceIDs, "EntityID", "ID", ExcludeFromRelationship = true)]
[EntityIndex(Name = "DataSetFields", ColumnNames = new string[] { "DatasetID" }, IndexOrder = new IndexOrder[] { IndexOrder.Ascending }, IsClustered = false, IsUnique = false)]
public interface IDatasetQueryableItemFieldInfo : IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackProperties

Properties

DatasetID

Links to IDataset. The parent data set this entity belongs to

Declaration
[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.Dataset, "ID", SingleJoinType.One, "Dataset", "Queryable Item Fields", DeleteWithRelationship = true, PartOfParentSet = true, InheritPermissions = true)]
[RequiredNoDefaultIDValidation]
Guid DatasetID { get; set; }
Property Value
Type Description
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, "Dataset Queryable Item", "Fields", DeleteWithRelationship = true, PartOfParentSet = false, InheritPermissions = false)]
[RequiredNoDefaultIDValidation]
Guid DatasetQueryableItemID { get; set; }
Property Value
Type Description
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
string

QueryableFieldUniqueKey

The unique key of the field from within the parent queryable item

Declaration
[EntityProperty(SQLType.NVarChar, 50, true)]
[EntityDescription("The unique key of this queryable field within the queryable item.")]
string QueryableFieldUniqueKey { get; set; }
Property Value
Type Description
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, "SQL Wrapper Type", "Dataset Queryable Item Fields", DeleteWithRelationship = true, PartOfParentSet = false, InheritPermissions = false)]
[RequiredNoDefaultIDValidation]
Guid SQLWrapperTypeID { get; set; }
Property Value
Type Description
Guid

Extension Methods

See Also