CA SDM Data partition::. call_req cr

Document created by TMACUL Champion on Mar 7, 2016Last modified by TMACUL Champion on Mar 9, 2016
Version 4Show Document
  • View in full screen mode

"Data partitions are subsets of the database with restricted access to data records. Restrict access by defining a set of constraints for each data partition. Assign these data partitions to access types. The data partition assignment determines the records that the contact can access." CA Wiki

 

Example Syntax, to use on default, view, create, pre-update, delete :

SyntaxDescription
organization is nullAllowing only the viewing of tickets where the organization is null
type = 'I'Create an Incident
id = 1Prevent the deletion of any tickets
customer.last_name NOT LIKE '%name%'

Allowing ticket creation for contacts that don't have a certain string of characters in their last name

Warning: See comment jmayer

customer = @root.idAllowing only the creation of tickets where you are the End User
category = 'pcat:400001'Set a default Request/Incident/Problem Area
customer.organization.name <> 'ABC'Allowing only the viewing of tickets where the organization is different
customer.organization.name not like '%XYZ%'

Allowing only the viewing of tickets where the organization is like

Warning: See comment jmayer

group.organization.name IN ( 'ORG1', 'ORG2' )

Allowing only the viewing of tickets where the organization in list

Improved by Giedrius

group = U'807AEA15E8A2CF4ABF9181CBFEA12899'Set a default Group
group.[group]group_list.member IN (@root.id)Allowing only the viewing of tickets where the own group

 

 

 

know_more.jpg

Data Partitions - CA Service Management - 14.1 - CA Technologies Documentation

Search "Data Partitions" Results  - CA Service Management - 14.1 - CA Technologies Documentation

Data Partition Constraints and Controlled Table - CA Service Management - 14.1 - CA Technologies Documentation

How to Set Up the Data Partition - CA Service Management - 14.1 - CA Technologies Documentation

TEC1960413 - Error while setting a default Data Partition “Data partition default "0" for attribute priority is incorrect value type string; expecting type integer”

TEC478763 - How do we use a "Defaults" data partition constraint to set a group?

TEC1982813 - "AHD05237:An internal error with surveys occurred" and "AHD03055:Data partition Create restriction on Survey" in multi-tenanted environment

 

http://www.servicedeskusers.com/Data_Partitions.

3 people found this helpful

Attachments

    Outcomes