Interface IVennSetQueryableItemFieldInfo

The system entity for a VennSet Queryable Item field, which belongs to a IVennSet and IVennSetQueryableItem

This ties a field from a queryable item to its definition in a ISQLTypeWrapper against the SQL Wrapper for this vennset. 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/venn-sets/columns-view.html for more information

Inherited Members

IBaseEntity.GetLabel(string)

IBaseEntity.SetLabel(string, string)

IBaseEntity.SetSilentLabel(string, string)

IBaseEntity.AccountID

IBaseEntity.ID

IBaseEntity.LastUpdated

IBaseEntity.ModifiedByUserID

IBaseEntity.CanvasID

IBaseEntity.AlgorithmStepID

IBaseEntity.SafeID

IEquatable<IBaseEntity>.Equals(IBaseEntity)

INotifyPropertyChanged.PropertyChanged

INotifyPropertyChanging.PropertyChanging

ICloneableAsync.Clone(object)

ICloneableAsync.CopyFromSource(object)

ICanTrackProperties.HasTrackedPropertyChanged(string)

ICanTrackProperties.OriginalTrackedPropertyValue(string)

ICanTrackProperties.OriginalTrackedPropertyValue<T>(string)

ICanTrackProperties.ClearTrackedOriginalValues()

ICanTrackProperties.GetAllOriginalTrackedPropertyValues()

Namespace: LemonEdge.API.Entities.Reporting

Assembly: LemonEdge.API.dll

Syntax

[EntityDefinition(EntityID.VennSetQueryableItemFieldInfo, "dbo.LT_VennSetQueryableItemFieldInfos", "VennSetQueryableItemFieldInfo")]
[DefaultEntityIcon(ImageType.Venn)]
[EntityLinkToAnyParentRelationshipModifier(EntityID.SQLWrapper, "OwnerEntityID", "ID", ExcludeFromRelationship = true)]
[EntityLinkToAnyParentRelationshipModifier(EntityID.DataSourceIDs, "EntityID", "ID", ExcludeFromRelationship = true)]
public interface IVennSetQueryableItemFieldInfo : IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackProperties

Properties

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 vennset stored against the ISQLWrapper for the vennset

Declaration

[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.SQLTypeWrapper, "ID", SingleJoinType.One, "SQL Type Wrapper", "Venn Set Queryable Item Field Infos", DeleteWithRelationship = true, PartOfParentSet = false, InheritPermissions = false)]
[RequiredNoDefaultIDValidation]
Guid SQLWrapperTypeID { get; set; }

Property Value

Type	Description
Guid

VennSetID

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

Declaration

[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.VennSet, "ID", SingleJoinType.One, "Venn Set", "Queryable Item Field Infos", DeleteWithRelationship = true, PartOfParentSet = true, InheritPermissions = true)]
[RequiredNoDefaultIDValidation]
Guid VennSetID { get; set; }

Property Value

Type	Description
Guid

VennSetQueryableItemID

Links to IVennSetQueryableItem. The parent vennset queryable item this field is from

Declaration

[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.VennSetQueryableItem, "ID", SingleJoinType.One, "Venn Set Queryable Item", "Field Info", DeleteWithRelationship = true, PartOfParentSet = false, InheritPermissions = false)]
[RequiredNoDefaultIDValidation]
Guid VennSetQueryableItemID { get; set; }