I need to create a report in SQL Browser, but I don’t know the name in Agile Apps of the fields and object tables that I need, also I don’t know where I can find them.
The report should contain this information:
*Process name
*Process id
*Object name
*case number
*Date started of the process
*Due date of the process
*Date Completed of the process
*Status of the process
*Task id
*Task name
*Date created of the task
*Due date of the task
*Date completed of the task
I also don’t know how to create a relation between the task, the process and the case number.
Can you please help me to do this query??