Solved

Redirecting Tasks

  • 10 December 2020
  • 2 replies
  • 45 views

Badge +1

I’m a K2 admin for our company and I’m trying to figure out how I can determine the original destination for a task that has been redirected. I’m often asked who redirected a particular task to another user but I haven’t been able to find a way to see how the first user was. Is there a way to do this either from the Management Dashboard or from the database tables?

icon

Best answer by tbyrne777 10 December 2020, 18:22

You’ll find this in the ServerLog.ActInstAudit table. Here is a good way to get it at for a specific folio:

 

    SELECT    aia.[Date],
            aia.[User],
            a.Name,
            aia.Descr AS 'Description'
    FROM    [K2-SqlDev].[K2DEV].ServerLog.ProcInst pi
            JOIN [K2-SqlDev].[K2DEV].ServerLog.ActInst ai ON ai.ProcInstID = pi.ID
            JOIN [K2-SqlDev].[K2DEV].ServerLog.ActInstAudit aia ON aia.ProcInstID = ai.ProcInstID AND aia.ActInstID = ai.ID
            JOIN [K2-SqlDev].[K2DEV].ServerLog.Act a ON a.ID = ai.ActID
    WHERE    pi.Folio = @folio

View original

2 replies

Userlevel 4
Badge +8

You’ll find this in the ServerLog.ActInstAudit table. Here is a good way to get it at for a specific folio:

 

    SELECT    aia.[Date],
            aia.[User],
            a.Name,
            aia.Descr AS 'Description'
    FROM    [K2-SqlDev].[K2DEV].ServerLog.ProcInst pi
            JOIN [K2-SqlDev].[K2DEV].ServerLog.ActInst ai ON ai.ProcInstID = pi.ID
            JOIN [K2-SqlDev].[K2DEV].ServerLog.ActInstAudit aia ON aia.ProcInstID = ai.ProcInstID AND aia.ActInstID = ai.ID
            JOIN [K2-SqlDev].[K2DEV].ServerLog.Act a ON a.ID = ai.ActID
    WHERE    pi.Folio = @folio

Badge +1

Thanks @tbyrne777  This query gave me exactly what I needed!

Reply