Assure DQ

Welcome to the Assure DQ community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 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.
    ------------------------------