inspectomop.queries.general.descendants_for_concept_id

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

Find all descendant concepts for a concept_id.

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 : [‘descendant_concept_id’, ‘descendant_concept_name’, ‘descendant_concept_code’, ‘descendant_concept_class_id’, ‘vocabulary_id’, ‘min_levels_of_separation’, ‘max_levels_of_separation’]

Returns:

results

Return type:

inspectomop.results.Results

Notes

Original SQL

G09: Find descendants for a given concept:

SELECT
    C.concept_id as descendant_concept_id,
    C.concept_name as descendant_concept_name,
    C.concept_code as descendant_concept_code,
    C.concept_class_id as descendant_concept_class_id,
    C.vocabulary_id,
    VA.vocabulary_name,
    A.min_levels_of_separation,
    A.max_levels_of_separation
FROM
    concept_ancestor A,
    concept C,
    vocabulary VA
WHERE
    A.ancestor_concept_id = C.concept_id AND
    C.vocabulary_id = VA.vocabulary_id AND A.ancestor_concept_id<>A.descendant_concept_id AND A.descendant_concept_id = 192671 AND
    sysdate BETWEEN valid_start_date AND valid_end_date
ORDER BY 5,7;