• Chandra Robrock

  • May 06, 2023 15:57

  Community Moderator

  

  HeyBaljinder Singh- It looks like there are some issues with the parentheses. I've gone ahead and reformatted your query for you below:

  IF ([Ticket status]="Open" OR [Ticket status]="Pending")
  AND [Ticket first assigned - Hour]>12
  AND [Ticket first assigned - Hour]<24
  THEN [Ticket ID]
  ENDIF

  In terms of adding a group, you'll want to add a new line similar to the bolded one below:

  IF ([Ticket status]="Open" OR [Ticket status]="Pending")
  AND [Ticket first assigned - Hour]>12
  AND [Ticket first assigned - Hour]<24
  和[票集团]= "支持"
  THEN [Ticket ID]
  ENDIF

  If you also want to look at different groups, you'll want to add a similar line as the Ticket Status line you created, using OR logic. Example below:

  IF ([Ticket status]="Open" OR [Ticket status]="Pending")
  AND [Ticket first assigned - Hour]>12
  AND [Ticket first assigned - Hour]<24
  AND ([Ticket group]="Support" OR [Ticket group]="Support Engineering")
  THEN [Ticket ID]
  ENDIF

  Hope that helps!

• Baljinder Singh

  • May 06, 2023 18:48

  Thanks Chandra for your input on this, I really appreciate it. However, it does not solve the problem. What I actually want is to get the time in days since the tickets are in open or pending status. For ex: if an agent has received a reply from the customer and did not reply back and the ticket is left in Open state, I want to fetch this data.

  So far, I can only get tickets from Ticket updated time stamp but that includes anything( all updates on the ticket) so this is not actual data.

Pleasesign into leave a comment.