inspectomop.queries.general.concepts_for_concept_ids

inspectomop.queries.general.concepts_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_name’, ‘concept_code’, ‘concept_class_id’, ‘standard_concept’, ‘vocabulary_id’, ‘vocabulary_name’]
Returns:

results
Return type:

inspectomop.results.Results

Notes

Original SQL

G01: Find concept by concept ID:

SELECT
    C.concept_id,
    C.concept_name,
    C.concept_code,
    C.concept_class_id,
    C.standard_concept,
    C.vocabulary_id,
    V.vocabulary_name
FROM
    concept C,
    vocabulary V
WHERE
    C.concept_id = 192671 AND
    C.vocabulary_id = V.vocabulary_id AND
    sysdate BETWEEN valid_start_date AND valid_end_date;