IBM Support

Disabling the tree view, multirecord update, and SQL editor features for the web client

Question/Answer


Question

How do I disable the tree view, multirecord update, and SQL editor features for the web client?

Answer

By default, the tree view, multirecord update, and SQL editor features are enabled. To disable any one of these features for an entire dbset or for a specific user database, set the corresponding master property to 0. The master property can contain a default value that applies to all user databases, and it can further contain a value specific to a user database that overrides the default value.

  • For tree view, the master property is ALLOW_TREE_VIEW.
  • For multirecord update, the master property is ALLOW_MULTIRECORD_UPDATE.
  • For SQL editor, the master property is ALLOW_VIEW_SQL.
  • For inline create, the master property is ALLOW_INLINE_CREATE.
  • For inline editing, the master property is ALLOW_INLINE_EDIT.
  • For tree view, the master property is ALLOW_TREE_VIEW.
  • For multirecord update, the master property is ALLOW_MULTIRECORD_UPDATE.
  • For SQL editor, the master property is ALLOW_VIEW_SQL.
  • For form selection, the master property is ALLOW_FORM_SELECTION.
  • For dynamic forms, the master property is ALLOW_DYNAMIC_FORMS.
  • For view record reveal existence, the master property is VIEW_RECORD_REVEAL_EXISTENCE.
  • For public templates, the master property is ALLOW_PUBLIC_TEMPLATES.
  • For public list views, the master property is ALLOW_PUBLIC_LIST_VIEW_CONFIGS.

Use the installutil setmasterproperty subcommand to set the master property for the database set. The following are some examples for the tree view. You can disable the tree view feature for only the SAMPL database:

  • installutil setmasterproperty dbset_name -user_db_name SAMPL cq_login cq_password ALLOW_TREE_VIEW

You can unset the property ALLOW_TREE_VIEW for the SAMPL database to re-enable the tree view feature:

installutil setmasterproperty dbset_name -user_db_name SAMPL cq_login cq_password ALLOW_TREE_VIEW “” o

  • To disable the tree view feature for all databases, then enable it for two specific user databases through the following commands:

installutil setmasterproperty dbset_name cq_login cq_password ALLOW_TREE_VIEW 0

installutil setmasterproperty dbset_name -user_db_name SAMPL cq_login cq_password ALLOW_TREE_VIEW 1

installutil setmasterproperty dbset_name -user_db_name BTEST cq_login cq_password ALLOW_TREE_VIEW 1

  • To remove the setting for all databases, including two specific databases, do this:

installutil setmasterproperty dbset_name cq_login cq_password ALLOW_TREE_VIEW “”

installutil setmasterproperty dbset_name -user_db_name SAMPL cq_login cq_password ALLOW_TREE_VIEW “”

installutil setmasterproperty dbset_name -user_db_name BTEST cq_login cq_password ALLOW_TREE_VIEW “”

Restricting the tree view, multirecord update, and SQL editor features to certain users

By default, the use of these features are unrestricted. To restrict one feature to certain groups of users:

1. Open Site Configuration.

2. Select the Application Options tab.

3. Specify the list of groups whose members that should be allowed to use the features in the Allow Tree View Groups, Allow MultiRecord Update Groups, or SQL Visible To Groups fields:

image-20190211090018-1

 

Note that there are similar group lists to restrict the Inline Create and Inline Edit features to certain groups. These restrictions have no effect if the corresponding feature is disabled by the corresponding master property.


Document information

More support for: Rational ClearQuest

Component: --

Software version: 8.0.1.7

Operating system(s): AIX, Linux, Solaris, Windows

Reference #: 1698190

Modified date: 20 March 2019