Template on SC_TASK table

[Veronica10]

Hello All, I am pretty new. Do you know if there is any option to set up template on sc_task table? Most of our catalog items have templates in the workflow activities. However I am not able to see these templates in report from sc_task table. It would be much easier to count tasks, currently we have to user short description as a condition in reports, however this field is often changed by teams. 

Thanks for help. 

[OlaN]

Hi,

What are you really after?

It seems like your goal is to count tasks that relate to one (or more) catalog items?
If that's the case, you could count by just filtering in your report. Filter all tasks that originate from the same catalog item.

[Veronica10]

Hi, 

We need to count tasks by their type, for example how many software tickets we have. We do not want to use short description because this field is often changed, so I need some permanent field which I could use in reports. That is why I though about the template. 

[Tom Sienkiewicz]

From sc_task, you can dot-walk to the Requested Item, and from there, to the Catalog Item, which at least gives you info on which cat items the specifc catalog tasks belong to. That should be useful for reporting.

If you need another type of information to differentiate the tasks, you can add some technical field to sc_req_item table and autopopulate it during ordering, for example, then that new field can also be part of your reporting.

It is possible to include requested item variables in reports as well (at least, list type of reports).