Learn how to filter records in a Grid component based on the currently logged in user using the "USERID" field from the Extended User Information table.

Arguments can be defined for a Page Layout Component which can be used in server-side show/hide expressions as well as filtering Grid Components and Reports.

Search and/or sort records in a List Control based on a SQL or DBF data source.

Inserts a static text control that shows debugging information for a List control (such as page number, count, sort, filter).

The List control has methods that allow you to refresh the data or filter the data.

Gets a list of fields in the Extended User Information Table.

An interface for editing existing users in the Web Security Framework can be created using the UX Component.

This example shows how to use check boxes in a grid to select records to print. In this case the example prints labels, but the technique is applicable to selecting records for any process. This example passes the selected list of Customer_IDs to a second page named PrintLabel.a5w. It prints the appropriate records using the CustomerLabels label layout or Letter to Customers letter layout of the AlphaSports customer table.

If a List control is based on a SQL statement that uses the GROUP BY clause and the UX contains a button to filter the list, if a filter is defined on any of the summary fields in the SQL statement, an appropriate HAVING clause will be generated.