We need to limit access to tickets by affected service such that some users can see all ticket and other are locked out of specific affected services. I have implemented this with a Data Partition Constraint on View for Call_Req of NOT(affected_service.name IN('name1', name2'). This seems to work but had the unexpected consequence of also blocking access to tickets where affected service was not set.
I tried adding an or affected_service.name = NULL and got an error "AHD05800:Bad where clause. AHD03106:Where clause results in a Cartesian product".
Anyone have a suggestion that will not block empty affected services?