AutoTransaction.FilterByContext

Returns the Auto Transactions having keys matching the key(s) of the data source input row currently used as context.

Note that the returned set includes rows matching by "*" / "All level" as well as items having fully qualified matches.

Pseudo

The following example shows what will be returned from the "MySet" Auto Transaction table given the context {X,Y}.

Dimension X

All  
|-- A  
|---- A.1  
|-- B  
|---- B.1  

Dimension Y

All  
|-- T  
|---- T.1  

MySet (Auto Transactions)

X	Y	Value
*	*	100
A	T	200
A.1	T.1	300
B	T.1	400

input = { X = "A", Y = "T" }
MySet.UseContext(input);
...
...
MySet.FilterByContext() will return one match: (A, T, 200)
MySet.FilterByContext(true) will return two matches: [(A, T, 200), (* , *, 100)]

**************************************************************************************************

input = { X = "A.1", Y = "T.1" }
MySet.UseContext(input);
...
...
MySet.FilterByContext() will return two matches: [(A.1, T.1, 300), (A, T, 200)]
MySet.FilterByContext(true) will return three matches: [(A.1, T.1, 300), (A, T, 200), (*, *, 100)]

Example

This example shows how to create one output transaction pr employee benefit for the given context, not including fallback values.

// Returns which employee benefits to generate for the given context.
foreach(var autoTrans in this.AutoTransactions.EmployeeBenefits.FilterByContext())
{
    this.Output.Add(AccountID: autoTrans.TargetAccountID, Amount: amount * autoTrans.Factor);
}

Example

This example shows how to create one output transaction pr employee benefit for the given context, including fallback values.

// Returns which employee benefits to generate for the given context, including the fallback row if present.
foreach(var autoTrans in this.AutoTransactions.EmployeeBenefits.FilterByContext(true))
{
    this.Output.Add(AccountID: autoTrans.TargetAccountID, Amount: amount * autoTrans.Factor);
}

Continue reading

To understand more about how the FilterByContext API works, read about:
Set lookups