AnsweredAssumed Answered

SDM12.9 Data Partition Constraint Issue

Question asked by Kris_D on Apr 8, 2015
Latest reply on Apr 9, 2015 by Michael Mueller

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?

Outcomes