Interface IDatasetQueryableItem

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

See https://help.lemonedge.com/help/enterprise-data-tools/reporting/datasets/queryable-items-view.html 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.DatasetQueryableItem, "dbo.LT_DatasetQueryableItems", "DatasetQueryableItem", LabelColumn = "Name")]
[DefaultEntityIcon(ImageType.Dataset)]
[EntityLinkToAnyParentRelationshipModifier(EntityID.SQLWrapper, "OwnerEntityID", "ID", ExcludeFromRelationship = true)]
[EntityLinkToAnyParentRelationshipModifier(EntityID.Transaction, "ParentItemID", "ID", ExcludeFromRelationship = true)]
[EntityLinkToAnyParentRelationshipModifier(EntityID.DataSourceIDs, "EntityID", "ID", ExcludeFromRelationship = true)]
public interface IDatasetQueryableItem : IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackProperties

Properties

DatasetID

Links to IDataset. The parent dataset this queryable item belongs to

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

JoinType

If this Queryable Item is a child of any other Queryable Item, then this specifies the type of join this queryable item will have to the overall dataset:

  • Exclusive: Equivalent to Inner Join in SQL.
  • Inclusive: Equivalent to Outer Join in SQL
  • CrossJoin: Equivalent to Cross Join in SQL
Declaration
[EntityProperty(SQLType.SmallInt, true)]
[EntityDescription("The type of join to use when joining this queryable item to its parent.")]
RelationshipJoinType? JoinType { get; set; }
Property Value
Type Description
System.Nullable<RelationshipJoinType>

Name

[Key] This is the user friendly name of the queryable item as it will appear in the treeview.

This makes looking at the data structure very easy at a glance.It is also the name the user will see if they are able to open a row of data from this item type

Declaration
[EntityProperty(SQLType.NVarChar, (short)500, false)]
[EntityDescription("The name of this queryable item.")]
[Required]
string Name { get; set; }
Property Value
Type Description
System.String

ParentID

The Queryable Item this entity is a child of (if it is not the root queryable item)

Declaration
[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntitySelfRelationship("ID", SingleJoinType.ZeroToOne, "IDatasetQueryableItem", "Queryable Items", DeleteWithRelationship = true, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = false, PreventAutoConstraint = true)]
Guid? ParentID { get; set; }
Property Value
Type Description
System.Nullable<System.Guid>

QueryableItemID

The item of the specified type that you want to query

A queryable item inherits IQueryableItem

Declaration
[EntityProperty(SQLType.NVarChar, (short)500, false)]
[EntityDescription("The id of this queryable item.")]
string QueryableItemID { get; set; }
Property Value
Type Description
System.String

QueryableItemSubID

The sub id of this queryable item.

Declaration
[EntityProperty(SQLType.NVarChar, (short)500, true)]
[EntityDescription("The sub id of this queryable item.")]
string QueryableItemSubID { get; set; }
Property Value
Type Description
System.String

QueryableItemTypeName

The type of item you want to query. This can be an Entity, History, or Query.

Declaration
[EntityProperty(SQLType.NVarChar, (short)50, false)]
[EntityDescription("The type of queryable item.")]
[Required]
string QueryableItemTypeName { get; set; }
Property Value
Type Description
System.String

ReplicateForAll

If the queryable item type is a type that has sub Queryable Item Options, such as permissions, then this indicates you want to replicate your query for every option and union the results together.

Declaration
[EntityProperty(SQLType.Bit, false, "0")]
[EntityDescription("Indicates this queryable item should be replicated for each possible type in the function.")]
bool ReplicateForAll { get; set; }
Property Value
Type Description
System.Boolean

Sequence

Holds the order of this queryable item in the set.

Declaration
[EntityProperty(SQLType.SmallInt, false, "0")]
[EntityDescription("Holds the order of this queryable item in the set.")]
[EntitySequence]
short Sequence { get; set; }
Property Value
Type Description
System.Int16

Extension Methods

See Also