IT Process Automation

 View Only
  • 1.  PAM Query Database Operator

    Posted Jul 08, 2014 03:02 AM


    Hi ;

    I am using  Query_Database operator for data attract from CA Service Desk  Manager.

    When I opened new ticket on CA Servicedesk I handle persid this ticket.

    I want to  list my data according to persid .

    I use this sql query but this is not work .

    My Query:

    select top 4 id,transfer_time from ztransfer_list where call_req_id ='" + Process.persid + "'   order by id desc

    How should a query ?



  • 2.  Re: PAM Query Database Operator

    Posted Jul 23, 2014 02:21 PM

    Hi,

     

    It looks like you're trying to retrieve data from a user defined table (z-table).  What is not working with this query?

     

    Thanks,

    Tom