I need some help with some querys, i need to create a query that told me when my ticket is next to violate the SLA. (You know when the ticket number is orange in SD). I try with the following queries but they doesn't work:
- (group.[group]group_list.member IN (@cnt.id)) AND active = 1 AND macro_predict_viol = 1
- (group.[group]group_list.member IN (@cnt.id)) AND active = 1 AND predicted_sla_viol = 1
I also want to create a query that only bring me the open tickets of a certain group. I think something like this would help but it doesn't work, any suggests?
- group_id = \’ 0x2A97BF63E650C542A38F5D53027B47AD\’ AND active = 1
Thanks in Advance!