Interface IDatasetQueryableItemJoin

The system entity for a DataSet Queryable Item Join, which belongs to a IDataset and IDatasetQueryableItem

See https://web.lemonedge.com/help/dataset-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.DatasetQueryableItemJoin, "dbo.LT_DatasetQueryableItemJoins", "DatasetQueryableItemJoin")]
[DefaultEntityIcon(ImageType.Attachment)]
[EntityLinkToAnyParentRelationshipModifier(EntityID.SQLWrapper, "OwnerEntityID", "ID", ExcludeFromRelationship = true)]
[EntityLinkToAnyParentRelationshipModifier(EntityID.Transaction, "ParentItemID", "ID", ExcludeFromRelationship = true)]
[EntityLinkToAnyParentRelationshipModifier(EntityID.DataSourceIDs, "EntityID", "ID", ExcludeFromRelationship = true)]
public interface IDatasetQueryableItemJoin : IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackProperties

Properties

DatasetID

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

Declaration
[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.Dataset, "ID", SingleJoinType.One, "DatasetQueryableItem", "Dataset", DeleteWithRelationship = true, PartOfParentSet = true, InheritPermissions = true)]
Guid DatasetID { get; set; }
Property Value
Type Description
System.Guid

IsNullSourceDatasetQueryableItemID

Links to IDatasetQueryableItem. The source queryable item this is a join from if the initial source has a null value. This can be null if joining to dataset global parameters

Declaration
[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityRelationship(EntityID.DatasetQueryableItem, "ID", SingleJoinType.ZeroToOne, "DatasetQueryableItem", "DatasetQueryableItemJoin", DeleteWithRelationship = true, PartOfParentSet = true, InheritPermissions = false)]
Guid? IsNullSourceDatasetQueryableItemID { get; set; }
Property Value
Type Description
System.Nullable<System.Guid>

IsNullSourceQueryableItemFieldUniqueKey

A property within the selected Source Dataset Queryable Item that you want to use to join to the selected Queryable Item that is used if the initial source has a null value

If the Source is global parameters it will allow a selection from all your parameters.If the source is another queryable item it will provide a list of all fields that queryable item contains.

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

SourceDatasetQueryableItemID

Links to IDatasetQueryableItem. The source queryable item this is a join from. This can be null if joining to dataset global parameters

Declaration
[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityRelationship(EntityID.DatasetQueryableItem, "ID", SingleJoinType.ZeroToOne, "DatasetQueryableItem", "DatasetQueryableItemJoin", DeleteWithRelationship = true, PartOfParentSet = true, InheritPermissions = false)]
Guid? SourceDatasetQueryableItemID { get; set; }
Property Value
Type Description
System.Nullable<System.Guid>

SourceQueryableItemFieldUniqueKey

A property within the selected Source Dataset Queryable Item that you want to use to join to the selected Queryable Item.

If the Source is global parameters it will allow a selection from all your parameters.If the source is another queryable item it will provide a list of all fields that queryable item contains.

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

TargetDatasetQueryableItemID

Links to IDatasetQueryableItem. The parent queryable item this join is a target to

Declaration
[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.DatasetQueryableItem, "ID", SingleJoinType.One, "DatasetQueryableItem", "DatasetQueryableItemJoin", DeleteWithRelationship = true, PartOfParentSet = true, InheritPermissions = false)]
Guid TargetDatasetQueryableItemID { get; set; }
Property Value
Type Description
System.Guid

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

Extension Methods

See Also