AnsweredAssumed Answered


Question asked by mohansrinivas on Dec 23, 2014
Latest reply on Dec 24, 2014 by jw1

Hi All,


Am using the below SQL query to fetch the trqansfer ticket details but Iw ant the details for the particular time period(for jan 2014 to dec 2014) how to achieve this using time stamp,

can we get the ticket details using open date and close date also,please advise.

select                 ,               

call_req.ref_num,                     act_log.action_desc

From act_log  ,                                                                                  


where act_log.call_req_id = call_req.persid

  AND act_log.description LIKE('%Transfer Group from ''SRC'' to ''ESR_EMAAP''%')