- Controlling Which Columns Display

WOW allows you to control which fields display on both a multi record result screen and a single record detail screen. The Properties field allows you to configure your operations in various ways. The screen shot below shows where the Properties field is located in the "Creating Operations" screen:

Within the properties field are different property groups. These groups are used to change the look and feel of the tables and data selected by the SQL statement. For instance, a few of the different property groups available are DisplayColumns, DetailDisplay, and TableDisplay. The properties of each group will be listed between curly brackets {}. For each property, the name of the property is followed by a colon and then the value (or comma separated list of values), and finally by a semicolon.

Below is a example of of the results screen you see when your properties are set as follows

DisplayColumns{ results:*; details:*; }

When a single entry (row) is displayed, (row details are what the user sees when they insert a new row into the results, or when they select a row from the list of rows in the results. Below is a example of the detail screen for a selected row:

TableDisplay {}

There are many properties in the TableDisplay group. Most of them are all boolean values, unless specified otherwise (ex. selectionType and cellPadding). Boolean means they are either set to "true" or "false." If a property is set to true, the feature it controls will be visible to the user. If the property is set to false, the feature it controls will not be available to the user. The screen below will be used to demonstrate which icons will appear and disappear according to the boolean values. The TableDisplay Property Groups are found at the bottom of the WOW Builder Property Groups as seen here:

DisplayColumns {}

There are two properties in the DisplayColumns group, results and details. An asterisk can be used as a value to display all data. In all the properties of this group, the values 'ALL' and 'NONE' may be used.

If you do not want the user to see all the columns in the results screen or only some details about a line item then the property group might look like the example below.

DisplayColumns{ results:PRODUCTCODE, PRODUCTNAME, PRODUCTLINE,

PRODUCTSCALE;details:PRODUCTCODE,PRODUCTSCALE,PRODUCTNAME; }

In this case the results screen would show you only the product code, product name, product line and product scale. And when a row is selected the only details that would be seen by the user would be the product code, product scale and product name as shown below:

Results screen:

Below is the detail screen for the selected row with the property group set as shown above: