Need to send a weekly report schedule

[sanga2]

Hi all, I have a requirement where in I need to send a weekly report of list of incidents which have been updated to work in progress for that week. The list should include the incident number, requestor, state and link to that incident. Please suggest on how to achieve this?

[AndersBGS]

Hi @sanga2 ,

According to your requirement, you would like to know the incidents that were updated to state "work in progress" last week. According to this requirement, I would look at the incident_metric tavle to create the report. Here you can see when the different incidents have been updated to that specific state.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[sanga2]

Hi Ander,

My requirement is actually not on incident table but a custom table. Also we need to insert a link for that record in the row of that list view. The list should include the incident number, requestor, state and link to that incident in a list format.