Build your widget's source query

[ 1 Using the query editor ] [ 2 Using the Data menu ] [ 3 Special syntax ]

Once you have added the widget, you can edit its query to display data accordingly. Remember that to edit the data of an Activeboard you must first activate the editing mode.

Using the query editor

Query editor interactive features

The free text query editor in Activeboards uses the standard LINQ query language used for searching data in Devo. However, there are some differences you need to take into account. Visit the following article to know about them: LINQ syntax differences: Activeboards vs search window.

The query editor provides the following interactive features:

Auto-complete: as you type your query, the editor will suggest LINQ syntax to auto-complete the word.
Show errors: the editor will automatically show LINQ errors.
Find and replace: you can use the find and replace shortcut CTRL + F to find a keyword and replace it.
Line shifting: you can move one or multiple lines up and down by holding down the ALT key and using the keyboard arrows to choose the position.
Multibeam: write in several places at one time using the multibeam feature ( CTRL + SHIFT + arrow)
Command Palette: right-click anywhere on the query editor and select Command Palette (or press F1) to access the available commands and their equivalent keyboard shortcuts.

Multi-tabs: you can now add multiple tabs to open the configuration of different widgets.

Global variables: you can use predefined variables as placeholders for specific values in your query. These global variables will be translated into actual values about you and your current session. This is useful to monitor your own interaction when you use filter operations in widgets or create options for inputs. This is the list of available global variables:

1	$DOMAIN_NAME	The name given to the domain you are currently logged in.
2	$DOMAIN_ID	The ID internally assigned to the domain you are currently logged in.
3	$USER_NAME	Your name as stated in your account details.
4	$USER_EMAIL	The email registered to create your account and used as identity token to log in.
5	$USER_ID	The ID internally assigned to your account when created.
6	$ACTIVEBOOARD_NAME	The name given to the Activeboard you are currently working with.
7	$ACTIVEBOOARD_ID	The ID internally assigned to the Activeboard you are currently working with.
8	$LOCALE	Your language as specified in your User preferences.
9	$TIMEZONE	Your region as specified for your account in the Navigation pane.
10	$ISOLATED	Boolean value indicating your machine status concerning isolation.

Using the Data menu

Click the Data button at the top of the Activeboard. You can choose from several methods of identifying the data source for your widget:

Free text query	Select this option if you prefer to enter the query script manually. Enter the LINQ query script in the text box, then click the Drag this query to the workspace button and drag it to the new widget on the Activeboard, or to the blank canvas to create a new widget (if you do this, the new widget will be a Table widget).
My last search queries	Select from a list of queries you have recently run in the domain and drag it to the widget on the Activeboard. Learn more about recent queries here.
My favorite search queries	Select from a list of the queries that you have marked as favorites and drag it to the widget on the Activeboard. Learn more about favorite queries here.

Special syntax

There are some operations that need special attention when constructing their syntax. Visit the following articles to know more about them: