Adding Checkboxes to a List View

Previous Next

See Also

You can add checkboxes to a list view by adding an additional column to the queries of list view nodes. The additional column must have the "LIST_STATE" alias. For example:

SELECT    p.first_name||' '||p.last_name, DECODE(p.GENDER, 'M', 'Y', 'N') "LIST_STATE"

FROM      person p

ORDER BY  p.last_name

Once the TREE_STATE column has been added to the SQL query for the node, a checkbox is displayed for the node. Possible values and corresponding states for the checkbox are:

Value

Checkbox State

NULL

No checkbox (TREE_STATE column not in query)

N

Y

 

When a checkbox is displayed for an item, the user can change the state of the checkbox by using the mouse or the space bar. The states will toggle between N and Y.

For each checkbox you can specify an action that is to be executed when the checkbox state changes. You can do this using the CheckBox Action property available in the Windows Designer Property Inspector for the List View Node in question.