Skip to content

Instantly share code, notes, and snippets.

@balasista

balasista/queries.sql

Last active March 22, 2023 23:34
Show Gist options
  • Save balasista/28cc4734db71a2c97930dfd55c31c631 to your computer and use it in GitHub Desktop.
Save balasista/28cc4734db71a2c97930dfd55c31c631 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. balasista revised this gist Mar 22, 2023. 1 changed file with 17 additions and 0 deletions.
    17 changes: 17 additions & 0 deletions queries.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -15,3 +15,20 @@ JOIN decision_input di1 ON di1.name = 'input_name_1' AND di1.version = dt.versio
    JOIN decision_input di2 ON di2.name = 'input_name_2' AND di2.version = dt.version
    WHERE di1.input_xml->>'input_variable_1' = 'input_value_1'
    AND di2.input_xml->>'input_variable_2' = 'input_value_2';

    -- Query to retrieve specifc version of BPMN process definition for a given input
    SELECT pd.name, pd.version
    FROM process_definition pd
    JOIN process_decision_table pdt ON pdt.process_definition_id = pd.id
    JOIN decision_table dt ON dt.id = pdt.decision_table_id
    JOIN decision_input di ON di.name = 'input_name' AND di.version = dt.version
    WHERE di.input_xml->>'input_variable' = 'input_value'
    AND pd.version = 2;

    -- Query to retrieve specifc version of DMN for a given input
    SELECT name, version
    FROM decision_table
    WHERE name = 'decision_table_name'
    AND version = 2
    AND table_xml->>'input_variable' = 'input_value';

  2. balasista revised this gist Mar 22, 2023. 1 changed file with 10 additions and 0 deletions.
    10 changes: 10 additions & 0 deletions queries.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -5,3 +5,13 @@ JOIN process_decision_table pdt ON pdt.process_definition_id = pd.id
    JOIN decision_table dt ON dt.id = pdt.decision_table_id
    JOIN decision_input di ON di.name = 'input_name' AND di.version = dt.version
    WHERE di.input_xml->>'input_variable' = 'input_value';

    -- Query to retrieve a bpmn for a multiple inputs
    SELECT pd.name, pd.version
    FROM process_definition pd
    JOIN process_decision_table pdt ON pdt.process_definition_id = pd.id
    JOIN decision_table dt ON dt.id = pdt.decision_table_id
    JOIN decision_input di1 ON di1.name = 'input_name_1' AND di1.version = dt.version
    JOIN decision_input di2 ON di2.name = 'input_name_2' AND di2.version = dt.version
    WHERE di1.input_xml->>'input_variable_1' = 'input_value_1'
    AND di2.input_xml->>'input_variable_2' = 'input_value_2';
  3. balasista created this gist Mar 22, 2023.
    7 changes: 7 additions & 0 deletions queries.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,7 @@
    -- Query to retrieve a bpmn for a given input
    SELECT pd.name, pd.version
    FROM process_definition pd
    JOIN process_decision_table pdt ON pdt.process_definition_id = pd.id
    JOIN decision_table dt ON dt.id = pdt.decision_table_id
    JOIN decision_input di ON di.name = 'input_name' AND di.version = dt.version
    WHERE di.input_xml->>'input_variable' = 'input_value';