IT Process Automation

 View Only
Expand all | Collapse all

PAM Query Database Operator - How to access the QueryResult?

  • 1.  PAM Query Database Operator - How to access the QueryResult?

    Posted Oct 25, 2021 11:40 AM
      |   view attached

    Hello and Good Morning.

    Request assistance as to how to assign the query result to a variable in PAM.  The query database was successful and was able to retrieve the data from the DB but can seem to assign it to a variable and getting  "msg.valuemap.no.indexed.access" errors.

    The column name is ref_num and description.. I tried the below assignments but it does not work.  I have attached a screenshot of the QueryResult.

    Process[OpName].QueryResults[0].ref_num
    Process[OpName].QueryResults[0].description

    Thank you.

    br
    ken



  • 2.  RE: PAM Query Database Operator - How to access the QueryResult?

    Posted Oct 25, 2021 11:58 AM
    I think I found it..

    it would be Process[OpName].QueryResults.ResultSets[0].Rows[0].variable (where variable would be the column name).

    br
    ken