Training

Applying Filters

The below tutorial will cover how to apply filters to your source data.

Your Source Data can be filtered via the Filter Box, this is a Client Side filter and is suitable for quick filters where your source data is small.

Filter Box

This filter box takes a C# code expression to filter your source data (DataSource A). You can also use the calculated column functions to filter your source data. The expression must return True to include the row in the results otherwise return False to exclude it.

This function you enter into the filter box is written to the Dynamic Columns under the BeginRow() method. Therefore your Filter Expression could be written in Dynamic Columns like these below:

public override bool BeginRow()
{
    return true; // return false to skip row from results
}

or filtering for NOT NULL would be like this:

public override bool BeginRow()
{
    return Value != null;
}

Examples

Below you will find some use examples of code you can use within the filter box:

Show customers based in Kent:

To show all customers based in a specific county (in this example Kent) you can either use C# code:

county=="Kent"

or a calculated column expression:

EQUALS(county,"Kent")

Show customers not based in Kent:

To show all customers that are not based in a specific county (in this example Kent) you can either use C# code:

county!="Kent"

or a calculated column expression:

NOT(EQUALS(county,"Kent"))

Show all customers with an order number greater than or equal to 10:

OrderNo>=10

Remove all customers based in the United Kingdom:

To remove all customers based with the UK, you can either use C# code:

country!="United Kingdom"

or a calculated column expression:

NOT(EQUALS(country,"United Kingdom"))