Skip to main content
Question

Help me in converting SQL to PQL

  • July 6, 2023
  • 1 reply
  • 5 views

I would like to identify the incidents for which the assignment group is changed more than two times. I am able to write this in SQL but need some help in converting this to PQL

SELECT INCIDENT_NUMBER,COUNT(*)

FROM "_CEL_INC_ACTIVITIES"

WHERE ACTIVITY_EN = 'Change Assignment Group'

GROUP BY   INCIDENT_NUMBER

ORDER BY 2 DESC

Thanks in Advance

1 reply

kailash.potha12
Level 10
Forum|alt.badge.img+6

You can try below formula

 

CALC_REWORK(ACTIVITY_EN  = 'Change Assignment Group')