Search Results for

    Show / Hide Table of Contents

    Class Pivot

    Inheritance
    object
    BaseEntity
    BaseEntityWithPermissions
    Pivot
    Implements
    IPivot
    IBaseEntityWithPermissions
    ISetCopier
    IHasVersion
    IUserSpecific
    IHasFolderStructure
    IBaseEntity
    IEquatable<IBaseEntity>
    INotifyPropertyChanged
    INotifyPropertyChanging
    ICloneableAsync
    ICanTrackProperties
    ICloneableAsync<IPivot>
    IUserSpecificPublicToggle
    Inherited Members
    BaseEntityWithPermissions.IsLocked(object)
    BaseEntityWithPermissions.CanWriteItem(object, IEntityRetriever, IReadOnlyCache, Guid)
    BaseEntityWithPermissions.PreLoadPermissions<T>(IEnumerable<T>, IEntityRetriever, IReadOnlyCache, Guid)
    BaseEntityWithPermissions.CanDeleteItem(object, IEntityRetriever, IReadOnlyCache, Guid)
    BaseEntityWithPermissions.CanChangeItemPermissions(object, IEntityRetriever, IReadOnlyCache, Guid)
    BaseEntity.HISTORY_ENDROWUPDATE_COLNAME
    BaseEntity.HasTrackedPropertyChanged(string)
    BaseEntity.OriginalTrackedPropertyValue(string)
    BaseEntity.OriginalTrackedPropertyValue<T>(string)
    BaseEntity.ClearTrackedOriginalValues()
    BaseEntity.GetAllOriginalTrackedPropertyValues()
    BaseEntity.GetLabel(string)
    BaseEntity.SetLabel(string, string)
    BaseEntity.SetSilentLabel(string, string)
    BaseEntity.ResetChangedTrackedPropertiesToOriginalValues()
    BaseEntity.AddTrackedOriginalValue(string, object)
    BaseEntity.SnapshotProperties()
    BaseEntity.RestoreFromSnapshot(Dictionary<string, object>)
    BaseEntity.IsBasePropertyName(string)
    BaseEntity.IsBaseRelationshipID(string)
    BaseEntity.OnPropertyChanging(string)
    BaseEntity.OnPropertyChanged(string)
    BaseEntity.Equals(IBaseEntity)
    BaseEntity.GetHashCode()
    BaseEntity.Equals(object)
    BaseEntity.Clone(object)
    BaseEntity.CopyFromSource(object)
    BaseEntity.TrackChanges
    BaseEntity.ModifiedByUserID_Label
    BaseEntity.ModifiedByUserID_Label_Silent
    BaseEntity.CanvasID_Label
    BaseEntity.CanvasID_Label_Silent
    BaseEntity.AlgorithmStepID_Label
    BaseEntity.AlgorithmStepID_Label_Silent
    BaseEntity.SafeID_Label
    BaseEntity.SafeID_Label_Silent
    BaseEntity.AccountID
    BaseEntity.ID
    BaseEntity.LastUpdated
    BaseEntity.ModifiedByUserID
    BaseEntity.CanvasID
    BaseEntity.AlgorithmStepID
    BaseEntity.SafeID
    BaseEntity.PropertyChanged
    BaseEntity.PropertyChanging
    object.GetType()
    object.MemberwiseClone()
    object.Equals(object, object)
    object.ReferenceEquals(object, object)
    Namespace: LemonEdge.API.Entities.Reporting
    Assembly: LemonEdge.API.Entities.Auto.dll
    Syntax
    [DataContract]
    public class Pivot : BaseEntityWithPermissions, IPivot, IBaseEntityWithPermissions, ISetCopier, IHasVersion, IUserSpecific, IHasFolderStructure, IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackProperties, ICloneableAsync<IPivot>, IUserSpecificPublicToggle

    Constructors

    Pivot()

    Declaration
    public Pivot()

    Properties

    Description

    A user friendly description of this pivot

    Declaration
    [StringLength(2000)]
    public string Description { get; set; }
    Property Value
    Type Description
    string

    FolderID

    The link to the folder this item is contained in

    Declaration
    public Guid? FolderID { get; set; }
    Property Value
    Type Description
    Guid?

    FolderID_Label

    Declaration
    public string FolderID_Label { get; set; }
    Property Value
    Type Description
    string

    FolderID_Label_Silent

    Declaration
    [NotMapped]
    public string FolderID_Label_Silent { get; set; }
    Property Value
    Type Description
    string

    HelpURL

    A custom url for help on this pivot

    Declaration
    [StringLength(500)]
    public string HelpURL { get; set; }
    Property Value
    Type Description
    string

    IsPublic

    Indicates if this entity is visible to all users (public), or just the current user (private).

    Directly maps to UserID property

    Declaration
    [NotMapped]
    public bool IsPublic { get; set; }
    Property Value
    Type Description
    bool

    IsSystem

    Indicates this item is part of the core system. Any changes will be overwritten if the version number is lower than the provided version number and the item is also marked as a system item.

    Declaration
    [Required]
    public bool IsSystem { get; set; }
    Property Value
    Type Description
    bool

    Name

    [Key] The unique user friendly name for this pivot

    Declaration
    [Unique]
    [Required]
    [StringLength(500)]
    public string Name { get; set; }
    Property Value
    Type Description
    string

    PivotAxis

    The axis to pivot data around.

    Declaration
    [EnumDataType(typeof(PivotAxis))]
    public PivotAxis PivotAxis { get; set; }
    Property Value
    Type Description
    PivotAxis

    PivotAxis_Tooltip

    Declaration
    [NotMapped]
    public string PivotAxis_Tooltip { get; set; }
    Property Value
    Type Description
    string

    SQLWrapperID

    Links to ISQLWrapper. The SQL Wrapper that is used to retrieve data to analyse in this pivot.

    Declaration
    [RequiredNoDefaultIDValidation]
    public Guid SQLWrapperID { get; set; }
    Property Value
    Type Description
    Guid

    SQLWrapperID_Label

    Declaration
    public string SQLWrapperID_Label { get; set; }
    Property Value
    Type Description
    string

    SQLWrapperID_Label_Silent

    Declaration
    [NotMapped]
    public string SQLWrapperID_Label_Silent { get; set; }
    Property Value
    Type Description
    string

    UserID

    Links to IUser. Indicates if this entity record is private to just the specified user, or if it is public to everyone (holding null)

    Declaration
    public Guid? UserID { get; set; }
    Property Value
    Type Description
    Guid?

    UserID_Label

    Declaration
    public string UserID_Label { get; set; }
    Property Value
    Type Description
    string

    UserID_Label_Silent

    Declaration
    [NotMapped]
    public string UserID_Label_Silent { get; set; }
    Property Value
    Type Description
    string

    Version

    Indicates the version number of this item. Changes will only be overwritten if the provided new item has a higer version number than this one.

    Declaration
    [Required]
    [DatabasePropertyValidation("MyItem.IsSystem", "var allUserTeams = await Cache.GetAllItems<LemonEdge.API.Entities.Administration.IUserTeam>(); (await Cache.GetAllItems<LemonEdge.API.Entities.Administration.ITeam>()).Any(x => allUserTeams.Where(ut => ut.UserID == User.ID).Select(ut => ut.TeamID).Contains(x.ID) && x.CanEditSystemItems)", "User is not authorized to modify system items.")]
    public short Version { get; set; }
    Property Value
    Type Description
    short

    Methods

    CopyFromEntity(IBaseEntity)

    Declaration
    protected override void CopyFromEntity(IBaseEntity src)
    Parameters
    Type Name Description
    IBaseEntity src
    Overrides
    BaseEntity.CopyFromEntity(IBaseEntity)

    CopyFromSource(IPivot)

    Updates all properties in this item to have the same properties as the source object.

    Declaration
    public void CopyFromSource(IPivot source)
    Parameters
    Type Name Description
    IPivot source

    The source object to copy all values from.

    ToString()

    Declaration
    public override string ToString()
    Returns
    Type Description
    string
    Overrides
    object.ToString()

    Implements

    IPivot
    IBaseEntityWithPermissions
    ISetCopier
    IHasVersion
    IUserSpecific
    IHasFolderStructure
    IBaseEntity
    IEquatable<T>
    INotifyPropertyChanged
    INotifyPropertyChanging
    ICloneableAsync
    ICanTrackProperties
    ICloneableAsync<T>
    IUserSpecificPublicToggle

    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)
    In this article
    Back to top © LemonEdge Technologies. All rights reserved.