How can I create a report on sctasks which groups them by department?

[Charlotte King]

Hi,

I need to produce a report on our current open sc tasks and arrange it by department. 

I can't select department from the options and can't find a way around this. Is this a case that a database view needs to be created? (I don't have admin rights so would need to ask our admin team if this is the case)

Thanks,

Charlotte 

[DJL2]

Hi Charlotte,

This should be easy enough for you to do.  Try this:

1. Create a report using the Catalog Task [sc_task] table
2. Add an additional field, navigate to Requested Item [+] and dot-walk
3. Then, navigate to Requested for [+] and dot-walk
4. Finally, select Department and hit [>] to add

This will now give a column reporting the Department associated with the requestor 🙂

Thanks,

DJL

[Charlotte King]

When you say 'add an additional field' what do you mean? 

I have managed to find a way around as suggested below by Grouping by: Request> Requested for> Department

[DJL2]

Hi Charlotte,

My guidance describes how you would pull the 'Department' field to display as an additional column, within a List report.  This field is always helpful to have displayed against each record.

Ashutosh describes the same dot-walk if you just wanted to Group.

Thanks,

DJL

[Ashutosh Munot1 · Accepted solution]

HI,

You can dot walk request.requested_for.department and you are done.

Thanks,
Ashutosh

[Charlotte King]

Perfect thank you!