Assure DQ

 View Only
  • 1.  Assure Control read instance count from "Result by CP"

    Posted 12-19-2022 22:07

    Hi,

    Is there a way Assure Control can read instance count from "Result by Control Point"  results?

    Thanks

    Athar Syed



    ------------------------------
    Athar ali Syed
    Health Care Service Corporation
    Chicago IL
    ------------------------------


  • 2.  RE: Assure Control read instance count from "Result by CP"

    Employee
    Posted 12-27-2022 14:58
    There are a couple of ways to get this information.

    One way is if you know the result catalog ID, you can use the webservice API's for Assure DQ to obtain the summary information about the execution, which returns all the information on the Summary tab of that result catalog.

    Another way which may help is an enhancement added in release 9.5 for HCSC - a new function you can use in the More | Manage Actions popup when making a conditional action to run a control point or script at the conclusion of control point execution. The function is @exec_instances() which tells you how many instances the current control point execution processed.

    If you need to get this information across potentially all recent control point executions, you would need a database layout that queries the Assure database.​ Table EXCEPTIONCATALOG, column RECORDCOUNT holds the value you are looking for. The column PROCESSDEFNAME is the control point name, and column PROCESSGROUPNAME is the control entity name. The other columns are fairly self explanatory.

    ------------------------------
    Brian Butters
    Precisely Software Inc.
    ------------------------------