academic-observatory-workflows
academic-observatory-workflows copied to clipboard
INF-572 : query formatting / linting and minor refactoring
- 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