[EntityDefinition(EntityID.VennSetQueryableItemParam, "dbo.LT_VennSetQueryableItemParams", "VennSetQueryableItemParam")]
[DefaultEntityIcon(ImageType.Venn)]
[EntityLinkToAnyParentRelationshipModifier(EntityID.SQLWrapper, "OwnerEntityID", "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
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
string

TargetVennSetQueryableItemID

Links to IVennSetQueryableItem. 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)]
[RequiredNoDefaultIDValidation]
Guid TargetVennSetQueryableItemID { get; set; }

Property Value

Type	Description
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, "Venn Set", "Queryable Item Parameters", DeleteWithRelationship = true, PartOfParentSet = true, InheritPermissions = true)]
[RequiredNoDefaultIDValidation]
Guid VennSetID { get; set; }