Skip to content
Symbiant System Black Logo
  • Home
  • Knowledge Base
  • Symbiant Website
  • Symbiant Changelog
  • Submit a Ticket
  • My Support Tickets
  • Home
  • Knowledge Base
  • Symbiant Website
  • Symbiant Changelog
  • Submit a Ticket
  • My Support Tickets
Popular Keywords importuserdivisionsamlimport risk

Admin Basics

  • Sharing Dashboard Layouts with Other Users
  • Setup Mode/Admin Menu
  • Creating/Adding Users
  • Transferring Ownership from One User to Another (Assuming)
  • Making a User Active/Inactive
  • Delete a User
  • Changing a Record Reference
  • Managing Drop-Downs, Multi-Selects, and Multi-Levels
  • Resetting a User’s Password
  • Checking System Attachment Storage
  • Database History & Restoring Historical Records
  • Restoring a Deleted Record (Archived)
  • Audit Trails
  • Email Log Viewer
  • System Menu Layout & Options

System Translations

  • Adding a Translation Pack
  • Editing a Translation Pack
  • Mass Editing a Newly Created Translation Pack
  • Assigning a Translation Pack to a User
  • Exporting a Translation Pack
  • Importing a Translation Pack
  • Adding a Default Translation Pack
  • Creating a Locale Specific View (Translated View)
  • Editing a Locale Specific View (Translated View)

Importing Data

  • Preparing Data for Import (Default)
  • Imports with Hierarchical Data
  • Importing Data (Generic)
  • Preparing Data for Import (Risks)
  • Importing Data (Risk Register Specific)
  • Preparing Data for Import (Users)
  • Importing Users
  • Importing Divisions
  • Importing Errors & Issues

Automated Emails (Task Based)

  • How Automated Emails Work (Triggers and Schedules)
  • Activating and Deactivating an Automated Email (Trigger) and (Scheduler)
  • Creating an Automated Email – When a Record is Created (Trigger)
  • Creating an Automated Email – When a Record is Updated (Trigger)
  • Creating an Automated Email – When a Record is Deleted (Trigger)
  • How to Receive Module Specific Emails as System Admin (Trigger) and (Scheduler)
  • Editing an Automated Email – Sending to a Different Module Role (E.g. Risk Manager) (Trigger)
  • Editing an Automated Email – Sending to a Record User (Trigger)

Automated Email Reminders (Time Based)

  • How Automated Emails Work (Triggers and Schedules)
  • Activating and Deactivating an Automated Email (Trigger) and (Scheduler)
  • Creating an Automated Email Reminder – When a Record is Due (Scheduler)
  • Creating an Automated Email Reminder – When a Record is Overdue (Scheduler)
  • Setting up Recurring Schedules
  • How to Receive Module Specific Emails as System Admin (Trigger) and (Scheduler)
  • Editing an Automated Email Reminder – Sending to a Different Module Role (E.g. Risk Manager) (Scheduler)
  • Editing an Automated Email Reminder – Sending to a Record User (Scheduler)

System Views

  • Editing a Dashboard Chart
  • Sharing Dashboard Layouts with Other Users
  • System Views (Quick Explainer)
  • Creating Your Own Custom Views
  • View Editor Tool Overview
  • Editing a View
  • How to Hide/Unhide Fields
  • Loading/Saving a Particular User’s View
  • What are Widgets?
  • Adding, Removing and Editing a Grid Column
  • Adding Help Tips & Placeholder text
  • Modifying a User Field to Limit or Allow Specific Users
  • Modifying a Currency Field to Set Default

Exporting Data

  • Exporting Dashboard Data
  • Exporting Divisions
  • Exporting Users
  • Generating the System User Details Report

System Errors & Issues

  • Resolving System Issues
  • System Error Messages
  • Login Issues

Reporting Suite Tutorial

  • Creating a Word Report (Basic Data Output)
  • Creating an Excel Report (Basic Data Output)
  • Creating a PowerPoint Report (Basic Data Output)
  • Creating an Excel Tabular Report (Perfect for CSV)
  • Creating an Excel Audit Report (Audit Log Of Changes)
  • Adding a new column to an Excel Report
  • Removing a column in an Excel Report
  • Creating an Advanced Word Report (Adding Functions)
  • Advanced Report Coding (Using Owners, Divisions & Assignees in a Report)
  • Advanced Report Syntax
  • Advanced Filtering on Reports (Filtering Via Code)
  • Reporting Permissions

Advanced System Functionality

  • Symbiant API

Document Management (System Setup)

  • Setting Up Document Types
  • Setting Up Document Statuses
  • Document Storage Limits and File Sizes
View Categories
  • Home
  • Knowledge Base
  • Admin Information
  • Reporting Suite Tutorial
  • Advanced Filtering on Reports (Filtering Via Code)

Advanced Filtering on Reports (Filtering Via Code)

0:00 / 2:06
  • View as Markdown Open this page as plain Markdown (opens in a new tab)
  • Open in ChatGPT Ask questions about this page (opens in a new tab)
  • Open in Claude Ask questions about this page (opens in a new tab)
  • Open in Google AI Studio Ask questions about this page (Google account required) (opens in a new tab)
AI Doc Summarizer Doc Summary
AI Doc Summarizer Thinking Thinking

This article shows you the ways to limit which records go into a report: the Filter on the Reports page, and data source filters set up by an administrator.

Applies to: Anyone who can generate the report (Filter), and system administrators (admin role) for data source filters.

Filtering When You Generate #

  1. Click Reports at the bottom of the menu on the left.

    Reports in the main menu

  2. Find the report and click Filter.

    Filter next to Generate

  3. Click AND and pick the field to filter on, for example Level, then set the condition and value. Add more conditions with AND or OR. This works like the record filters elsewhere in Symbiant.

    Choosing a field to filter on

  4. Database is normally Current.
  5. Click Close, then Generate. Only matching records go into the report.

Filters Built Into the Report (Administrators) #

To make a report always filter its data, an administrator can add a filter to the data source in Set up > Reports.

Make Sure the Fields Are Ticked #

A filter can only use fields the data source pulls. Open the data source with Graph… and tick every field you want to filter on, as here for Level and its text. For scores, tick the whole score set you’re filtering, for example the residual score with its impact, likelihood and score values.

Ticking fields in the graph

Data Source Functions #

Click Functions next to the data source. Where Filter, Attribute Filter and Time Filter limit the data; tick one and click its Configure….

The Functions list

Data Source Filter Template #

Tick Data source filter template to open a box where the filter is written as code, using the same markers as the template. The code compares a value from the data source with what you want, for example only risks whose residual score (risk.residual/score and its product) is 8 or more.

The data source filter template box

The code starts with the data source name followed by square brackets. For example, the shipped Risks By Register (Overview) report has data[$ << :generic.sort/index] in its filter template.

Note: The filter code must match your data source exactly. If you’d like a coded filter written or checked, contact Symbiant Support with the report name and the rule you need.

Click Save at the top right when you’re done, then generate the report to check the results.

Related articles #

  • Advanced Report Syntax
  • Reporting Permissions
Excel, Reports, Spreadsheets, Updating, Word
Did this help?

Share This Article :

  • Facebook
  • X
  • LinkedIn
Require Additional Information? Please Contact Support

How can we help?

Updated on 30 October 2026
Advanced Report SyntaxReporting Permissions
Table of Contents
  • Filtering When You Generate
  • Filters Built Into the Report (Administrators)
    • Make Sure the Fields Are Ticked
    • Data Source Functions
    • Data Source Filter Template
  • Related articles
Symbiant System White Logo

20-22 Wenlock Road

London

N1 7GU

Linkedin
Telephone Numbers
  • UK - 0113 5263 755
  • Support - 0204 5514 735 option 2
  • USA - 347 991 7130
Information
  • Home
  • Knowledge Base
  • Symbiant Website
  • Submit A Ticket
  • Change Requests
  • Support Staff Login

Copyright © 2025 Symbiant All Rights Reserved - Risk, Audit and Compliance Management Software

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept All”, you consent to the use of ALL the cookies. However, you may visit "Cookie Settings" to provide a controlled consent.
Cookie SettingsAccept All
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
SAVE & ACCEPT
Loading...

Insert/edit link

Enter the destination URL

Or link to existing content

    No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.