Interface IDatasetShortcutOverride
Assembly: LemonEdge.API.dll
Syntax
[EntityDefinition(EntityID.DatasetShortcutOverride, "dbo.LT_DatasetShortcutOverrides", "DatasetShortcutOverride", IsStandingDataEntity = false)]
[EntityLinkToAnyParentRelationshipModifier(EntityID.SQLWrapper, "OwnerEntityID", "ID", ExcludeFromRelationship = true)]
[EntityIndex(Name = "DatasetShortcut", ColumnNames = new string[] { "DatasetShortcutID" }, IndexOrder = new IndexOrder[] { IndexOrder.Ascending }, IsClustered = false, IsUnique = false)]
public interface IDatasetShortcutOverride : IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackProperties
Properties
ColumnID
Declaration
[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityDescription("The column to optionally include.")]
[EntityRelationship(EntityID.SQLTypeWrapper, "ID", SingleJoinType.ZeroToOne, "Column", "Dataset Shortcut Overrides", DeleteWithRelationship = true, PartOfParentSet = true, LinkToItemInSet = false, InheritPermissions = false)]
Guid? ColumnID { get; set; }
Property Value
DatasetShortcutID
Declaration
[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.DatasetShortcut, "ID", SingleJoinType.One, "Dataset Shortcut", "Overrides", DeleteWithRelationship = true, PartOfParentSet = true, LinkToItemInSet = false, InheritPermissions = true)]
[RequiredNoDefaultIDValidation]
[EntityKeyProperty]
Guid DatasetShortcutID { get; set; }
Property Value
NewColumnName
Declaration
[EntityProperty(SQLType.NVarChar, true)]
[EntityDescription("A formula that returns a new column name.")]
string NewColumnName { get; set; }
Property Value
Declaration
[EntityProperty(SQLType.NVarChar, false)]
[EntityDescription("The formula returning true or false to indicate if this should be included in the shortcut or not.")]
string OverrideFormula { get; set; }
Property Value
ParameterID
Declaration
[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityDescription("The parameter to optionally include.")]
[EntityRelationship(EntityID.SQLTypeWrapper, "ID", SingleJoinType.ZeroToOne, "Parameter", "Dataset Shortcut Overrides", DeleteWithRelationship = true, PartOfParentSet = true, LinkToItemInSet = false, InheritPermissions = false)]
Guid? ParameterID { get; set; }
Property Value
QueryableItemID
Declaration
[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityDescription("The QueryableItem to optionally include.")]
[EntityRelationship(EntityID.DatasetQueryableItem, "ID", SingleJoinType.ZeroToOne, "Queryable Item", "Dataset Shortcut Overrides", DeleteWithRelationship = true, PartOfParentSet = true, LinkToItemInSet = false, InheritPermissions = false)]
Guid? QueryableItemID { get; set; }
Property Value
ReplaceColumnFieldKey
Declaration
[EntityProperty(SQLType.VarChar, 50, true)]
[EntityDescription("The field to replace the column with if ReplaceQueryableItemFormula evaluates to true")]
string ReplaceColumnFieldKey { get; set; }
Property Value
Declaration
[EntityProperty(SQLType.NVarChar, true)]
[EntityDescription("A formula that given a column calc, or param default formula, (Held in CurrentParamDefaultFormulaOrColumnCalc property in formula context) returns a new one.")]
string ReplaceParamDefaultFormulaOrColumnCalcFormula { get; set; }
Property Value
Declaration
[EntityProperty(SQLType.NVarChar, true)]
[EntityDescription("A formula that inidcates if the specified queryable item should be replaced with a different one.")]
string ReplaceQueryableItemFormula { get; set; }
Property Value
ReplaceQueryableItemID
Declaration
[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityDescription("The QueryableItem to replace the existing one with if ReplaceQueryableItemFormula evaluates to true. Works for queryable item and columns.")]
[EntityRelationship(EntityID.DatasetQueryableItem, "ID", SingleJoinType.ZeroToOne, "Replace Queryable Item", "Dataset Shortcut Overrides", DeleteWithRelationship = true, PartOfParentSet = true, LinkToItemInSet = false, InheritPermissions = false)]
Guid? ReplaceQueryableItemID { get; set; }
Property Value
ReplaceSingleIDSourceQueryableItemField
Declaration
[EntityProperty(SQLType.VarChar, 50, true)]
[EntityDescription("Replaces the join that joins to this target items ID field with the specified source queryable field instead.")]
string ReplaceSingleIDSourceQueryableItemField { get; set; }
Property Value
RootWhereFilterID
Declaration
[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityDescription("The where filter to optionally include.")]
[EntityRelationship(EntityID.FilterDescriptor, "ID", SingleJoinType.ZeroToOne, "Filter", "Dataset Shortcut Overrides", DeleteWithRelationship = true, PartOfParentSet = true, LinkToItemInSet = false, InheritPermissions = false)]
Guid? RootWhereFilterID { get; set; }
Property Value
Extension Methods