Open topic with navigation

TIBCO GridServer® 7.1.0

# Tables and Table Controls

Most pages have items or information shown in tables. For example, the Grid Components > Engines > Engine Admin page displays a table with a row for each Engine in the grid. The following controls enable you to perform actions on the listed items, or change what items are displayed.

## Action Controls

Each table item has an action control (), which opens a list of actions for the selected items in the table. Some of these perform actions on table items, while others open a new page. If no items are selected, this acts as a Global Action control, which opens a list of actions to perform on all items.

## Search Control

The Search control is displayed on any page containing a table. There are two types of searches: a simple search, and a query search.

For the simple search, enter a string in the Search box, select a column to search from the list, and click the search icon. A new table appears, containing the matching rows.

Click the icon next to Search and select Query for a query search. This enables you to search properties using regular expressions consisting of, at minimum, a property, operator, and value. Terms can also contain wildcards and regular expressions, as defined by `java.util.regex.Pattern`. Click Search to run the query.

You can enter your own complex query by selecting Query Builder. If you first define a query in the Query Builder and then select Query, the query is displayed in the Find box.

## Columns Control

The Columns control enables you to change which columns are displayed in a table. When you click the Columns control, an overlay appears, listing all columns currently in the table and columns that can be added.

To display a hidden column, click the + symbol next to the column in the Add Columns list. To hide a column, click the X symbol next to the column in the Columns list.

When you add a new column, it is added to the bottom of the list. The table displays the columns from left to right in the order of this list. To change the order of columns, click and drag the column name in the Columns list.

After you have made changes, click Save to apply them. To return to the default visible columns, click Revert.

The displayed table rows are always sorted by a column that has an arrow in it, either facing up or down. You can click this arrow to reverse the sort order of entries in the table, or click another column to change the sort column. Table order is only kept for that page view and is not persisted.

## Refresh

Pages in the GridServer Administration Tool are automatically refreshed every ten seconds by default to display the most current information available. Click the Refresh control to view the last time a page was refreshed, or to disable automatic refreshes. You can also customize the refresh rate by setting the AJAX Refresh Interval property on the Admin > System Admin > Manager Configuration page, in the Security section.

## Pager Controls

The Pager controls, shown above and below tables, enable you to step through multiple pages of information, or specify how many rows appear on a page. Select a page number from the Page list, or select a range from the items list to display those items. You can select a greater number of items listed per page in a table or display all of the items; type a number in the Results Per Page box and click Go.

## Exporting Table Data

Most information shown in Administration Tool tables can also be accessed programmatically using the TIBCO GridServer® Admin API. The Admin API can also be accessed with SOAP Web Services; the WSDLs are available from the Grid Components > Drivers > Web Services page.

For example, to generate a list of information about all logged in Engines as normally presented on the Engine Admin page, you could write a simple client application that connects to the Manager and uses the `getAllEngineInfo` method of the `EngineAdmin` Web Service.

For more information about using the Admin API, see the TIBCO GridServer® Developer’s Guide.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO GridServer®

Copyright © 2001-2022. TIBCO Software Inc. All Rights Reserved.