Data Partitions

Example Constraints

Table	Type	Syntax	Description
ca_contact	Pre-Update	id = @root.id	Only permit update of your own Contact Record.
ca_contact	Pre-Update	id = U'00'	Prevent updating of any Contact.
ca_contact	View	last_name NOT LIKE 'KT%'	Prevent display of any Groups beginning with the letters 'KT'
Call_Req	Create	customer = @root.id	Allowing only the creation of tickets where you are the End User
Call_Req	Default	type = 'I'	Create an Incident
Call_Req	Default	category = 'pcat:400001'	Set a default Request/Incident/Problem Area
Call_Req	Delete	id = 1	Prevent the deletion of any tickets
Call_Req	Pre-Update	customer = @root.id	Allowing only the updating of tickets where you are the End User
Call_Req	View	customer = @root.id	Allowing only the viewing of tickets where you are the End User
Cr_Status	View	code IN ('ACK','OP','RE','WIP')	Display a set list of Status Options
Workflow_Task	Delete	task != 'APP'	Prevents the deletion of the Approval task.

---

To make corrections or additions to this article, select the edit tab above.
To discuss or ask questions about this article, select the discussion tab above.