Data Browser Queries

From Fusion Registry Wiki
Revision as of 10:23, 14 October 2024 by Vmurrell (talk | contribs) (Public (Save to server))
Jump to navigation Jump to search


Data Browser queries are performed via the Series List. In order to open the Series List you must first select a Dataset. In this example, I am using the Dataset Countdown 2030 which is available on the |Fusion Data BrowserDemo Site.

Once a query has been built it can be saved for future use.Once saved it will be accessible via the menu option Saved Datasets and Charts if the query is Private or, provided it has a Linked Category, via the Categorisation area of the Dataset Navigation menu.

The example below shows the Dataset Countdown 2030. The dataflow has been set up to display a number of quick filters. You can learn more about Managing Dataflows in this article.

To build the simple query, I have selected Aruba from the Country filter.


FDB-Aruba-query.png

The following functions are useful when building a query.

Functions available

Function Display Effect
Home FDB-Home.png This will return you to the Home page.
Share FDB Share.png Creates a URL of the Page or the Query. This URL can be opened directly or copied to the clipboard. You can use this feature to send the URL which can be opened by anyone with that URL. The source Registry must be running for an ‘outsider’ to view the query. You can learn more about Sharing URLs Share URL in this article.
Save FDB Save.png This enables you to save a Query.
Series Basket FDB Series Basket.png This enables you to save a selection of series to a new or existing basket. You can learn more about Series Baskets in this article.
Export Data FDB Download.png This enables you to Export the data. You can learn more about the Export options in this article.
Table FDB Table.png This button opens up the Data Browser Table which is explained further in this article.
Time Series FDB Time Series.png This button opens up the Data Browser Time Series Chart which is explained further in this article.

Saving Queries

This article concentrates on the function Save.

To save a query, click the save button.

The save box offers 2 options.

Private (Local)

Select this option if this Query will only be used by you.


FDB-Save-Query2.png


Having chosen Private, the filters used in the query will be displayed (example ABW (Aruba) is the country.Next you can give the query a name.

The query will now appear on the Saved Queries menu as shown below.


FDB-Save-Query3.png


The query will also appear on the Management option, Manage Save queries.


FDB-Save-Query4.png


Saved Private queries can be deleted but they can not be edited. If you wish to Edit a query, create a new one and save it.

Public (Save to server)

Select this option if the Query is to be used by any user.


FDB-Public-Query1png.png


Having chosen Public, the filters used in the query will be displayed (example ABW (Aruba) is the country but as the query is Public, more information is required, Agency ID, Query ID and Locale, a Query Name is also required.

At this stage, the Public query will not appear on the Saved Datasets list or the Dataset Navigation list.

To reuse a public query, the next step is to go to the Management option, Manage Pre-Defined Queries. Select the query and then click Linked Categories.


FDB-Public-Query2.png


A list of all Categories as defined in every Categorisation Scheme.


FDB-Public-Query3.png


Select the Categorisation(s) to use then Save the changes. The Pre-Defined Query will appear on the Datasets list.


FDB-Public-Query4.png


Note, the Categories are also available to view, add or delete via Fusion the Registry Categorisations option. You can read more in this article.