Interface ICustomGridColumn

The system entity for a Custom Grid Column, which belongs to a ICustomGrid holding the design for a grid

See https://web.lemonedge.com/help/custom-grid-columns-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.CustomGridColumn, "dbo.LT_CustomGridColumns", "CustomGridColumn", LabelColumn = "PropName", IsStandingDataEntity = true)]
[DefaultEntityIcon(ImageType.DataTableColumn)]
public interface ICustomGridColumn : IShareAcrossAccounts, IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackProperties

Properties

AggregateFunction

Indicates any aggregate function to apply to footer/groupings of this column.

Declaration
[EntityProperty(SQLType.SmallInt, false)]
[EntityDescription("Indicates any aggregate function to apply to footer/groupings of this column.")]
[HardCodedDefaultValueOnNew("0")]
AggregateFunction AggregateFunction { get; set; }
Property Value
Type Description
AggregateFunction

AllowFiltering

Indicates if the user can filter by this column.

Declaration
[EntityProperty(SQLType.Bit, false)]
[EntityDescription("Indicates if the user can filter by this column.")]
[HardCodedDefaultValueOnNew("1")]
bool AllowFiltering { get; set; }
Property Value
Type Description
System.Boolean

AllowSorting

Indicates if the user can sort by this column.

Declaration
[EntityProperty(SQLType.Bit, false)]
[EntityDescription("Indicates if the user can sort by this column.")]
[HardCodedDefaultValueOnNew("1")]
bool AllowSorting { get; set; }
Property Value
Type Description
System.Boolean

CustomGridID

[Key] Links to ICustomGrid. The parent custom grid this entity is a member of

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

Format

Any custom formatting to apply to the display for this column.

Declaration
[EntityProperty(SQLType.NVarChar, (short)50, true)]
[EntityDescription("Any custom formatting to apply to the display for this column.")]
string Format { get; set; }
Property Value
Type Description
System.String

GroupinName

The grouping name to apply to this column header.

Declaration
[EntityProperty(SQLType.NVarChar, (short)500, true)]
[EntityDescription("The grouping name to apply to this column header.")]
string GroupinName { get; set; }
Property Value
Type Description
System.String

IsEditable

Indicates if the user has permission that they can edit the data in this column. If they don't have permissions they will be unable to edit this field regardless if it is true or not.

Declaration
[EntityProperty(SQLType.Bit, false)]
[EntityDescription("Indicates if the data in this column can be edited by the user.")]
[HardCodedDefaultValueOnNew("1")]
bool IsEditable { get; set; }
Property Value
Type Description
System.Boolean

IsVisible

Indicates if this column should initially be visible to the user.

If not the user can still make it visible through our standard grid commands and can see the data when exporting the grid to excel.

Declaration
[EntityProperty(SQLType.Bit, false)]
[EntityDescription("Indicates if this column is visible by default to the user.")]
[HardCodedDefaultValueOnNew("1")]
bool IsVisible { get; set; }
Property Value
Type Description
System.Boolean

PropName

The name of the property you want to appear as a column in the grid.

The system provides a drop down list of all properties against the Entity Type of this Custom Grid.

Declaration
[EntityProperty(SQLType.NVarChar, (short)500, false)]
[EntityDescription("The property of the entity to display in this custom grid.")]
[Required]
string PropName { get; set; }
Property Value
Type Description
System.String

Sequence

[Key] The sequence specifies which order this column should appear in the grid.

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)]
[EntityDescription("Holds the order of this column within the whole custom grid.")]
[EntitySequence]
short Sequence { get; set; }
Property Value
Type Description
System.Int16

Tooltip

By default the tooltip will be the description (if any) of this property against the entity in the design. You can override that by putting a custom tooltip here.

Declaration
[EntityProperty(SQLType.NVarChar, (short)500, true)]
[EntityDescription("A custom tooltip for this column - overrides the default.")]
string Tooltip { get; set; }
Property Value
Type Description
System.String

UserFriendlyLabel

The column name will by default be the property name or the user friendly version of it. You can override that by putting a custom column header name here.

Declaration
[EntityProperty(SQLType.NVarChar, (short)500, true)]
[EntityDescription("A custom user friendly label for this column - overrides the default.")]
string UserFriendlyLabel { get; set; }
Property Value
Type Description
System.String

Width

The width of this column.

Declaration
[EntityProperty(SQLType.Int, false)]
[EntityDescription("The width of this column.")]
int Width { get; set; }
Property Value
Type Description
System.Int32

Extension Methods

See Also