Difference between revisions of "Data Browser Queries"

From Fusion Registry Wiki
Jump to navigation Jump to search
(→‎Public (Save to server))
 
(20 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].
  
−
Coming soon
+
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.
  
−
'''PDQ'''
+
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 [[/A_beginners_guide_to_Fusion_Data_Browser#Manage_Dataflows|Managing Dataflows in this article]].
−
Pre-Defined Queries are saved via the Save button and you use the option Public Query.
 
−
They do not appear on the saved queries list, instead they appear as a Categorisation under that Dataset lest. I think you must give the Public query a categorisation for it to show up but Im not sure.
 
−
You have to be logged in to see PFQs on the Manage list.
 
  
−
If you are logged out the PDQ is still om the Dataset list but you cant manage it.
+
To build the simple query, I have selected Aruba from the Country filter.
  
−
'''Local query'''
 
−
Appears under Saved Query list
 
−
Can be managed from the Manage Queries option (logged in or logged out).
 
−
Notes: logged in you see all queries, local and system via the Manage
 
−
Logged out you can see only Local queries.
 
  
 +
[[File:FDB-Aruba-query.png|800px]]
  
−
Manage Pre-defined query is Public Queries only and you must be logged in.
+
The following functions are useful when building a query.
  
−
 
+
==Functions available ==
−
RFS-1048
 
−
 
 
−
===Functions available ===
 
  
 
{| class="wikitable"
 
{| class="wikitable"
Line 31: Line 21:
 
|-
 
|-
 
| Home || [[File:FDB-Home.png|60px]] || This will return you to the Home page.
 
| Home || [[File:FDB-Home.png|60px]] || This will return you to the Home page.
−
|-
 
−
| Dataset Name || [[File:FDB DS Name.png|60px]] || Return to the Series List.
 
 
|-
 
|-
 
| Share || [[File:FDB Share.png|50px]]||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 [[Data_Browser_Share_URL | Share URL]] in this article.
 
| Share || [[File:FDB Share.png|50px]]||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 [[Data_Browser_Share_URL | Share URL]] in this article.
 
|-
 
|-
−
| Save || [[File:FDB Save.png|50px]]|| This enables you to save a Query. You can learn more about Saving Queries [[Data_Browser_Queries | Data Browser Queries]] in this article.
+
| Save || [[File:FDB Save.png|50px]]|| This enables you to save a Query.  
 
|-
 
|-
 
| Series Basket|| [[File:FDB Series Basket.png|50px]]|| This enables you to save a selection of series to a new or existing basket. You can learn more about Series Baskets [[Series_Basket | in this article]].  
 
| Series Basket|| [[File:FDB Series Basket.png|50px]]|| This enables you to save a selection of series to a new or existing basket. You can learn more about Series Baskets [[Series_Basket | in this article]].  
Line 42: 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 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]].
+
| 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]].
 
|}
 
|}
 +
 +
==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.
 +
 +
 +
[[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 03: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.

Retrieved from "https://wiki.sdmxcloud.org/index.php?title=Data_Browser_Queries&oldid=7488"