Create, share, and manage your DataGrid filters

Open the DataGrid that you would like to add a new filter to

Select the ‘Filters’ button and then click on the ‘+ Create New’ option from the top right of your DataGrid

Open

Consider how want to filter your DataGrid to limit the results that are shown to you, and what settings may be required for this

Use the filter options to define the conditions of your new Filter, please see lower down in this page for some common DataGrid Filter conditons and how to set these up

If you would like all of the conditions (each row of your filter) to be met for a result to appear in your DataGrid, leave the ‘All’ option set in the toggle 'Where the results meet all/any of the conditions

If you would like any of the conditions (any row of your filter) to be met for a result to appear in your DataGrid, click the ‘All’ to change it to ‘Any’ in the toggle 'Where the results meet all/any of the conditions.

For example if you have multiple settings such as Venue and Trainer:

• When applying to a filter with an ‘Any’ option set, Courses will show if they do not have a Venue OR they do not have a Trainer.

• When applying to a filter with an ‘All’ option set, Courses will show if they do not have a Venue AND they do not have a Trainer.

   

Click the ‘Preview’ button to check that your filter works as you expect! 

If you would like to save your filter for future use, provide your filter with a name and click on the 'Save' button

If you have saved your DataGrid Filter, it will have been added to your filters bar which you can toggle on/off by clicking on it.
Filter on (blue):

Filter off (grey):

Your filter will now be available for you to use, each time you open this DataGrid

Open the DataGrid that has a Filter that you’d like to share with another Administrator

Select the ‘Filters' button and then click on the ‘Share Filters’ option from the top right of your DataGrid

This will open the ‘Share Filters’ pop up box

Select which filter(s) you wish to share, by checking the checkboxes next to each filter to select them from the ‘Select the filters you would like to copy’

Select which administrators you wish to share the filters with by clicking the ‘Select’ button

This will open a pop up box with a list of Administrators that can be selected

Click the ‘Copy’ button to share your selected Filters with your selected Admins

Open the DataGrid that has a Filter that you’d like to rename

Find the Filter you wish to rename from your DataGrid

If the filter isn’t already in your Filters Bar, select the ‘Filters’ button and click on the filter listed under the ‘Search for filters' bar

Once your Filter is included in the filters bar, double-click on the filter, this will open the filter to expose the filter’s settings and you will see the filter goes yellow

At the bottom of the settings, you can edit the name of the filter

Once you have renamed your Filter, click ‘Save’ to apply your changes

Your changes will be saved straight away, and will stay in place the next time you open this DataGrid

Open the DataGrid that has a Filter that you’d like to rename

Find the Filter you wish to rename from your DataGrid

If the Filter isn’t already in your Filters Bar, select the ‘Filters’ button and click on the filter listed under the ‘Search for filters' bar

Once your Filter is included in the filters bar, double-click on the filter, this will open the filter to expose the filter’s settings and you will see the filter goes yellow

Here you can change the settings;

1. Add additional Filter conditions (additional rows)

2. Remove Filter conditions

3. Update Filter conditions (i.e. update a date range, change the selected status)

4. Update the All/Any setting

    

Once you have made your amendments, click ‘Save’ to apply your changes

Your changes will be saved straight away, and will stay in place the next time you open this DataGrid

Open the DataGrid that has a Filter that you’d like to hide

Find the Filter you wish to remove from your DataGrid

Click the little 'x' next to the Filter label to remove it from your Filters bar, and move it into your More Filters list (available from the Filters drop-down)

If you need to add a Filter back into your Filters bar, you will find the filter listed under the ‘Filters’ button in the top right of your DataGrid, the filter will be listed under the ‘Search for filters' bar, if you click on the label of the filter this will add it back to your filters bar

Your change will be saved straight away, and will stay in place the next time you open this DataGrid