Class DatasetQueryableItemJoin

Inheritance
object
BaseEntity
DatasetQueryableItemJoin
Implements
Inherited Members
Namespace: LemonEdge.API.Entities.Reporting
Assembly: LemonEdge.API.Entities.Auto.dll
Syntax
[DataContract]
public class DatasetQueryableItemJoin : BaseEntity, IDatasetQueryableItemJoin, IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackProperties, ICloneableAsync<IDatasetQueryableItemJoin>

Constructors

DatasetQueryableItemJoin()

Declaration
public DatasetQueryableItemJoin()

Properties

DatasetID

Links to IDataset. The parent dataset this join is a member of

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

DatasetID_Label

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

DatasetID_Label_Silent

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

HardcodedValue

Holds a hardcoded value to use for the join value

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

IsNullSourceDatasetQueryableItemID

Links to IDatasetQueryableItem. The source queryable item this is a join from if the initial source has a null value. This can be null if joining to dataset global parameters

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

IsNullSourceDatasetQueryableItemID_Label

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

IsNullSourceDatasetQueryableItemID_Label_Silent

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

IsNullSourceFieldComboItems

Declaration
[NotMapped]
public KeyValuePair<string, string>[] IsNullSourceFieldComboItems { get; set; }
Property Value
Type Description
KeyValuePair<string, string>[]

IsNullSourceQueryableItemFieldUniqueKey

A property within the selected Source Dataset Queryable Item that you want to use to join to the selected Queryable Item that is used if the initial source has a null value

If the Source is global parameters it will allow a selection from all your parameters.If the source is another queryable item it will provide a list of all fields that queryable item contains.

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

SourceDatasetQueryableItemID

Links to IDatasetQueryableItem. The source queryable item this is a join from. This can be null if joining to dataset global parameters

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

SourceDatasetQueryableItemID_Label

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

SourceDatasetQueryableItemID_Label_Silent

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

SourceFieldComboItems

Declaration
[NotMapped]
public KeyValuePair<string, string>[] SourceFieldComboItems { get; set; }
Property Value
Type Description
KeyValuePair<string, string>[]

SourceQueryableItemFieldUniqueKey

A property within the selected Source Dataset Queryable Item that you want to use to join to the selected Queryable Item.

If the Source is global parameters it will allow a selection from all your parameters.If the source is another queryable item it will provide a list of all fields that queryable item contains.

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

TargetDatasetQueryableItemID

Links to IDatasetQueryableItem. The parent queryable item this join is a target to

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

TargetDatasetQueryableItemID_Label

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

TargetDatasetQueryableItemID_Label_Silent

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

TargetQueryableItemFieldUniqueKey

This is the property on the selected queryable item that you want to use to join to the source queryable item.

This will list all fields against this queryable item, and if it has parameters(is a query queryable item) those will also be listed allowing you to pass values into the parameters as part of the join.Doing so will force the join to be an outer apply join.

Declaration
[Required]
public string TargetQueryableItemFieldUniqueKey { get; set; }
Property Value
Type Description
string

Methods

CopyFromEntity(IBaseEntity)

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

CopyFromSource(IDatasetQueryableItemJoin)

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

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

The source object to copy all values from.

OnIsNullSourceFieldComboItemsChanged()

Declaration
public void OnIsNullSourceFieldComboItemsChanged()

OnSourceFieldComboItemsChanged()

Declaration
public void OnSourceFieldComboItemsChanged()

SetIsNullSourceFieldComboItems(Func<DatasetQueryableItemJoin, KeyValuePair<string, string>[]>)

Declaration
public void SetIsNullSourceFieldComboItems(Func<DatasetQueryableItemJoin, KeyValuePair<string, string>[]> comboItems)
Parameters
Type Name Description
Func<DatasetQueryableItemJoin, KeyValuePair<string, string>[]> comboItems

SetSourceFieldComboItems(Func<DatasetQueryableItemJoin, KeyValuePair<string, string>[]>)

Declaration
public void SetSourceFieldComboItems(Func<DatasetQueryableItemJoin, KeyValuePair<string, string>[]> comboItems)
Parameters
Type Name Description
Func<DatasetQueryableItemJoin, KeyValuePair<string, string>[]> comboItems

Implements

Extension Methods