I am trying to create a constraint which forbids to put assignee who is not a member in the group for this ticket.
I have tried update constraint for Call_Req table assignee in ( group.[group]group_list.member.id ) but I have got an error:
Bad where clause. invalid constraint. Check data types of referenced attributes
How can I do this?