inspectomop.queries.general.parents_for_concept_id

inspectomop.queries.general.parents_for_concept_id(concept_id, inspector, return_columns=None)

Find all parent concepts for a concept_id. (Ancestors whose level of separation is 1)

Parameters:

• concept_id (int) – concept_id of interest from the concept table
• inspector (inspectomop.inspector.Inspector) –
• return_columns (list of str, optional) –
  • optional subset of columns to return from the query
  • columns : [‘parent_concept_id’, ‘parent_concept_name’, ‘parent_concept_code’, ‘parent_concept_class_id’, ‘parent_concept_vocabulary_id’, ‘parent_concept_vocab_name’]

Returns:

results

Return type:

inspectomop.results.Results

Notes

Original SQL

G10: Find parents for a given concept:

SELECT
    A.concept_id Parent_concept_id,
    A.concept_name Parent_concept_name,
    A.concept_code Parent_concept_code,
    A.concept_class_id Parent_concept_class_id,
    A.vocabulary_id Parent_concept_vocab_ID,
    VA.vocabulary_name Parent_concept_vocab_name
FROM
    concept_ancestor CA,
    concept A,
    concept D,
    vocabulary VA
WHERE
    CA.descendant_concept_id = 192671 AND
    CA.min_levels_of_separation = 1 AND
    CA.ancestor_concept_id = A.concept_id AND
    A.vocabulary_id = VA.vocabulary_id AND
    CA.descendant_concept_id = D.concept_id AND
    sysdate BETWEEN A.valid_start_date AND A.valid_end_date;