academic-observatory-workflows icon indicating copy to clipboard operation
academic-observatory-workflows copied to clipboard

INF-572 : query formatting / linting and minor refactoring

Open JulianTonti opened this issue 2 years ago • 0 comments

  • export_unique_list - formatting only
  • export_relations - formatting only
  • export_output_types - formatting only
  • export_metrics - formatting only
  • export_events - formatting only
  • export_dois - formatting and one suggestion
  • export_disciplines - formatting only
  • export_access_types - formatting only
  • create_wos - formatting only
  • create_unpaywall -
    • refactored repositories sub-query
    • replaced binary CASEs with IFs
    • replaced other_platform_categories CASE with COUNTIF
  • create_unpaywall_repo_names - switched to IFNULL
  • create_scopus - formatting only
  • create_ror - formatting only
  • create_orcid - formatting only
  • create_openalex - formatting only
  • create_open_citations - fully refactored query
  • create_mag - formatting, switched one IF for IFNULL
  • create_doi -
    • switched IFs for IFNULLs
    • one query on count field
    • added consistent use of CASTs
    • formatting
  • create_crossref_fundref - formatting only
  • create_crossref_events - formatting only
  • create_book - refactored JavaScript UDF and added tests
  • create_aggregate - formatting only
  • comparison_view - formatting only

JulianTonti avatar Nov 30 '22 09:11 JulianTonti