[EntityDefinition(EntityID.CustomLookupQuery, "dbo.LT_CustomLookupQueries", "CustomLookupQuery", IsStandingDataEntity = true, LabelColumn = "Name")]
[DefaultEntityIcon(ImageType.SQLFile)]
public interface ICustomLookupQuery : IBaseEntityWithPermissions, IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackProperties, ISetCopier

Properties

CurrentIDFormula

The id of the current item is automatically passed to the query if it has a @currentItem parameter. This formula allows you to take that current item and return a different id instead.

Declaration

[EntityProperty(SQLType.NVarChar, true)]
[EntityDescription("The id of the current item is automatically passed to the query if it has a @currentItem parameter. This formula allows you to take that current item and return a different id instead.")]
string CurrentIDFormula { get; set; }

Property Value

Type	Description
string

CurrentIDFormula2

This formula allows you to take that current item and return a different id from @currentItem parameter.

Declaration

[EntityProperty(SQLType.NVarChar, true)]
[EntityDescription("This formula allows you to take that current item and return a different id from @currentItem parameter.")]
string CurrentIDFormula2 { get; set; }

Property Value

Type	Description
string

EntityTypeID

[Key] Indicates what entity you want to provide a custom lookup query for.

Declaration

[EntityProperty(SQLType.UniqueIdentifier, false, IsEntityTypeLink = true)]
[RequiredNoDefaultIDValidation]
Guid EntityTypeID { get; set; }

Property Value

Type	Description
Guid

ForLookupTypeID

Indicates which type/property this lookup should be altered for

Declaration

[EntityProperty(SQLType.UniqueIdentifier, true, IsEntityTypeLink = true)]
[EntityDescription("Indicates which type/property this lookup should be altered for")]
Guid? ForLookupTypeID { get; set; }

Property Value

Type	Description
Guid?

ForLookupTypeProperty

Indicates which type/property this lookup should be altered for

Declaration

[EntityProperty(SQLType.NVarChar, 500, true)]
[EntityDescription("Indicates which type/property this lookup should be altered for")]
string ForLookupTypeProperty { get; set; }

Property Value

Type	Description
string

Name

Declaration

[EntityProperty(SQLType.NVarChar, 500, false, "''")]
[EntityKeyProperty]
string Name { get; set; }

Property Value

Type	Description
string

ParentIDFormula

The id of the parent item is automatically passed to the query if it has a @parentItem parameter. This formula allows you to take that parent item and return a different id instead.

Declaration

[EntityProperty(SQLType.NVarChar, true)]
[EntityDescription("The id of the parent item is automatically passed to the query if it has a @parentItem parameter. This formula allows you to take that parent item and return a different id instead.")]
string ParentIDFormula { get; set; }

Property Value

Type	Description
string

SQLWrapperID

Links to ISQLWrapper. The public sql wrapper that display all properties fo the specified entity type and will be used to override the default entity type picker view with this query

Declaration

[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.SQLWrapper, "ID", SingleJoinType.One, "SQL Wrapper", "Custom Lookup Queries", DeleteWithRelationship = true, PartOfParentSet = false, LinkToItemInSet = true, InheritPermissions = false)]
Guid SQLWrapperID { get; set; }

Property Value

Type	Description
Guid

UseOnlyForParameters

Indicates this doesn't override view controls by default but instead is used in parameter popups such as queries.

Declaration

[EntityProperty(SQLType.Bit, false, "0")]
[EntityDescription("Indicates this doesn't override view controls by default but instead is used in parameter popups such as queries.")]
bool UseOnlyForParameters { get; set; }

Property Value

Type	Description
bool

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)