Filters

To filter your data in an easy and powerful way, we designed our own query language: BluInsights Query Language (BQL).

 

How to use it?

Just type your BQL query in the filter field displayed on top of almost every page.

Filter

 

Constructing BQL queries

This section describes information about fields that are used for searching. A field in BQL is a word that represents a BluInsights element. In a statement, a field is followed by an operator, which in turn is followed by one value. The operator compares the value of the field with the value on the right, such that only true results are retrieved by the statement. 

Types

Type
Supported operators
Value types
Examples
string
=, !=, like, not like
String with single or double quotes
name = 'file.ext'
name like 'file.*'
in, not in
Array of strings with double or single quotes
workpackage in ['Workpackage1', 'Workpackage2']
number
=, !=, <, >, <=, >=, between ... and ...
numbers
effective lines > 5
effective lines between 10 and 15
date
​=, !=, <, >, <=, >=, between ... and ...​
date formatted like YYYY-MM-DD or YYYY/MM/DD
start date > 2021/02/10

 

Fields

Field
Description
Type
Applied to
name
 
string
Assets
To-Dos
Management
title
 
string
To-Dos
description
 
string
To-Dos
file type
 
​string​
Assets
Management
assigned to
 
​string​
Assets
​To-Dos​
Management
status
 
​string​
Assets
To-Dos
Management
path
 
​string​
Assets
Management
effective lines
 
​number​
Assets
Management
comment lines
 
​number​
Assets
Management
empty lines
 
​number​
Assets
Management
start date
 
date
Assets
​To-Dos​
Management
end date
 
date
Assets
To-Dos
Management
workpackage
 
​string​
Assets
To-Dos
Management
label
 
​string​
Assets
To-Dos
Management
board
 
​string​
To-Dos
Management
number of workpackages
 
​number​
Assets
To-Dos
Management
number of labels
 
​number​
Assets
To-Dos
Management
number of issues
 
​number​
Management > Test Scenarios
number of CI/CD jobs
 
​number​
​Management > Test Scenarios​
number of comments
 
​number​
Assets
Management
cyclomatic complexity
 
​number​
Assets
Management
indegree
Number of ingoing edges (parents)
​number​
Assets > Dependencies
outdegree
Number of outgoing edges (children)
​number​
​Assets > Dependencies​

 

Logical operators

To build even more complex filters, you can use logical operators “and” and “or”. You can also use parentheses to group your conditions. Thus, you can build powerful filters such as:

(name like '\\.CBL' and workpackage in ['WP1', 'WP2']) or start date between 2021/04/10 and 2021/04/25

 

Running a saved search

Saved searches are shown on the left side of the advanced search input. Click on the “filter” button on the left side of the search input to display it.

Filters - List of saved searchs

To run a filter, e.g. Epics, simply click it. The BQL for the search will be set, and the search results will be displayed.Filters - Running a saved search