AnsweredAssumed Answered

stored query issue

Question asked by Johnny_2302 on Sep 27, 2016
Latest reply on Jan 25, 2017 by birolturker.kara

Hi Team,

 

We have created a stored query to display the VIP user raised calls. So as per the new requirement we want to display the tickets raised by VIP users i.e. if the requested_by or affected_resource is a VIP User then it should be displayed in the node. We had made required changes in the scoreboard, however it was throwing the cartesian error message, hence modified the query as below, but it is not working and throwing syntax error when clicking on the scoreboard.

 

(group.[group]group_list.member IN (@cnt.id))
AND active = 1 AND type = \'R\' AND zfmdpc = 400001 AND status!=\'RE\' AND(
(customer.cnthandling_list.special_handling.sym= \'VIP\' AND requested_by.cnthandling_list.special_handling.sym = \'VIP\') OR
(customer.cnthandling_list.special_handling.sym != \'VIP\' AND requested_by.cnthandling_list.special_handling.sym = \'VIP\') OR
(customer.cnthandling_list.special_handling.sym = \'VIP\' AND requested_by.cnthandling_list.special_handling.sym != \'VIP\'))

 

 

Kindly let me know what could be the issue here.

Outcomes