Interface IDatasetQueryableItem
The system entity for a DataSet Queryable Item, which belongs to a IDataset
See https://web.lemonedge.com/help/dataset-queryable-items-view/ for more information
Inherited Members
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 |