Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Appendix A Common TIBCO Object Service Broker Text-Based Workbench Functionality : Common TIBCO Object Service Broker PF Keys : Managing the Selection

Managing the Selection
To modify the list of objects on the Object Manager screen, for example by selecting only certain members or by changing the order of presentation, or to act upon a subset of it, you can use the following four primary commands:
You can use operators and wildcard characters to modify these commands. Refer to Available Operators for more information.t
Using Wildcards in the Workbench
From the workbench, use these wildcards to pre-select an object manager object list:
Example
The following example displays the Rule Editor object manager screen with a listing of only the rules that begin with ABC:
ER edit rule ===> ABC*<ENTER>
Recalling Previous Commands
A history of ten previous commands is available from the Object Manager screens of the TIBCO Object Service Broker workbench tools. Press PF9 up to a maximum of ten times until you reach the previous primary command that you require. This limit is available for each tool and lasts for the duration of your TIBCO Object Service Broker session.
FIND Command
The FIND command locates an occurrence that meets the selection criteria you specify The search starts at the cursor position, not at the beginning of the selection. If an occurrence that meets the condition is found, the cursor is placed to the left of its primary key, which is highlighted. To find a subsequent occurrence that meets the same criteria, press PF5 (FIND NEXT).
The following restrictions apply for the FIND command:
The FIND command on the DESCRIPTION field is case sensitive.
Examples of the FIND Command
Type find salary > 700 to locate the first occurrence of an employee whose salary is greater than $700.
Type find salary > 700 & region = 'midwest' to locate the first occurrence of an employee whose salary is greater than $700 and whose region is the midwest.
SELECT Command
The SELECT command locates and displays a subset of occurrences of a table that meet the selection criteria. After you issue a SELECT, you can view all the occurrences in the table again by issuing the SELECT command with no selection criteria.
The SELECT command on the DESCRIPTION field is case sensitive.
The SELECT command is generally faster than the FIND command.
When using the SELECT command, a subset of the original occurrences appears. Subsequent commands pertain to this subset, except if you issue another SELECT, ORDERED, EDIT, or BROWSE command, which functions on the whole table, not just the subset. After issuing a SELECT, you can view all the occurrences in the table again by issuing the SELECT command with no selection criteria.
Examples of the SELECT Command
Type select lname='smith' to display all the employees with the last name Smith.
Type select lname='smith' & salary < 1000 to display all the employees with the last name Smith whose salary is less than $1000.
ORDERED Command
The occurrences in a table are stored in ascending order by primary key. However, you can display the information in descending order. If you want to order by a certain field, type the ORDERED command and then the field name on the command line. You can also specify multiple levels of ordering in one command. When specifying ascending or descending order, you can use the short forms, Asc or Desc.
Examples of the ORDERED Command
Type ordered desc deptno to sort the occurrences of the table in descending order by department number.
Type ordered desc deptno and ordered asc lname to sort occurrences in the table in descending order by department number and ascending order by last name.
Combining SELECT and ORDERED
You can combine the SELECT and ORDERED commands to display selected occurrences in a specified order. The results of a SELECT...ORDERED command are not stored in memory. A subsequent SELECT...ORDERED command affects the entire set of occurrences, not just the occurrences included in the most recent SELECT...ORDERED.
Example
Type select deptno=10 ordered lname to select all the employees in department 10, ordered according to last name.
ORDERED must be abbreviated to no less than ORD when used in a context such as in this example, to avoid confusion with the OR operator (OR).
APPLY Command
 
You can use APPLY to execute a line command for a set of occurrences using APPLY. The executed line command is applied to the selected items when you press Enter. You can use this command in conjunction with WHERE and ORDERED. For more information on line commands, refer to Managing MetaStor Objects.
If you do not use the APPLY command on a selected subset, the APPLY command acts on all the occurrences.
If you use the WHERE clause with APPLY, the selected subset appears.
If you use the APPLY command after you select a set of occurrences, it acts only on this subset of occurrences.
Example
Type apply p where creator='USR40' ordered desc name to print all the tables created by user ID USR40 in descending order by name.
See Also
TIBCO Object Service Broker Programming in Rules for information on the WHERE clause.
 

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved