Search Analytics Management - moritzmars/ScienceDataManagement GitHub Wiki

The search analytics management allows you to analyse executed search queries. You can define new analytics queries, update or delete existings ones. You can easily export the analytiv results.

Define new search anayltic

  1. Click on the button "New Search Analytic". The new search analytiv interface will open. 2015-02-27 11_01_56-mozilla firefox
  2. Please define a new search analytiv:
  • Name: Name of the search analytic.
  • Query: Query of the search analytic. You can query all databases of the application. For more information about the internal structure please hava a look at the ????????????? section.

Example analytic:

SELECT Count(*) As PublishCount, GivenName, SurName FROM sciencedatamanagement.scientific_paper_meta_information as A inner join scientific_paper_meta_information_authors B on A.ID= B.Scientific_Paper_Meta_Information_ID inner join search_definiton_execution C on C.ID= A.Search_Definiton_Execution_ID inner join search_definition_execution_run D on D.ID= C.search_definition_execution_run_ID where C.search_definition_execution_run_ID = %s Group By(SurName) order by PublishCount DESC;

Edit existing search anayltic

  1. Select a search analytic and click on Edit Search Analytic. 2015-02-27 11_14_32-facelet title
  2. The search analytiv informations will be loaded. You can now change the definition. 2015-02-27 11_16_38-mozilla firefox
  • Name: Name of the search analytic.
  • Query: Query of the search analytic. You can query all databases of the application. For more information about the internal structure please hava a look at the ????????????? section.
  1. To save the changes please click on save.

Delete a search analytic.

  1. Please select a already defined search analytic and click afterwards on Delete Search Analytic. The search analytic will now be deleted. Attention: The deletion will immedidately executed without any approval.

Execute search analytic.

  1. Please select a search definition. 2015-02-27 11_21_39-facelet title
  2. Please select a search definition execution. 2015-02-27 11_22_39-facelet title
  3. Please select a search analytic. 2015-02-27 11_23_43-facelet title
  4. After the selection the results of the analytic will be loaded. 2015-02-27 11_25_07-facelet title

Export a search analytic.

  1. Please execute a search analytiv. The analytics result will be loaded.
  2. You can now export by selecting an export modul and click on Export. 2015-02-27 11_26_36-facelet title