inspectomop.queries.drug.ingredient_concept_ids_for_ingredient_names

inspectomop.queries.drug.ingredient_concept_ids_for_ingredient_names(ingredient_names, inspector, return_columns=None)

Get concept_ids for a list of ingredients.

Parameters:

• ingredient_names (list of str)

• inspector (inspectomop.inspector.Inspector)

• return_columns (list of str, optional) –

  • optional subset of columns to return from the query

  • columns : [‘ingredient_name’, ‘concept_id’]

Returns:

results

Return type:

sqlalchemy.sql.expression.Executable

Notes

Original SQL:

SELECT
    concept_id,
    concept_name
FROM
    concept,
WHERE
    vocabulary_id = 'RxNorm'
    AND concept_class_id = 'Ingredient'
    AND lower(concept_name) IN ('ingredient_name_1')