inspectomop.queries.general.synonyms_for_concept_ids

inspectomop.queries.general.synonyms_for_concept_ids(concept_ids, inspector, return_columns=None)

Returns concept information for a list of concept_ids

Parameters:

• concept_ids (list of int)

• inspector (inspectomop.inspector.Inspector)

• return_columns (list of str, optional) –

  • optional subset of columns to return from the query

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

Returns:

results

Return type:

sqlalchemy.sql.expression.Executable

Notes

Original SQL

G04: Find synonyms for a given concept ID:

SELECT
    C.concept_id,
    S.concept_synonym_name
FROM
    concept C,
    concept_synonym S,
    vocabulary V
WHERE
    C.concept_id = 192671 AND
    C.concept_id = S.concept_id AND
    C.vocabulary_id = V.vocabulary_id AND
    sysdate BETWEEN C.valid_start_date AND C.valid_end_date;