AnsweredAssumed Answered

Stored Query

Question asked by PramilaJanarthanan on Nov 20, 2017
Latest reply on Nov 27, 2017 by Brian_Mathato

Hi,

I need to customize my scoreboard which should check the assigned group name should not be "Pivotts" and all other groups Open incidents.

But when we create an incident it will not be assigned to any group(which means group will be blank) so its not including in that node. I want to have the new incident also be in the new node.

 

We used the query "status != \'CL\' AND status != \'RE\' AND type = \'I\' AND (group.last_name = \'Pivotts\' OR group is null)  

 

Error: 

AHD05800:Bad where clause. AHD03106:Where clause results in a Cartesian product

 

Please let me know is there any way to achieve this scenario

 

Thanks,

Pramila

Outcomes