Workflow and ServiceDesk Community

Hi,

We have recently upgraded to 7.6 and I'm trying to create a report using the report builder in 7.6. I would like to add the Process Age and Process.AgeDescription columns in the report but when I select it is shows the ProcessStarted date? I confirm this by viewing the SQL query that it creates. I also confirmed that the old reports that was on the system before the upgrade now displays the ProcessStarted date and not the age in the Age column.

Does anyone else have this problem and/or possibly a solution for me. All the custom reports for my customer includes these columns.

Much appreciated!

Ilze

You can try getting around it by doing a pure SQL report, or a SQL With Parameters type report

I can confirm that my 7.6 install has the same behavior. I hadn't noticed in the two weeks since install because most of my reports are SQL with parameters and not report builder. That said, I think we should expect this in a point fix and/or maintenance pack assuming it has been reported to Symantec.

This issue has already been reported to the Workflow development team. When a fix is available it will be included in a roll up build. The Workflow 7.6 Roll up build KB article INFO2509 will be updated to show this issue has been fixed and what build version it has been fixed in.

I usually also prefer pure SQL reports. I used report builder in order for my customer to amend the report settings as they require.  In which table can I find the Age column or do I need to calculate it, I know when entering a pure sql query for a SD report, it can identify some functions as harmful and then do not allow you to save the query which can be frustrating?

Thank you TGiles

Will keep an eye out for the update, I just need to get a work around inplace until then

This is a calculated column based off the reportprocess.ProcessStartedDated field and the current date. 

Specifically, this should do something like you want. Not the most efficient, I'm sure, but it works.

CASE WHEN DATEDIFF(DAY,ProcessStarted,GETDATE()) <> 0 THEN CAST(DATEDIFF(DAY,ProcessStarted,GETDATE()) AS NVARCHAR) + ' days'
WHEN DATEDIFF(HOUR,ProcessStarted,GETDATE()) <> 0 THEN CAST(DATEDIFF(HOUR,ProcessStarted,GETDATE()) AS NVARCHAR) + ' hours'
ELSE CAST(DATEDIFF(MINUTE,ProcessStarted,GETDATE()) AS NVARCHAR) + ' minutes'
END AS 'Age'

i typically use the supplied functions to handle Age in custom reports.

My mind is now blown. I had no idea that was there. That being said, it looks quite similar to what I wrote, so bully for me.

depending on the query, using the function can potentially be very costly.  use it with a healthy query and it should be handy.

Thank you for the information and assistance!

I also did not know about the available functions. I'm definitely going to use it as a workaround for the problem.

This issue has also been addressed and fixed in the Workflow 7.6 roll up build 493. I've included the link to download the updated build.

https://symantec.box.com/s/cahsfd6wupoe4rdedc010b9tcrm7z3md