- Index

< Previous |  | Next >

# LiveView Desktop Grid View

This document uses the Hello LiveView sample to explain how to use grid views in LiveView Desktop.

Load and run the Hello LiveView sample as delivered with LiveView, and view the resulting tables with LiveView Desktop. Follow these steps:

1. Start StreamBase Studio in the SB Authoring perspective.

2. Load the Hello LiveView sample:

   1. Select File → Load StreamBase Sample from Studio's top-level menu.

   2. Enter `hello` in the filter field to narrow the selection.

   3. Select the sample whose description is `Shows a simple Hello World application` from the TIBCO LiveView category.

   4. Click OK.

   The Hello LiveView sample loads into Studio with the project name `sample_lv-helloliveview`. If you already have a project folder of that name, Studio adds a counter digit to the folder name and adds a new project.

3. In the Project Explorer view, select the name of the project, right-click, and from the context menu, select Run As → LiveView Project. The Console view shows several messages as the LiveView Server compiles the project and starts. This startup process can take several minutes, depending on the configuration of your computer.

4. When you see the message `All tables have been loaded` in the Console view, start LiveView Desktop with one of the following methods:

   - On Windows and Linux, if your StreamBase Studio sample project folder includes `Start LiveView Desktop` entries, then a Run Configuration entry was automatically added to Studio when you loaded the sample. In this case, the simplest way to start LiveView Desktop is to invoke Run → External Tools → Start LiveView Desktop (Hello Sample).

   - On macOS, only if LiveView Desktop is installed in the canonical location in `STREAMBASE_HOME/liveview/desktop`, you can invoke Run → External Tools → Start LiveView Desktop (Hello Sample) (macOS).

     Otherwise, use Spotlight or Launchpad to locate and invoke the app named `liveview.`

   - On Windows, you can also invoke Start → All Programs → TIBCO → Live Datamart `n.m` → LiveView Desktop `n.m`.

   - On Linux, you can also run the following command:

         /opt/tibco/sb-cep/n.m/liveview/desktop/liveview &

   Any of these methods opens the Connect to LiveView dialog.

5. In the Connect to LiveView dialog, select the radio button for Download and click Select.

6. Select the workspace named `Hello LiveView` and version `Latest`.

7. Click OK. This returns you to the Connect to LiveView dialog. The Download field now contains `Hello LiveView (Latest)`.

8. Click OK.

Open a view on a LiveView table by double-clicking its table name in the LiveView Tables view. When you double-click a table name, you issue a query to LiveView Server that returns the entire contents of the table. By default, LiveView Desktop opens a grid view on the table.

You can use the following features to modify the display of a grid view:

- Filter the display using a simple string match, discussed in Using LiveView Desktop Filters.

- Limit the number of rows a grid view can display, discussed in Setting Row Limits in LiveView Desktop.

- Apply cosmetic or alert formatting based on specified conditions in the incoming data, discussed in Conditional Formatting.

## Using LiveView Desktop Filters

LiveView Desktop's grid view allows you to filter data from a query. A filter allows you to enter a specific string and limit results to rows that match that string. Use a filter when you have a set of results that is too large to show in one page.

To open the table Filter field for a grid view, you can either:

- Click to select a grid view and press Ctrl+F.

- Click the View Menu button () on the right side of the grid view's toolbar, and select Show Table Filter.

In the Filter field, enter a string or substring to be matched against. If you enter an all-lowercase string, the filter matches case-insensitively. If you enter a mixed-case search string, the match is case-sensitive. For example, to limit the current table display to the rows that report book sales, type `book` into the Filter field. Notice that if you type `Book`, the filter does not match any rows.

The Filter field provides a simple substring match functionality, and is not designed to provide an exhaustive query mechanism. See Querying Your Data for ways to perform queries against tables.

## Setting Row Limits in LiveView Desktop

The row limit for query results allows a LiveView client to prevent the server from sending excessive data. The limit specifies the maximum number of rows that the server returns to the client. Without a row limit, an insufficiently restrictive query on a large table or a rapid-changing table might overwhelm the client with more data than it can process.

Regard the row limit feature as a mechanism to protect clients from an extraordinary data load or from incorrectly defined queries. Because query results are not updated once the row limit is reached, we recommend that users not run queries that consistently reach the row limit. (If a query does reach the row limit, you can use the Refresh option in LiveView Desktop to see recent updates.) Set row limits low enough that client processing capacity is not exceeded, and define query predicates to be restrictive enough that the row limit is never or rarely reached.

Changing the LiveView Desktop Default Query Row Limit

  In LiveView Desktop on Windows, invoke Window → Preferences; on macOS, invoke TIBCO LiveView Desktop → Preferences. Select TIBCO LiveView from the left-hand navigation panel. The Default Query row limit field is set to the default value of 2000. Increase or reduce this value as appropriate for your expected data set.

  This setting, like all LiveView Desktop Preference settings, is saved in your LiveView Desktop workspace, and persists across LiveView Desktop sessions if you restart Desktop and select the same workspace name.

Changing the Query Row Limit Per Table

  You can change the query row limit for individual tables. To do this, right-click the table name in the Tables pane and select Defaults → Query Row Limit.