UC1-CQ6: Which investigational/authorized medicinal products contain the substance X or its active moiety Y or any other substance related to active moiety Y?
Business' relevance
This competency question links what is applied in a clinical trial (investigational/authorized medicinal products) with a certain substance, it's active moiety, or any other substance related to the active moiety. An investigational medicinal product is defined as a pharmaceutical product or combination of pharmaceutical products or placebo(s) being tested or used as a reference in a clinical trial, including products already with a marketing authorization but used or assembled (packaged) in a way different from the authorized form, used for an unauthorized indication, or used to gain further information about the authorized form, whereas an authorized medicinal product is defined as a medicinal product that has been authorized for some purpose in some jurisdiction. Being able to link all these information together will prove beneficial in getting a clear overview and better understanding of the effects of a medicinal product.
Diagram for Query Pattern
Diagram 1: Query pattern diagram for SPARQL Query
Test Data
Amlodipine example: https://github.com/edmcouncil/idmp/blob/master/EXT/Examples/AmlodipineExample.rdf
Query
https://github.com/edmcouncil/idmp/blob/master/etc/CQ/Example/uc1_cq6.sparql
Expected Query Results for Example Data