Difference between revisions of "Data Partitions"
From SDU
m |
m (→Example Constraints) |
||
| Line 1: | Line 1: | ||
| − | |||
== Example Constraints == | == Example Constraints == | ||
| Line 8: | Line 7: | ||
! style="width:25%;" | Syntax | ! style="width:25%;" | Syntax | ||
! style="width:45%;" | Description | ! style="width:45%;" | Description | ||
| + | |-valign="top" | ||
| + | | '''ca_contact''' | ||
| + | | Pre-Update | ||
| + | | id = @root.id | ||
| + | | Only permit update of your own Contact Record. | ||
| + | |-valign="top" | ||
| + | | '''ca_contact''' | ||
| + | | Pre-Update | ||
| + | | id = U'00' | ||
| + | | Prevent updating of any Contact. | ||
| + | |-valign="top" | ||
| + | | '''ca_contact''' | ||
| + | | View | ||
| + | | last_name NOT LIKE 'KT%' | ||
| + | | Prevent display of any Groups beginning with the letters 'KT' | ||
| + | |-valign="top" | ||
| + | | '''Call_Req''' | ||
| + | | Create | ||
| + | | customer = @root.id | ||
| + | | Allowing only the creation of tickets where you are the End User | ||
| + | |-valign="top" | ||
| + | | '''Call_Req''' | ||
| + | | Default | ||
| + | | type = 'I' | ||
| + | | Create an Incident | ||
| + | |-valign="top" | ||
| + | | '''Call_Req''' | ||
| + | | Default | ||
| + | | category = 'pcat:400001' | ||
| + | | Set a default Request/Incident/Problem Area | ||
| + | |-valign="top" | ||
| + | | '''Call_Req''' | ||
| + | | Delete | ||
| + | | id = 1 | ||
| + | | Prevent the deletion of any tickets | ||
| + | |-valign="top" | ||
| + | | '''Call_Req''' | ||
| + | | Pre-Update | ||
| + | | customer = @root.id | ||
| + | | Allowing only the updating of tickets where you are the End User | ||
| + | |-valign="top" | ||
| + | | '''Call_Req''' | ||
| + | | View | ||
| + | | customer = @root.id | ||
| + | | Allowing only the viewing of tickets where you are the End User | ||
| + | |-valign="top" | ||
| + | | '''Cr_Status''' | ||
| + | | View | ||
| + | | code IN ('ACK','OP','RE','WIP') | ||
| + | | Display a set list of Status Options | ||
|-valign="top" | |-valign="top" | ||
| '''Workflow_Task''' | | '''Workflow_Task''' | ||
| − | | | + | | Delete |
| task != 'APP' | | task != 'APP' | ||
| Prevents the deletion of the Approval task. | | Prevents the deletion of the Approval task. | ||
Revision as of 14:43, 17 June 2008
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.
To discuss or ask questions about this article, select the discussion tab above.
