Difference between revisions of "Data Browser Queries"

From Fusion Registry Wiki
Jump to navigation Jump to search
(Functions available)
(Public (Save to server))
 
(16 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[Category:DataBrowserFunctions]]
 
 
[[Category:Fusion Data Browser]]
 
[[Category:Fusion Data Browser]]
[[Category:FDB Functions]]
+
__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 15: Line 14:
 
The following functions are useful when building a query.
 
The following functions are useful when building a query.
  
 
+
==Functions available ==
===Functions available ===
 
  
 
{| class="wikitable"
 
{| class="wikitable"
Line 32: Line 30:
 
| Export Data|| [[File:FDB Download.png|50px]]|| This enables you to Export the data. You can learn more about the Export options [[Data_Browser_Export|in this article]].
 
| Export Data|| [[File:FDB Download.png|50px]]|| This enables you to Export the data. You can learn more about the Export options [[Data_Browser_Export|in this article]].
 
|-
 
|-
| Series List || [[File:FDB Series List.png|50px]]|| This button is only active if you have moved to the Table or Time series display. If you are using one of these, clicking the Series List button will return you to the list as displayed above. You can learn more about the Export options [[Series_List|in this article]].  
+
| Table|| [[File:FDB Table.png|50px]]|| This button opens up the [[Data_Browser_Table| Data Browser Table which is explained further in this article]].
 
|-
 
|-
| Table|| [[File:FDB Table.png|50px]]|| This button is active from the Series List and opens up the [[Data_Browser_Table| Data Browser Table which is explained further in this article]].
+
| Time Series|| [[File:FDB Time Series.png|50px]]|| This button opens up the [[Data_Browser_Time_Series_Chart| Data Browser Time Series Chart which is explained further in this article]].
|-
 
| Time Series|| [[File:FDB Time Series.png|50px]]|| This button is active from Series List and opens up the [[Data_Browser_Time_Series_Chart| Data Browser Time Series Chart which is explained further in this article]].
 
 
|}
 
|}
  
 +
==Saving Queries==
 
This article concentrates on the function Save.
 
This article concentrates on the function Save.
  
Line 44: Line 41:
  
 
The save box offers 2 options.
 
The save box offers 2 options.
 +
 +
===Private (Local)===
 +
Select this option if this Query will only be used by you.
 +
 +
 +
[[File:FDB-Save-Query2.png|600px]]
 +
 +
 +
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.
 +
 +
 +
[[File:FDB-Save-Query3.png|600px]]
 +
 +
 +
The query will also appear on the Management option, Manage Save queries.
 +
 +
 +
[[File:FDB-Save-Query4.png|600px]]
 +
 +
 +
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''.
 +
 +
 +
[[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]]
 +
 +
 +
Note, that 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 02:27, 30 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, that the Categories are also available to view, add or delete via Fusion the Registry Categorisations option. You can read more in this article.