Design / Prototype subjects aggregations

[alejandromumo]

The goal of this task is to outline how we plan to add aggregations for communities.

Notes:

• We need to decide where should the metadata be the record level, to be able to aggregate. E.g.

  GET /zenodo-prod-rdmrecords-records/_search
  {
  "query": {
    "term": {
      "parent.communities.entries.slug": {
        "value": "eu"
      }
    }
  }, 
  "aggs": {
    "program": {
      "terms": {
        "field": "metadata.funding.award.program",
        "size": 10
      }
    }
  },
  "size": 0
  }

  GET /rdmrecords-record-v7.0.0
  {
  "aggregations": {
    "subjects": {
      "terms": {
        // from the community subjects...
        "field": "parent.communities.entries.custom_fields.subjects",
        // ...or from the community funding metadata...
        "field": "parent.communities.entries.metadata.funding.award.subjects",
  
        // ...or from the record metadata
        "field": "metadata.subjects",
        // ...or from the record award metadata
        "field": "metadata.funding.award.subjects",
      }
    }
  }
  }

• Note: we can aggregate by grant information, e.g. if grants have the subjects information in them
• Take into account how these can be configured / extended by an instance

Deliverables

• Prototype of how these aggregations can be implemented in RDM

[alejandromumo]

Next steps:

1. Ask Pablo about subjects information in grants
   • If we have the information, we need to update the awards vocabulary
   • Otherwise, we take it from the parent community subjects information
     • https://codimd.web.cern.ch/dAJdq9rPSIGhq9k8hNEREw
2. TBD