AnsweredAssumed Answered

SQL - Parse act_log transfer activity

Question asked by PedroRamalho on Jul 28, 2016
Latest reply on Jul 29, 2016 by pier-olivier.tremblay

Hi all,

 

I need to create a SQL View that outputs information regarding incident transfers (from X to Y). My problem is that the only available field with that kind of information is text - act_log.description.

 

I will provide some examples and the data that I need to display:

  • Transfer Assignee from '' to 'Tech Name'
    • assignee_prev = NULL
    • assignee_dest = 'Tech Name'
    • group_prev = NULL
    • group_dest = NULL
  • Transfer Assignee from 'Tech 1' to 'Tech 2'
    • assignee_prev = 'Tech 1'
    • assignee_dest = 'Tech 2'
    • group_prev = NULL
    • group_dest = NULL
  • Transfer Group from 'Group 1' to 'Group 2'
    • assignee_prev = NULL
    • assignee_dest = NULL
    • group_prev = 'Group 1'
    • group_dest = 'Group 2'
  • Transfer Assignee from 'Tech 1' to 'Tech 2' Transfer Group from 'Group 1' to 'Group 2'
    • assignee_prev = 'Tech 1'
    • assignee_dest = 'Tech 2'
    • group_prev = 'Group 1'
    • group_dest = 'Group 2'

 

Any SQL ninja that can provide some help?

 

Thank you!

Outcomes