Build your widget's source query
- Juan Tomás Alonso Nieto (Deactivated)
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 switch to Edit mode and have the relevant permissions.
Using the query editor
Free text query editor 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:
As you type your query, the editor will suggest LINQ syntax to auto-complete the word.
The editor will automatically show LINQ errors.
You can use the find and replace shortcut CTRL + F to find a keyword and replace it.
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.
Write in several places at one time using the multibeam feature ( CTRL + SHIFT + arrow)
Right-click anywhere on the query editor and select Command Palette (or press F1) to access the available commands and their equivalent keyboard shortcuts.
You can now add multiple tabs to open the configuration of different widgets.
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: