Interface IVennSetQueryableItemParam

The system entity for a VennSet Queryable Item Param, which belongs to a IVennSet and IVennsetQueryableItem

See https://web.lemonedge.com/help/venn-set-queryable-items-view/ for more information

Inherited Members
System.IEquatable<LemonEdge.API.Core.IBaseEntity>.Equals(LemonEdge.API.Core.IBaseEntity)
System.ComponentModel.INotifyPropertyChanged.PropertyChanged
System.ComponentModel.INotifyPropertyChanging.PropertyChanging
Namespace: LemonEdge.API.Entities
Assembly: API.dll
Syntax
[EntityDefinition(EntityID.VennSetQueryableItemParam, "dbo.LT_VennSetQueryableItemParams", "VennSetQueryableItemParam")]
[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 IVennSetQueryableItemParam : IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackProperties

Properties

SourceQueryableItemFieldUniqueKey

A property within the Venn Set Parameters that you want to use to join to the selected Queryable Item.

Declaration
[EntityProperty(SQLType.NVarChar, false)]
[Required]
string SourceQueryableItemFieldUniqueKey { get; set; }
Property Value
Type Description
System.String

TargetQueryableItemFieldUniqueKey

This is the property on the selected queryable item that you want to use to join to the source queryable item.

This will list all fields against this queryable item, and if it has parameters(is a query queryable item) those will also be listed allowing you to pass values into the parameters as part of the join.Doing so will force the join to be an outer apply join.

Declaration
[EntityProperty(SQLType.NVarChar, false)]
[Required]
string TargetQueryableItemFieldUniqueKey { get; set; }
Property Value
Type Description
System.String

TargetVennSetQueryableItemID

Links to . The queryable item this holds a parameter value for

Declaration
[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.VennSetQueryableItem, "ID", SingleJoinType.One, "Venn Set Queryable Item", "Parameters", DeleteWithRelationship = true, PartOfParentSet = true, InheritPermissions = false)]
Guid TargetVennSetQueryableItemID { get; set; }
Property Value
Type Description
System.Guid

VennSetID

Links to IVennSet. The parent dataset this join is a member of

Declaration
[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.VennSet, "ID", SingleJoinType.One, "Parent Venn Set", "Queryable Item Parameters", DeleteWithRelationship = true, PartOfParentSet = true, InheritPermissions = true)]
Guid VennSetID { get; set; }
Property Value
Type Description
System.Guid

Extension Methods

See Also