[EntityDefinition(EntityID.GroupingItem, "dbo.LT_GroupingItems", "GroupingItem", IsStandingDataEntity = false)]
[DefaultEntityIcon(ImageType.Grouping)]
[EntityIndex(Name = "Grouping", ColumnNames = new string[] { "GroupingID" }, IndexOrder = new IndexOrder[] { IndexOrder.Ascending }, IsClustered = false, IsUnique = false)]
[EntityIndex(Name = "GroupingItem", ColumnNames = new string[] { "ItemID", "GroupingID" }, IndexOrder = new IndexOrder[] { IndexOrder.Ascending, IndexOrder.Ascending }, IncludeColumns = new string[] { "Operator" }, IsClustered = false, IsUnique = false)]
[EntityIndex(Name = "GroupingRelated", ColumnNames = new string[] { "RelatedItemID", "GroupingID" }, IndexOrder = new IndexOrder[] { IndexOrder.Ascending, IndexOrder.Ascending }, IncludeColumns = new string[] { "Operator" }, IsClustered = false, IsUnique = false)]
public interface IGroupingItem : IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackProperties

Properties

Amount

The amount to use in other processes (such as split transaction) for these grouped entities

Declaration

[EntityProperty(SQLType.Decimal, 31, 18, true)]
[EntityDescription("The amount to use in other processes (such as split transaction) for these grouped entities.")]
decimal? Amount { get; set; }

Property Value

Type	Description
decimal?

Description

User friendly description of this item

Declaration

[EntityProperty(SQLType.NVarChar, true)]
[EntityDescription("User friendly description of this item.")]
string Description { get; set; }

Property Value

Type	Description
string

GroupingID

[Key] Links to IGrouping. The grouping this item belongs to.

Declaration

[EntityDescription("The grouping this item belongs to.")]
[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityKeyProperty]
[EntityRelationship(EntityID.Grouping, "ID", SingleJoinType.One, "Grouping", "Grouped Items", DeleteWithRelationship = true, PartOfParentSet = true, LinkToItemInSet = false, InheritPermissions = true)]
[RequiredNoDefaultIDValidation]
Guid GroupingID { get; set; }

Property Value

Type	Description
Guid

ItemID

The globally unique id of the entity (of type ItemTypeID) that is contained within this grouping

Declaration

[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityDescription("The globally unique id of the entity (ItemTypeID) that is contained within this grouping.")]
[EntityLinkToAnyParentRelationship("ItemTypeID", SingleJoinType.One, "Grouping Items", false, new Type[] { typeof(IVennSetQueryableItem), typeof(ISQLTypeWrapper), typeof(IDatasetQueryableItem) }, DeleteWithRelationship = false, OnlyWithLabels = true)]
[EntityKeyProperty]
Guid ItemID { get; set; }

Property Value

Type	Description
Guid

ItemTypeID

The type of item

Declaration

[EntityProperty(SQLType.UniqueIdentifier, false, IsEntityTypeLink = true)]
[EntityDescription("The type of item.")]
Guid ItemTypeID { get; set; }

Property Value

Type	Description
Guid

Operator

An operator to use for aggregating grouped items in query tools

Declaration

[EntityProperty(SQLType.SmallInt, false, "1")]
[Required]
[HardCodedDefaultValueOnNew("1")]
[EntityDescription("An operator to use for aggregating grouped items in query tools")]
MathOperator Operator { get; set; }

Property Value

Type	Description
MathOperator

RelatedItemID

The globally unique id of the entity (of type ItemTypeID) that is related within this grouping

Declaration

[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityDescription("The globally unique id of the entity (ItemTypeID) that is related within this grouping.")]
[EntityLinkToAnyParentRelationship("RelatedItemTypeID", SingleJoinType.One, "Related Grouping Items", false, new Type[] { typeof(IVennSetQueryableItem), typeof(ISQLTypeWrapper), typeof(IDatasetQueryableItem) }, OnlyWithLabels = true)]
Guid? RelatedItemID { get; set; }

Property Value

Type	Description
Guid?

RelatedItemTypeID

The type of related item

Declaration

[EntityProperty(SQLType.UniqueIdentifier, true, IsEntityTypeLink = true)]
[EntityDescription("The type of related item.")]
Guid? RelatedItemTypeID { get; set; }

Property Value

Type	Description
Guid?

Sequence

[Key] Holds the order of this grouping item within the whole the parent grouping

This field is hidden in the grid, but you can show it using our standard grid commands. You can easily change it using the Move Up/Down commands too.

Declaration

[EntityProperty(SQLType.SmallInt, false, "0")]
[EntityDescription("Holds the order of this grouping item within the whole the parent grouping.")]
[EntitySequence]
short Sequence { get; set; }

Property Value

Type	Description
short

Extension Methods

LinqExtensions.AsArray<T>(T)

LinqExtensions.ToArrayOfOne<T>(T)

LinqExtensions.ToListOfOne<T>(T)

MiscExtensions.SetIfNotEqual<T, TP>(T, Expression<Func<T, TP>>, TP)

WeakReferenceExtensions.WeakReference(object)

SQLExtensions.ToSQLValue(object, bool)

ReflectionExtensions.ClearEventInvocations(object, string)

StringExtensions.ToCSVFormatString(object, Type)