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:

inspectomop.results.Results

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;