This command lists the specified Warehouse Builder objects under the current folder. You can also provide a regular expression to list objects in a different folder and/or to list objects with names matching a pattern. Some global objects (e.g. LOCATIONS, CONTROL_CENTERS, USERS, ROLES, CONFIGURATION_TEMPLATES, ICONSETS) can be listed from any context. Before displaying the objects, this command first refreshes the object list from the repository. This means that the list of objects returned also reflects any additions or deletions by other users.
parseListCommand = "listActionPlans" | "listGeneral" listActionPlans = OMBLIST DEPLOYMENT_ACTION_PLANS [ "QUOTED_STRING" ] listGeneral = OMBLIST "UNQUOTED_STRING" [ "QUOTED_STRING" ]
The type (plural) of the objects to be listed. Valid object types are: ACTIVITY_TEMPLATES, ACTIVITY_TEMPLATE_FOLDERS, ADVANCED_QUEUES, ALTERNATIVE_SORT_ORDERS, BUSINESS_AREAS, BUSINESS_DEFINITION_MODULES, OBIEE_BUSINESS_DEFINITION_MODULES, BUSINESS_PRESENTATION_MODULES, CALENDARS, CALENDAR_MODULES, CMI_DEFINITIONS, CMI_MODULES, COLLECTIONS, CONFIGURATIONS, CONNECTORS, CONTROL_CENTERS, CUBES, DATA_AUDITORS, DATA_PROFILES, DATA_RULES, DATA_RULE_MODULES, DEPLOYMENTS, DEPLOYMENT_ACTION_PLANS, DIMENSIONS, DRILL_PATHS, DRILLS_TO_DETAIL, EXPERTS, EXPERT_MODULES, EXTERNAL_TABLES, FLAT_FILES, FLAT_FILE_MODULES, FOLDERS, FUNCTIONS, GATEWAY_MODULES, ICONSETS, ITEM_FOLDERS, CTS, CT_FOLDERS, LISTS_OF_VALUES, LOCATIONS, MAPPINGS, MATERIALIZED_VIEWS, NESTED_TABLES, OBJECT_TYPES, ORACLE_MODULES, PACKAGES, PLSQL_RECORD_TYPES, PLSQL_REF_CURSOR_TYPES, PLSQL_TABLE_TYPES, PLUGGABLE_MAPPINGS, PLUGGABLE_MAPPING_LIBRARIES, PRESENTATION_TEMPLATES, PROCEDURES, PROCESS_FLOWS, PROCESS_FLOW_MODULES, PROCESS_FLOW_PACKAGES, PROJECTS, QUEUE_PROPAGATIONS, QUEUE_TABLES, REAL_TIME_MAPPINGS, REGISTERED_FUNCTIONS, ROLES, SAP_MODULES, SEQUENCES, SNAPSHOTS, STREAMS_CAPTURE_PROCESSES, STREAMS_QUEUES, TABLES, TABLE_FUNCTIONS, TIME_DIMENSIONS, TRANSFORMATION_MODULES, TRANSPORTABLE_MODULES, USERS, VARYING_ARRAYS, VIEWS.
Mandatory for CONNECTORS, specify a location name; optionally for all other objects, specify a regular expression, which is used to filter the results.
The syntax of the regular expressions follow the syntax from TCL.
Here are some of the quantifiers:
* -- represents a sequence of 0 or more matches of the atom.
+ -- represents a sequence of 1 or more matches of the atom.
? -- represents a sequence of 0 or 1 matches of the atom.
Here are some of the atoms:
. -- matches any single character
k -- (where k is a non-alphanumeric character) matches that character taken as an ordinary character,
e.g. \\ matches a backslash character.
c -- where c is alphanumeric(possibly followed by other characters), an escape.
(re) -- (where re is any regular expression) matches a match for re, with the match noted for possible reporting.
[char] -- a bracket expression, matching any one of the chars.
Further documentation on the syntax can be found at the TCL manual page under the command 'regexp'.