Difference between revisions of "Data Browser Queries"

From Fusion Registry Wiki
Jump to navigation Jump to search
(Public (Save to server))
 
(5 intermediate revisions by the same user not shown)
Line 3: Line 3:
 
[[Category:FDB Functions]]
 
[[Category:FDB Functions]]
 
__NOTOC__
 
__NOTOC__
 
 
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 [https://demo11.metadatatechnology.com/FusionDataBrowser/# |Fusion Data BrowserDemo Site].
 
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 [https://demo11.metadatatechnology.com/FusionDataBrowser/# |Fusion Data BrowserDemo Site].
  
Line 38: Line 37:
 
|}
 
|}
  
=Saving Queries=
+
==Saving Queries==
 
This article concentrates on the function Save.
 
This article concentrates on the function Save.
  
Line 45: Line 44:
 
The save box offers 2 options.
 
The save box offers 2 options.
  
==Private (Local)==
+
===Private (Local)===
 
Select this option if this Query will only be used by you.
 
Select this option if this Query will only be used by you.
  
Line 68: Line 67:
 
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.
 
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)==
+
===Public (Save to server)===
 +
 
 +
Select this option if the Query is to be used by any user. Public queries are ''Pre-Defined Queries''.
 +
 
 +
 
 +
[[File:FDB-Public-Query1png.png|600px]]
 +
 
 +
 
 +
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.
 +
 
 +
 
 +
[[File:FDB-Public-Query2.png|600px]]
 +
 
 +
 
 +
A list of all Categories as defined in every Categorisation Scheme.
 +
 
 +
 
 +
[[File:FDB-Public-Query3.png|600px]]
 +
 
 +
 
 +
Select the Categorisation(s) to use then Save the changes. The Pre-Defined Query will appear on the Datasets list.
 +
 
 +
 
 +
[[File:FDB-Public-Query4.png|600px]]
 +
 
  
Select this option if the Query is to be used by any user.
+
Note, the Categories are also available to view, add or delete via Fusion the Registry Categorisations option. You can read more [[Category_Schemes_and_Categorisations|in this article]].

Latest revision as of 10:35, 14 October 2024


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. Public queries are Pre-Defined Queries.


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.