Missing Drug Warnings

[nclopezo]

Message from Fiona:

I’ve spotted that some of the drug_warning rows are missing from the web interface that should be there based on the data in the database (see screenshot). Please could you add this to your list of things to do?

e.g. https://www.ebi.ac.uk/chembl/compound_report_card/CHEMBL157101/ should have 4 rows (not three) because there are two efo_ids assigned to the Withdrawn status - for hepatotoxicity and drug-induced liver injury. e.g. Compare the ChEMBL compound report card for drug warnings (only has hepatotoxicity) to that on Open Targets for Drug Warnings (https://platform.opentargets.org/drug/CHEMBL157101) which has both.

[nclopezo]

@juanfmx2, @FionaEBI. The query used is:

GET chembl_drug_warning_by_parent/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "terms": {
            "drug_warning._metadata.all_molecule_chembl_ids": [
              "CHEMBL157101"
            ]
          }
        }
      ]
    }
  }
}

And for some reason it only returns 3 items.

https://wwwdev.ebi.ac.uk/chembl/elk/es/chembl_drug_warning_by_parent/_search?q=drug_warning._metadata.all_molecule_chembl_ids:CHEMBL157101

I think the missing warnings must from from the indexation process.

[nclopezo]

This should be fixed now.