- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-07-2019 09:35 AM
Hi want to have task_sla fields in my sc_task table report.
Report: Test_report
Table: sc_task
I want to have these 2 fields (task sla fields) in my report related to that task
Solved! Go to Solution.
- Labels:
-
Team Development
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-07-2019 09:42 AM
Another alternative is to use the OOB database view named "sc_task_sla"
You can report on this table and add required fields from sc_task and task_sla tables on your list view.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-07-2019 11:58 AM
Reporting on variables is an entirely different thing, You will need to create a new database view b/w sc_task, task_sla and variable ownership table
Note that you wont get all the variables in a single record like task field values. For each variable there would be a separate record added in the table with its value.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-07-2019 12:00 PM
Got it