This documentation supports the 9.1 version of Remedy Action Request System.

To view the latest version, select the version from the Product version menu.

Setting the Row-level Security fields

In BMC Remedy AR System version 9.1.03, you can set the sequence for how dynamic fields for row-level security appear in a SQL query. This results in faster and efficient working of Row-level Security. When you have more than one dynamic field ID (field Id 112 and field Ids 60000 to 60999) on a form, the fields in the SQL query are sorted by the Field Ids. This setting provides the flexibility to determine the sequence of fields based on the form and entries in your application to gain the maximum performance.

The following image shows the Field Id Order for Qualification view on the Row Level Security Fields panel:

To set the sequence of fields

  1. Open a form in BMC Remedy Developer Studio.
  2. From the Definition tab > Row Level Security > Field Id Order for Qualification .
    By default, the Field Id Order for Qualification view does not contain any fields. The dynamic group fields are sorted according to their field Ids. 
  3. (Optional) Click the Add or Remove buttons to add or remove fields in the Field Id Order Qualification view.
  4. (Optional) Click the Up or Down buttons to specify the order of the fields in the Field Id Order Qualification view. 
    When you specify the sequence by using Up or Down buttons, AR System ignores the dynamic field IDs and uses the same order of fields that you have specified. 
  5. From the Algorithm list, select one of the following SQL query options to notify whether the AR System server should use RLS_SPLIT / regex-based algorithm to generate the SQL query or the traditional OR clause-based SQL query. The following table describes the values available in the Algorithm list: 

    OptionDescription
    DefaultUses the value set for Disable-New-RLS-Implementation flag.
    RLS Split

    Sets the value of Disable-New-RLS-Implementation flag to F (false).

    Note: This option overrides the current value of Disable-New-RLS-Implementation flag.

    Combined likes

    Sets the value of Disable-New-RLS-Implementation flag to T (true).

    Note: This option overrides the current value of Disable-New-RLS-Implementation flag

     

  6. Save the form.

Related topic

Setting form properties

Was this page helpful? Yes No Submitting... Thank you

Comments