AnsweredAssumed Answered

PAM Query Database Operator

Question asked by salihyakici on Jul 8, 2014
Latest reply on Jul 23, 2014 by Tom_Kouhsari

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 ?