Class FormulaFunctionsWithQueryRunnerResults

The context supplied while executing formulas that are pass parameters to IQueryRunnerStep while processing a IQueryRunner

Inheritance

System.Object

StandardFunctions

FormulaFunctions

FormulaFunctionsWithQueryRunnerResults

Implements

IFormulaFunctions

Inherited Members

FormulaFunctions.Data

FormulaFunctions.Cache

FormulaFunctions.User

FormulaFunctions.GetContextItemType(Object)

FormulaFunctions.GetItemPropertyValue(Object, String)

FormulaFunctions.GetItemFromDataSourceID(String, String)

FormulaFunctions.GetItemFromDataSourceID(String, String, String)

FormulaFunctions.GetItem(String, Guid)

FormulaFunctions.RunQuery(String, String, String[])

FormulaFunctions.GetQueryItems(String, String, String, String)

StandardFunctions.FormatAsString(Object)

StandardFunctions.Null()

StandardFunctions.IsNull(Object)

StandardFunctions.Not(Boolean)

StandardFunctions.Or(Boolean, Boolean)

StandardFunctions.And(Boolean, Boolean)

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(Int32, Int32)

StandardFunctions.Trim(String)

StandardFunctions.TrimStart(String, Char[])

StandardFunctions.TrimEnd(String, Char[])

StandardFunctions.PadLeft(String, Int32, Char)

StandardFunctions.PadRight(String, Int32, Char)

StandardFunctions.Mod(Double, Double)

StandardFunctions.If(Boolean, 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(Int32, Int32, Int32)

StandardFunctions.Year(DateTime)

StandardFunctions.Month(DateTime)

StandardFunctions.Day(DateTime)

StandardFunctions.WeekDay(DateTime)

StandardFunctions.Replace(String, String, String)

StandardFunctions.Substr(String, Int32, Int32)

StandardFunctions.Len(String)

StandardFunctions.Abs(Double)

StandardFunctions.Int(Object)

StandardFunctions.Trunc(Double, Int32)

StandardFunctions.Dec(Object)

StandardFunctions.Round(Object)

StandardFunctions.IsBlank(String)

StandardFunctions.Round(Object, Int32)

StandardFunctions.Min(Double, Double, Double, Double, Double)

StandardFunctions.Max(Double, Double, Double, Double, Double)

StandardFunctions.Chr(Int32)

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.ValDecimal(Object)

StandardFunctions.ValLong(Object)

StandardFunctions.ValID(Object)

StandardFunctions.DateAdd(DateTime, 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()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: LemonEdge.Core

Assembly: API.dll

Syntax

public class FormulaFunctionsWithQueryRunnerResults : FormulaFunctions, IFormulaFunctions

Constructors

FormulaFunctionsWithQueryRunnerResults(IEntityRetriever, IReadOnlyCache, UserInfo, Dictionary<String, Object>, IBaseEntity, SQLWrapperInterpretor, ISQLWrapperResult, String, Int32, IQueryRunnerStep, IQueryRunner)

Creates a new formula functions for helping with custom formulas as a context to operate against

Declaration

public FormulaFunctionsWithQueryRunnerResults(IEntityRetriever retriever, IReadOnlyCache cache, UserInfo user, Dictionary<string, object> parameters, IBaseEntity entityResult, SQLWrapperInterpretor interprator, ISQLWrapperResult result, string uniqueKeyForThisRunnerExecution, int runnerExecutionRowNumber, IQueryRunnerStep step, IQueryRunner runner)

Parameters

Type	Name	Description
IEntityRetriever	retriever	A context allowing formulas to load and query any data from LemonEdge
IReadOnlyCache	cache	A local cache
UserInfo	user	The current user executing the formula
System.Collections.Generic.Dictionary<System.String, System.Object>	parameters	All parameters provided for executing the query runner sql wrapper
IBaseEntity	entityResult	The entity result if this runner is enumerating a list of entities. Can be null if enumerating results from a SQL Wrapper instead.
SQLWrapperInterpretor	interprator	The sql wrapper interprator for the runner query being executed. Can be null if using an entity result set instead
ISQLWrapperResult	result	The actual current result from the query runner sql wrapper that is being used to execute this step. Can be null if using an entity result set instead
System.String	uniqueKeyForThisRunnerExecution	The unique key for this execution of the query runner sql wrapper
System.Int32	runnerExecutionRowNumber	The current row number for this result of the query runner sql wrapper
IQueryRunnerStep	step	The current step this result is being used to execute
IQueryRunner	runner

Properties

QueryRunner

The query runner this result is being executed against

Declaration

public IQueryRunner QueryRunner { get; }

Property Value

Type	Description
IQueryRunner

QueryRunnerStep

The query runner step this result is being executed against

Declaration

public IQueryRunnerStep QueryRunnerStep { get; }

Property Value

Type	Description
IQueryRunnerStep

RunnerExecutionRowNumber

The number of the row result from the query executed against the query runner

Declaration

public int RunnerExecutionRowNumber { get; }

Property Value

Type	Description
System.Int32

UniqueKeyForThisRunnerExecution

The unique key for the run instance of this IQueryRunner

Declaration

public string UniqueKeyForThisRunnerExecution { get; }

Property Value

Type	Description
System.String

Methods

GetOriginalRunnerParameter(String)

Returns the original parameter value used for the Query Runner from the specified parameter name.

Declaration

public object GetOriginalRunnerParameter(string paramName)

Parameters

Type	Name	Description
System.String	paramName	The name of the original parameter you want to return the value of.

Returns

Type	Description
System.Object	The original parameter value used for the Query Runner from the specified parameter name.

GetRunnerResult(String)

Returns the result value from the Query Runner from the specified column/property name.

Declaration

public object GetRunnerResult(string columnName)

Parameters

Type	Name	Description
System.String	columnName	The name of the column, or property, for the result you want to return the value of.

Returns

Type	Description
System.Object	The result value from the Query Runner from the specified column/property name.

Implements

IFormulaFunctions

Extension Methods

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

ReflectionExtensions.ClearEventInvocations(Object, String)

StringExtensions.ToCSVFormatString(Object, Type)

SQLExtensions.ToSQLValue(Object, Boolean)

See Also

FormulaFunctionsWithContext<T>

FormulaFunctions