Assure DQ

 View Only
Back to discussions
Expand all | Collapse all

Create report of what the notify Infogix insight flag is set to in the advance options section of the control point

  • 1.  Create report of what the notify Infogix insight flag is set to in the advance options section of the control point

    Posted 11-23-2021 10:53

    We are trying to determine what the "notify Infogix Insight" is set to on each control point.  The report should contain the control entity and control point names.  Our original thought was we could run a query in the Admin Console but need to know what tables to search.  If you could either provide the query or provide that table and columns we would need to look at.

    Thanks

    Vip Patel



  • 2.  RE: Create report of what the notify Infogix insight flag is set to in the advance options section of the control point

    Employee
    Posted 11-24-2021 08:55

    The Control Points' definitions are stored as XML within the RULESEGMENT column of the RULEPART table.

    The query below will display control names in a format where the entity and point names are concatenated with an underscore, along with the XML configuration of that control point:

    SELECT c.DISPLAYNAME, r.* FROM RULEPART r INNER JOIN "RULE" c on RULEFK=RULEPK
    WHERE RULETYPEFK = 63
    ORDER BY DISPLAYNAME

    Within the XML in the RULESEGMENT column will a parameter named notifyInsightOverride that contains the setting value. An example of the XML is below:

    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <ns3:controlPointRule xmlns="/generated/export/integrityrules/ocm" xmlns:ns2="/generated/export/val/actions" xmlns:ns3="/generated/export/integrityrules/ocm/cp">
      <multiInstanceControlPoint name="samplecontrol" processDefinitionId="229051b0-4d3d-11ec-b5c7-048120524153" captureRule="_228a1020-4d3d-11ec-b5c7-048120524153_Capture" merge="_228fdc80-4d3d-11ec-b5c7-048120524153_Merge" storeHistory="false" instanceManagement="creates" cycleManagement="creates" executionActionLimit="100" executionProfile="default" dqplusControlDataPostProcessing="process" instancePreProcessing="none" notifyInsightOverride="bypass">
        <description></description>
        <actions>
          <ns2:controlReportGeneration action="suppress"/>
          <ns2:controlInstanceLifeCycle action="store"/>
          <ns2:applyProcessMonitorControl action="apply"/>
          <ns2:setRetentionPolicy policy="standard"/>
        </actions>
        <concurrency>
          <fail/>
        </concurrency>
      </multiInstanceControlPoint>
    </ns3:controlPointRule>

    As a general disclaimer, the syntax and location of how controls are stored may change over time.