List Web Preferences statement

Lists MicroStrategy Web preferences by preference group name or preference name.

LIST [ALL] WEBPREFERENCES [(GROUPS 
 "groupname1" [, ... 
 "groupnameN"] | NAMES 
 "name1" [, ... "nameN"])] FOR (USER "username" | CURRENTUSER) IN 
 (ALLPROJECTS | PROJECT "project_name");

LIST [ALL] WEBPREFERENCES [(GROUPS 
 "groupname1" [, ... 
 "groupnameN"] | NAMES 
 "name1" [, ... "nameN"])]  IN PROJECT 
 "project_name";

where:

• GROUPS "groupname1..N" are Web preference group names to be listed, of type string.
• NAMES "name1..N" are Web preference names to be listed, of type string.
• USER "username" is the user for whom Web preferences are to be listed, of type string.
• CURRENTUSER lists Web preferences for the current user.
• ALLPROJECTS lists Web preferences in all projects.
• PROJECT "project_name" is the name of the project for which Web preferences are to be listed, of type string.

Example

LIST ALL WEBPREFERENCES FOR USER "JeanSmith2" 
 IN ALLPROJECTS;

LIST ALL WEBPREFERENCES IN PROJECT "Testing 
 Project 03";

ResultSet Columns

LIST ALL WEBPREFERENCES IN ALLPROJECTS;

• WEBPREFERENCES_GROUP: A ResultSet containing information about all Web preferences in a group:

  • USE_DEFAULT_VALUE: Whether to use the default value for this preference, returned as a boolean value.

  • WEBPREFERENCE_NAME: The name of a preference, returned as a string.

  • WEBPREFERENCE_VALUE: The value of that preference, returned as a string.

• WEBPREFERENCES_GROUP_NAME: The name of the Web preferences group, returned as a string.

LIST WEBPREFERENCES NAMES;

• USE_DEFAULT_VALUE: Whether to use the default value for this preference, returned as a boolean value.

• WEBPREFERENCE_NAME: The name of a preference, returned as a string.

• WEBPREFERENCE_VALUE: The value of that preference, returned as a string.