Request Tracker and Power BI

RT Developers
1

I am trying to export the data from RT for use with an case overview dashboard in power bi.

It seems the resolved date is not correctly set when a case is resolved and a lot of cases have 01.01.1970 as the resolved date.

So I am trying to find out if the last date a comment or update was made against a case is available from the database.

Does anyone know about this?

Thanks in advance

2

https://docs.bestpractical.com/rt/5.0.2/RT/Ticket.html#LastUpdated

Iā€™m not sure where in the db this is set, but tickets track when they were last updated

1 Like
3

Sorry for the late reply but thank you.