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
Namespace: LemonEdge.API.Entities
Assembly: API.dll
Syntax
[EntityDefinition(EntityID.VennSetQueryableItemFieldInfo, "dbo.LT_VennSetQueryableItemFieldInfos", "VennSetQueryableItemFieldInfo")]
[DefaultEntityIcon(ImageType.Venn)]
[EntityLinkToAnyParentRelationshipModifier(EntityID.SQLWrapper, "OwnerEntityID", "ID", ExcludeFromRelationship = true)]
[EntityLinkToAnyParentRelationshipModifier(EntityID.Transaction, "ParentItemID", "ID", ExcludeFromRelationship = true)]
[EntityLinkToAnyParentRelationshipModifier(EntityID.DataSourceIDs, "EntityID", "ID", ExcludeFromRelationship = true)]
public interface IVennSetQueryableItemFieldInfo : IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackPropertiesProperties
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 vennset stored against the ISQLWrapper for the vennset
Declaration
[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.SQLTypeWrapper, "ID", SingleJoinType.One, "SQL Wrapper Type", "Venn Set Fields", DeleteWithRelationship = true, PartOfParentSet = true, InheritPermissions = false)]
Guid SQLWrapperTypeID { get; set; }Property Value
| Type | Description |
|---|---|
| System.Guid |
VennSetID
Links to IVennSet. The parent data set this entity belongs to
Declaration
[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.VennSet, "ID", SingleJoinType.One, "Parent Venn Set", "Queryable Item Field Infos", DeleteWithRelationship = true, PartOfParentSet = true, InheritPermissions = true)]
Guid VennSetID { get; set; }Property Value
| Type | Description |
|---|---|
| System.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 = true, InheritPermissions = false)]
Guid VennSetQueryableItemID { get; set; }Property Value
| Type | Description |
|---|---|
| System.Guid |