Search data in literally million different ways - long

  • Episodes4
  • Duration10m 31s
  • LanguagesEN
Episode 1

Introduction to Filters

Quick introduction to the module key capabilities

Filters is one of the "Common Features" - these are the set of features that apply to any module in eramba and are used exactly the same way. They sit on the top of every module: Actions, Filters, Notifications, Reports, Etc.

Filters is in fact, the most important because is the way you make questions to eramba. What Risks expire next week? What policies I use in PCI? What evidence I'm missing? Etc, Etc, Etc. You have literally millions of combinations.

Every module and every tab inside any module has filters, without filters we could not display data to you when you load a module. Filters can be saved with any name and condition you want. By default when you load any module in eramba you will be shown at least one filter: "All Items" (a filter that has no confitions, the idea is to show you all there is on that module).

That is because eramba ships with a set of "built in" filters by default (so you can see something when you start using the system). The name of the filter, its conditions and the number of results will always be shown to you (see screenshot above).

You can make your own filters and you can modify existing filters (saved ones), either way you will end up using the Filter configuration tool that looks a bit like this:

The filter configuration tool allows you to search across multiple modules (that is why you can ask, while at the Policy Module, what policies are used in PCI-DSS), you can choose which columns to display on the output table and when a cell has many items you can choose to show their names or a counter.

When you show the filter query result you will see that the filter has been modified (but not saved - this is why it says is temporal), the conditions applied (in this case, all internal controls used in PCI-DSS that have missing testing), the sorting applied and the number of results (8) that matched this condition.

Once saved, can be sent over email to you as a notification, for example: "Send me every 10 days the list of Risks which are High and have non-tested controls as mitigation". Once you create your filter simply attach it to a "Report" notification.

Saved filters are also used on reports, you can add your "Top ten risks" list to a report on the Risk module by creating a filter "give me all risks, ordered by score, limit 10" and then use the "Filter" widget on the report to include it.

Once you create a filter you can also track, day by day, the number of results it generated and the actual results (full table). This is useful if you want to answer questions such as "What Policies were expired on the 5th of March" or if you want to build a trend chart with the number of Risks that are categorized as High. The data will be stored in CSV format and available to you anytime.