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)
AHD05800:Bad where clause. AHD03106:Where clause results in a Cartesian product
Please let me know is there any way to achieve this scenario