UC1-CQ7: Which manufactured items contain substance <x> as an ingredient of type "active"?

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