Search Results for

    Show / Hide Table of Contents

    Class QueryRunner

    Inheritance
    object
    BaseEntity
    BaseEntityWithPermissions
    QueryRunner
    Implements
    IQueryRunner
    IBaseEntityWithPermissions
    ISetCopier
    IHasVersion
    IUserSpecific
    IHasFolderStructure
    IBaseEntity
    IEquatable<IBaseEntity>
    INotifyPropertyChanged
    INotifyPropertyChanging
    ICloneableAsync
    ICanTrackProperties
    ICloneableAsync<IQueryRunner>
    IUserSpecificPublicToggle
    ISetCopierCloneAlterer
    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 QueryRunner : BaseEntityWithPermissions, IQueryRunner, IBaseEntityWithPermissions, ISetCopier, IHasVersion, IUserSpecific, IHasFolderStructure, IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackProperties, ICloneableAsync<IQueryRunner>, IUserSpecificPublicToggle, ISetCopierCloneAlterer

    Constructors

    QueryRunner()

    Declaration
    public QueryRunner()

    Properties

    Base64SerializedQueryExecuter

    An optional QueryableExecuter used to filter the SQLWrapperID or EntityTypeID result set

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

    CopierCloneType

    Declaration
    public SetCopierCloneType CopierCloneType { get; set; }
    Property Value
    Type Description
    SetCopierCloneType

    Description

    A user friendly description for this query runner

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

    DisableTestRuns

    Indicates if this query runner can be run in test mode or not by the user

    Declaration
    public bool DisableTestRuns { get; set; }
    Property Value
    Type Description
    bool

    EntityTypeID

    The type of entity to use as results to call other QueryRunHandlers.

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

    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

    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

    MergeSameFileTypes

    Indicates if this query runner should attempt to merge the resulting files in certain ways. Currently only works on the client for excel files.

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

    MergeSameFileTypes_Tooltip

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

    Name

    [Key] The unique name for this query runner

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

    SQLWrapperID

    The sql wrapper this query runner executes and uses the results of to call other QueryRunHandlers

    Declaration
    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

    AlterCopiedItem(IEntityUpdater, UserInfo, IReadOnlyCache, IBaseEntity)

    A custom ability to alter this item when it is was copied by the user in the UI, not when it is being imported

    Declaration
    public Task AlterCopiedItem(IEntityUpdater host, UserInfo user, IReadOnlyCache cache, IBaseEntity sourceItem)
    Parameters
    Type Name Description
    IEntityUpdater host

    The context this item was copied into

    UserInfo user

    The current user

    IReadOnlyCache cache

    The current local cache

    IBaseEntity sourceItem

    The original source item this item was copied from

    Returns
    Type Description
    Task

    A task inidicating the finishing of this method

    CopyFromEntity(IBaseEntity)

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

    CopyFromSource(IQueryRunner)

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

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

    The source object to copy all values from.

    CopyRelatedItem(IBaseEntity, EntityRelationship)

    Determines whether the source item should be copied based on the provided relationship

    Declaration
    public bool CopyRelatedItem(IBaseEntity sourceItem, EntityRelationship rel)
    Parameters
    Type Name Description
    IBaseEntity sourceItem

    The original source item this item was copied from

    EntityRelationship rel

    The particular relationship from the source item

    Returns
    Type Description
    bool

    ToString()

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

    Implements

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

    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.