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 NAMES "Graph size:[Width:]","Save and Copy Options:[Display advanced options]", "Font style:[Font size used throughout the application]",   "Language:[Metadata]" FOR CURRENTUSER 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.