- Search Options Properties
/pages/Guides/Mobile and Web Components/Grid/The Search Part/Search Properties/SearchOptions.xml
Search Options Properties
- Defining a Quick Search
/pages/Guides/Mobile and Web Components/Grid/Grid Properties/Quick Search/Defining a Quick Search.xml
The Quick Search feature allows you to make a search control part of a grid.
- Grid Component SQL Database Credentials
/pages/Server/Guide/Design/View/Grid/Grid Component/Grid Component SQL Database Credentials.xml
By default all users who use a Grid component connect to the SQL database using the same credentials. These credentials are defined in the a5_application.a5i file which is automatically published when your application is published. The a5_application.a5i file defines how each named connection string in your application should be resolved at runtime.
- Open a Grid component
Opens a grid component in a pop-up window, or in a DIV on the current page.
This requires first defining a grid component.
- Ordering Lookup Entries - Grid Component
/pages/Server/Guide/Design/View/Grid/Ordering Lookup Entries - Grid Component.xml
Often you will want to display a list of values selected from a table. It is often desirable to specifically order these entries, instead of allowing them to display in record order or alphabetically.
Here is a technique for solving this problem. This example uses a drop down list box on a dialog component, but the technique works equally well with a list box on a grid component.
- Opening a Page with a Grid Component and Showing Selected Records
/pages/Server/Guide/Design/View/Grid/Opening a Page with a Grid Component and Showing Selected Records.xml
A common requirement when building a grid is to have a hyperlink field in the grid that, when clicked, will open a second page. The second page contains a grid that is filtered based on parameters from the first page. These examples show how to do this.
The URL that opens the second page has query parameters that contain one or more of the _filter, _order, and _link keywords. These keywords allow you to specify a filter, order and/or linking parameters for the grid in the target page.
- Grid Component - SQL Database Errors
/pages/Server/Guide/Design/View/Grid/Grid Component/Grid Component SQL Database Errors.xml
You can now customize the text that is displayed when the SQL Database reports an Insert, Update or Delete error.
By default, Alpha Anywhere displays this text for an Update, Delete or Insert Error:
- Search Properties
/pages/Guides/Mobile and Web Components/TabbedUI/Tabbed UI Properties/Search/index.xml
If a TabbedUI component has a large number of items, it can be difficult for a user to find the item that they want. The search feature allow users to quickly find the items in the Tabbed UI interface. As the user types into the search box a filtered list of the matching items is displayed.
- Setting Filter and Order Criteria
/pages/Guides/Desktop/Design/View/Browse/Setting Filter and Order Criteria.xml
You can pre-determine the order and selection of records that appear in a browse by saving filter/order criteria. When the browse is opened, the saved query is automatically run and record order and selection is determined by the saved order expression.
The Filter Expression requires that the Lastname field contain the letter "a". The Order Expression orders the records on the Lastname field:
- Quick Search label style
/pages/Guides/Mobile and Web Components/Grid/Grid Properties/Quick Search/Quick Search label style.xml
Overrides the style for the Quick Search lable. Click [...] to define the In-line style. Refer to the Style Editor for details.