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?

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