Uploaded image for project: 'Data Integrity Module'
  1. Data Integrity Module
  2. DINT-70

Add the ability to run SQL based rules

    Details

    • Type: New Feature
    • Status: Needs Assessment
    • Priority: TBD
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None
    • Complexity:
      Undetermined

      Description

      This needs a lot more thinking, however if a user can create a rule that runs an SQL statement that returns data that can be saved into the result table.

      The rule will require the following information:

      • rule name
      • SQL statement

      A default handler class name will be provided by the module

      The SQL statement must return the following columns in order to be processed:

      • patient_id or program_id (only one, not both)
      • notes (required) to be published
      • action_url (optional)

        Gliffy Diagrams

          Attachments

            Issue Links

              Attachments-Category-Modification

                Activity

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    ssmusoke Stephen Senkomago Musoke
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    1 Start watching this issue

                    Dates

                    • Created:
                      Updated: