Task ID + Task Title + Work Log Report

Task ID + Task Title + Work Log Report

Hello, 

I have made a report under New Custom Report and then select TimeSpent module. It can show Account, Time Spent, Time Spent Technician … etc but I cannot find Task ID, Title in the field list.

 


Also, I have created a few worklog additional field for information collection such as “Incident Remoted Support”, “Problem Solved by Hour” .. etc.

 


The report should contain the below fields

-        - Account

-        - Task ID

-        - Title

-        - Time Spent Starttime

-        - Time Spent Endtime

-        - Time Spent

-        - Worklog Type

-        - Problem Solved by Hour (worklog additional field, the field name is Wlf_UDF_LONG2)

-       - Incident Remoted Support (worklog additional field, the field name is wlf.UDF_LONG1)

 

Sorry that I don’t know Postgres query, would you please advise how to do it.


Thanks


                  New to ADSelfService Plus?