I have an requirement to fetch the specific activity log like log comment,solution,transfer activity from the Call_Req table with respective to ticket number.
I have gone through the Call_Req table and found that there is no SREL relation between Call_Req and alg table ,attributes present in the call_req table are the brel relationship and doesn't exist in the database level.
I am not sure how to fetch activity data from the call_req table.Please guide me.
Hi Manish, The table act_log contains data for the activity log. How about considering to build a sql query to fetch the required data? Thanks, Naveen
The Activity Log is a BREL in the CR object and the table has a column of call_req_id, which is the persistent_id of the CR in question. You would need to get this from the Call_Req table and then extract data based on the information returned.
call_req_id, -- Join with ref_num in call_req table (bemerson's post)
time_stamp, -- Convert to datetime
analyst, -- Join with contact_uuid in ca_contact table
From act_log -- where activity logs are stored (Naveen's post)
Where type in ('LOG', 'SOLN', 'TR') -- Logged Comments, Solutions, Transfers
and time_stamp > '1404172800' -- since June 1st 2014 00:00:00 GMT (act_log likely has millions of records)
-- Hope this helps!
Thanks for your response,will try the solution.