UC1-CQ7: Which manufactured items contain substance <x> as an ingredient of type "active"?
Business' relevance
This competency question links a manufactured item with the substance that is the active ingredient in the manufactured item. A manufactured item is defined as a good that embodies the qualitative and quantitative composition of a product as contained in the packaging of the medicinal product. As already mentioned in CQ1, different substances can have different functions in a medicinal product. The substance which is the active ingredient is the substance that is responsible for pharmacological activity. Linking manufactured items to their active ingredients will be useful for a better understanding of the portfolio of manufactured items and the related active ingredients, and perhaps provide insights for increasing efficiency and quality of manufacturing and/or product development processes.
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
Terlipressin Example: https://github.com/edmcouncil/idmp/blob/master/EXT/Examples/TerlipressinExample.rdf
Query
https://github.com/edmcouncil/idmp/blob/master/etc/CQ/Example/uc1_cq7.sparql
Expected Query Result for Amlodipine Example Data
Expected Query Result for Terlipressin Example Data