The query below retrieves substances which have the input <SubstanceInputReference> as a name or identifier (case insensitive) using the generic property patterns.

In the example uses "Amlodipine" as a substance reference, but other references such as the following will also match the correct substance:

• "3,5-PYRIDINEDICARBOXYLIC ACID, 2-((2-AMINOETHOXY)METHYL)-4-(2-CHLOROPHENYL)-1,4-DIHYDRO-6-METHYL-, 3-ETHYL 5-METHYL ESTER, (+/-)-"
• "HGP-0904"
• "88150-42-9" (a CAS number)
• “SUB05467MIG” (EV code)

Note: identification based on name and identifier attributes may not be unique in datasets. In some cases, it is sufficient to add the context of the name or identifier but in some cases the referencing identifiers are not unique even within one reference set. E.g., in GSRS the ATC codes are listed under identifiers but the code "C09XA53" is classifying Amlodipine and also Aliskiren.

Model Pattern for Identifiers

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/cq0.sparql

Expected Query Result for Example Data