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 .
select top 4 id,transfer_time from ztransfer_list where call_req_id ='" + Process.persid + "' order by id desc
How should a query ?