Search Results for

    Show / Hide Table of Contents

    Class DatasetShortcutFormulaContext

    Inheritance
    object
    StandardFunctions
    FormulaFunctions
    FormulaFunctionsWithUpdater
    FormulaFunctionsWithContext<IDatasetShortcut>
    DatasetShortcutFormulaContext
    Implements
    IFormulaFunctionsWithContext<IDatasetShortcut>
    IFormulaFunctionsWithContext
    IFormulaFunctions
    Inherited Members
    FormulaFunctionsWithContext<IDatasetShortcut>.TestEvents()
    FormulaFunctionsWithContext<IDatasetShortcut>.ItemAs<T1>()
    FormulaFunctionsWithContext<IDatasetShortcut>.SetExtendedPropertyValue(IBaseEntity, string, string, object)
    FormulaFunctionsWithContext<IDatasetShortcut>.SetBusy(string)
    FormulaFunctionsWithContext<IDatasetShortcut>.StopBusy()
    FormulaFunctionsWithContext<IDatasetShortcut>.CreateFormulaContext(Type)
    FormulaFunctionsWithContext<IDatasetShortcut>.GetValue(string)
    FormulaFunctionsWithContext<IDatasetShortcut>.GetValue<T2>(string)
    FormulaFunctionsWithContext<IDatasetShortcut>.GetAnswerTotal(string)
    FormulaFunctionsWithContext<IDatasetShortcut>.GetContextType(EntityDescriptor)
    FormulaFunctionsWithContext<IDatasetShortcut>.MyItem
    FormulaFunctionsWithContext<IDatasetShortcut>.Item
    FormulaFunctionsWithContext<IDatasetShortcut>.PropertyChangedItem
    FormulaFunctionsWithContext<IDatasetShortcut>.PropertyChangedName
    FormulaFunctionsWithContext<IDatasetShortcut>.PropertyChangedAlias
    FormulaFunctionsWithContext<IDatasetShortcut>.ChangedItemType
    FormulaFunctionsWithUpdater.SetCustomParameters(Dictionary<string, object>)
    FormulaFunctionsWithUpdater.CreateNewData()
    FormulaFunctionsWithUpdater.CreateNewItem(string)
    FormulaFunctionsWithUpdater.CreateNewItem<T>()
    FormulaFunctionsWithUpdater.GetCustomParamValue(string)
    FormulaFunctionsWithUpdater.HasCustomParamValue(string)
    FormulaFunctionsWithUpdater.HasCustomParamValueEqualTo(string, object)
    FormulaFunctionsWithUpdater.RunCodeSnippet(string, params string[])
    FormulaFunctionsWithUpdater.MyData
    FormulaFunctions.ShareThisQueryCacheWithTarget(IFormulaFunctions)
    FormulaFunctions.SetQueryRunnerHelper(Func<IEntityUpdater, ISQLWrapperInterpretor, Dictionary<string, string>, QueryableExecuter<ISQLWrapperResult>, Task<DataRow[]>>)
    FormulaFunctions.GetItemPropertyValue(object, string)
    FormulaFunctions.GetTaskID(string)
    FormulaFunctions.GetTaskParameter(string)
    FormulaFunctions.SetObjectValue(object, string, object)
    FormulaFunctions.GetObjectValue(object, string)
    FormulaFunctions.GetExtendedPropertyValue(IBaseEntity, string, string)
    FormulaFunctions.GetExtendedPropertyItem(IBaseEntity, string)
    FormulaFunctions.GetExtendedObject(IBaseEntity, string, bool)
    FormulaFunctions.GetEntityTypeID(string)
    FormulaFunctions.Evaluate<T>(string, bool)
    FormulaFunctions.IsValid<T>(string)
    FormulaFunctions.IsValid<T>(string, Type)
    FormulaFunctions.GetContextItemType(object)
    FormulaFunctions.GetItemFromDataSourceID(string, string)
    FormulaFunctions.GetItemFromDataSourceID(string, string, string)
    FormulaFunctions.GetItem(string, Guid)
    FormulaFunctions.GetItemAs<T>(Guid)
    FormulaFunctions.GetItems(string, QueryableFilter)
    FormulaFunctions.GetFirstOrDefaultItem(string, QueryableFilter)
    FormulaFunctions.GetItems(string, string, SQLOperator, object)
    FormulaFunctions.GetFirstOrDefaultItem(string, string, SQLOperator, object)
    FormulaFunctions.GetItems<T>(QueryableFilter)
    FormulaFunctions.GetFirstOrDefaultItem<T>(QueryableFilter)
    FormulaFunctions.GetItems<T>(string, SQLOperator, object)
    FormulaFunctions.GetFirstOrDefaultItem<T>(string, SQLOperator, object)
    FormulaFunctions.GetEnumValue(object)
    FormulaFunctions.GetEnumCode(object)
    FormulaFunctions.XIRR(string, string, string, params string[])
    FormulaFunctions.XIRR(string, string, string, (string, object)[], params string[])
    FormulaFunctions.TWR(string, string, string, string, params string[])
    FormulaFunctions.TWRRow(string, string, string, string, params string[])
    FormulaFunctions.RunQuery(string, string, params string[])
    FormulaFunctions.HasQueryResult(string, params string[])
    FormulaFunctions.GetQueryResult(ISQLWrapperResult, string)
    FormulaFunctions.GetQueryResult(DataRow, string)
    FormulaFunctions.GetQueryResult(string, string, ISQLWrapperResult)
    FormulaFunctions.GetQueryResult(string, string, DataRow)
    FormulaFunctions.GetQueryResult(string, string, ISQLWrapperResult[], string, object)
    FormulaFunctions.RunQueryResult(string, params string[])
    FormulaFunctions.RunDRQueryResult(string, params string[])
    FormulaFunctions.LogInfo(string, params object[])
    FormulaFunctions.LogError(Exception, string, params object[])
    FormulaFunctions.GetQueryCount(string, string, string)
    FormulaFunctions.GetQueryItems(string, string, string, string)
    FormulaFunctions.GetDRQueryItems(string, string, string, string)
    FormulaFunctions.Data
    FormulaFunctions.Cache
    FormulaFunctions.Services
    FormulaFunctions.User
    StandardFunctions.FormatAsString(object)
    StandardFunctions.Null()
    StandardFunctions.IsNull(object)
    StandardFunctions.Not(bool)
    StandardFunctions.Or(bool, bool)
    StandardFunctions.And(bool, bool)
    StandardFunctions.Sin(double)
    StandardFunctions.Cos(double)
    StandardFunctions.Now()
    StandardFunctions.Today()
    StandardFunctions.TodayString()
    StandardFunctions.EndOfMonth(DateTime)
    StandardFunctions.BeginningOfMonth(DateTime)
    StandardFunctions.BeginningOfWeek(DateTime)
    StandardFunctions.EndOfYear(DateTime)
    StandardFunctions.EndOfDay(DateTime)
    StandardFunctions.Floor(decimal)
    StandardFunctions.Ceiling(decimal)
    StandardFunctions.BeginningOfYear(DateTime)
    StandardFunctions.BeginningOfDay(DateTime)
    StandardFunctions.Random(int, int)
    StandardFunctions.Trim(string)
    StandardFunctions.TrimStart(string, char[])
    StandardFunctions.TrimEnd(string, char[])
    StandardFunctions.PadLeft(string, int, char)
    StandardFunctions.PadRight(string, int, char)
    StandardFunctions.Mod(double, double)
    StandardFunctions.If(bool, object, object)
    StandardFunctions.IsIn(object, object)
    StandardFunctions.IsIn(object, object, object)
    StandardFunctions.IsIn(object, object, object, object)
    StandardFunctions.IsIn(object, object, object, object, object)
    StandardFunctions.IsIn(object, object, object, object, object, object)
    StandardFunctions.IsIn(object, object, object, object, object, object, object)
    StandardFunctions.IsIn(object, object, object, object, object, object, object, object)
    StandardFunctions.IsIn(object, object, object, object, object, object, object, object, object)
    StandardFunctions.IsIn(object, object, object, object, object, object, object, object, object, object)
    StandardFunctions.IsIn(object, object, object, object, object, object, object, object, object, object, object)
    StandardFunctions.SelectCase(object, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>)
    StandardFunctions.SelectCase(object, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>)
    StandardFunctions.SelectCase(object, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>)
    StandardFunctions.SelectCase(object, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>)
    StandardFunctions.SelectCase(object, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>)
    StandardFunctions.SelectCase(object, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>)
    StandardFunctions.SelectCase(object, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>)
    StandardFunctions.SelectCase(object, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>)
    StandardFunctions.SelectCase(object, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>)
    StandardFunctions.SelectCase(object, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>, Func<Task<object>>)
    StandardFunctions.Format(object, string)
    StandardFunctions.Lower(string)
    StandardFunctions.Upper(string)
    StandardFunctions.WCase(string)
    StandardFunctions.Date(int, int, int)
    StandardFunctions.Year(DateTime)
    StandardFunctions.Month(DateTime)
    StandardFunctions.Day(DateTime)
    StandardFunctions.WeekDay(DateTime)
    StandardFunctions.Replace(string, string, string)
    StandardFunctions.Substr(string, int, int)
    StandardFunctions.Len(string)
    StandardFunctions.Abs(double)
    StandardFunctions.Int(object)
    StandardFunctions.Trunc(double, int)
    StandardFunctions.Dec(object)
    StandardFunctions.Round(object)
    StandardFunctions.IsBlank(string)
    StandardFunctions.Round(object, int)
    StandardFunctions.Min(double, double, double, double, double)
    StandardFunctions.Max(double, double, double, double, double)
    StandardFunctions.Chr(int)
    StandardFunctions.ChCR()
    StandardFunctions.ChLF()
    StandardFunctions.ChCRLF()
    StandardFunctions.Money(object)
    StandardFunctions.Contains(string, string)
    StandardFunctions.FormatDate(DateTime, string)
    StandardFunctions.Sqrt(double)
    StandardFunctions.Power(double, double)
    StandardFunctions.ValString(object)
    StandardFunctions.ValBool(object)
    StandardFunctions.ValDate(object)
    StandardFunctions.ValDateTimeOffset(object)
    StandardFunctions.ValDecimal(object)
    StandardFunctions.ValLong(object)
    StandardFunctions.ValID(object)
    StandardFunctions.DateAdd(DateTime, decimal, decimal, decimal)
    StandardFunctions.DateAdd(DateTimeOffset, decimal, decimal, decimal)
    StandardFunctions.DateAddWorkDays(DateTime, decimal)
    StandardFunctions.DateAdd(DateTime, DateTime)
    StandardFunctions.DayDifference(DateTime, DateTime)
    StandardFunctions.DayDifferenceWorkDays(DateTime, DateTime)
    StandardFunctions.HourDifference(DateTime, DateTime)
    StandardFunctions.MinuteDifference(DateTime, DateTime)
    StandardFunctions.YearDifference(DateTime, DateTime)
    StandardFunctions.NullDate()
    StandardFunctions.NullDateTimeOffset()
    StandardFunctions.TempValue1
    object.GetType()
    object.MemberwiseClone()
    object.ToString()
    object.Equals(object)
    object.Equals(object, object)
    object.ReferenceEquals(object, object)
    object.GetHashCode()
    Namespace: LemonEdge.API.Core.Formulas
    Assembly: LemonEdge.API.dll
    Syntax
    public class DatasetShortcutFormulaContext : FormulaFunctionsWithContext<IDatasetShortcut>, IFormulaFunctionsWithContext<IDatasetShortcut>, IFormulaFunctionsWithContext, IFormulaFunctions

    Constructors

    DatasetShortcutFormulaContext(IEntityRetriever, IReadOnlyCache, UserInfo, IDatasetShortcut, IFormulaFunctionsServiceContext)

    Declaration
    public DatasetShortcutFormulaContext(IEntityRetriever retriever, IReadOnlyCache cache, UserInfo user, IDatasetShortcut item, IFormulaFunctionsServiceContext services)
    Parameters
    Type Name Description
    IEntityRetriever retriever
    IReadOnlyCache cache
    UserInfo user
    IDatasetShortcut item
    IFormulaFunctionsServiceContext services

    Properties

    CurrentMultiColumnName

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

    CurrentParamDefaultFormulaOrColumnCalc

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

    DataSetProcessor

    Declaration
    public IDataSetProcessor DataSetProcessor { get; set; }
    Property Value
    Type Description
    IDataSetProcessor

    SelectedColumns

    Declaration
    public IEnumerable<string> SelectedColumns { get; set; }
    Property Value
    Type Description
    IEnumerable<string>

    Methods

    AreAnyColumnsSelected(params string[])

    Declaration
    [FormulaFunction(Name = "AreAnyColumnsSelected", Type = "DatasetShortcut", Description = "Returns true if any of the specified column names have been selected by the user.", Params = "1. The name of the column to check for.\r\n2. Additional column names to check for....", ParamCount = 2, IsAsync = false)]
    public bool AreAnyColumnsSelected(params string[] columnNames)
    Parameters
    Type Name Description
    string[] columnNames
    Returns
    Type Description
    bool

    GetCurrentMultiColumnNameWithoutPrePostFixes(string, string)

    Declaration
    [FormulaFunction(Name = "GetCurrentMultiColumnNameWithoutPrePostFixes", Type = "DatasetShortcut", Description = "Returns the current CurrentMultiColumnName but with the specified pre and post fix removed.", Params = "1. A prefix to remove from the name.\r\n2. The current CurrentMultiColumnName (which is the current name returned from New Column Name if it returns multiple names).\r\n3. A postfix to remove from the name", ParamCount = 3, IsAsync = false)]
    public string GetCurrentMultiColumnNameWithoutPrePostFixes(string preFix, string postFix)
    Parameters
    Type Name Description
    string preFix
    string postFix
    Returns
    Type Description
    string

    GetMultiSelectResults(string)

    Declaration
    [FormulaFunction(Name = "GetMultiSelectResults", Type = "DatasetShortcut", Description = "Returns a list of (id, name) for all possible selected values from a custom parameter that allows multiple selections.", Params = "1. The name of the custom parameter that is a multi select control.", ParamCount = 1, IsAsync = false)]
    public List<(Guid, string)> GetMultiSelectResults(string paramName)
    Parameters
    Type Name Description
    string paramName
    Returns
    Type Description
    List<(Guid, string)>

    GetNewNames(string, List<(Guid, string)>, string)

    Declaration
    [FormulaFunction(Name = "GetNewNames", Type = "DatasetShortcut", Description = "Returns a list of names formed of the specified prefix and postfix for each name in a list of multiple names. The list is of the form (id, name) so it can come straight from GetMultiSelectResults function.", Params = "1. A prefix to apply to every returned name.\r\n2. A list of (id, name) every name to return a new name for.\r\n3. A postfix to apply to every returned name", ParamCount = 3, IsAsync = false)]
    public string[] GetNewNames(string preFix, List<(Guid, string)> multipleNames, string postFix)
    Parameters
    Type Name Description
    string preFix
    List<(Guid, string)> multipleNames
    string postFix
    Returns
    Type Description
    string[]

    Init()

    Declaration
    public Task Init()
    Returns
    Type Description
    Task

    IsColumnSelected(string)

    Declaration
    [FormulaFunction(Name = "IsColumnSelected", Type = "DatasetShortcut", Description = "Returns true if the specified column name has been selected by the user.", Params = "1. The name of the column to check for.", ParamCount = 1, IsAsync = false)]
    public bool IsColumnSelected(string columnName)
    Parameters
    Type Name Description
    string columnName
    Returns
    Type Description
    bool

    Test3()

    Declaration
    public Task<string> Test3()
    Returns
    Type Description
    Task<string>

    Test4()

    Declaration
    public string Test4()
    Returns
    Type Description
    string

    Implements

    IFormulaFunctionsWithContext<T>
    IFormulaFunctionsWithContext
    IFormulaFunctions

    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.