- Creating a Grid Component - Tutorial
/pages/Guides/Mobile and Web Components/Grid/Introducing the Grid Builder/Tutorials/Creating a Grid Component - Tutorial.xml
Covers a range of topics including selecting a database, creating a grid component, selecting data to use and display in the component, and how to view the component in a browser.
- Filtering a Grid with Quick Search
/pages/Guides/Mobile and Web Components/Grid/Grid Properties/Quick Search/Filtering a Grid with Quick Search.xml
Quick Searchis an option for a grid component that allows you to quickly filter and re-display its contents.
To add Quick Search to 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.
- Dialog Component - Power Search for Embedded Report
/pages/Server/Guide/Design/View/Component/Dialog Component - Power Search for Embedded Report.xml
Requires the Power Search for Reports Embedded in Dialog Components feature pack, included in subscription
The Dialog Component can be used to create a 'Search Part' for a Report so that the end-user can enter search ctieria to define exactly which records to display in the report.
How it works
- 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.
- 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:
- Hide Grid part when Detail View is visible
/pages/Guides/Mobile and Web Components/Grid/The Detail View/Detail View Properties/Display Options/hidegridpartwhendetailviewisvisible.xml
Hide the Grid part when the Detail View is visible. (Checking this option will increase the speed of the page because the Grid part will not have to be computed.)
- Grid Component - Checkbox Column - Custom Ajax Callbacks
/pages/Server/Guide/Design/View/Grid/Grid Component/Grid Component Checkbox Column, Custom Ajax Callbacks.xml
When you do a custom Ajax callback, the 'e' object that is passed into your Xbasic function that handles the callback contains a lot of useful information. Now, the 'e' object contains 3 additional properties that are automatically set if the grid has a checkbox column. The properties are:
- Grid, Tabbed UI and Page Layout Builder - Search for Property
/pages/Server/Guide/Design/View/Grid/Grid, Tabbed UI and Page Layout Builder Search for Property.xml
A new feature has been added to these builders that allows you to search for a property in the Grid. This makes it very easy to find a particular property that you want to edit.
A 'search' hyperlink is visible above each Property Grid and when you click the hyperlink, a window open. As you type in the search box, the list is filtered. Double click or press enter to give focus to the selected property.
- Grid Component Builder - Setting Default Properties
/pages/Server/Guide/Design/View/Grid/Grid Component/Grid Component Builder Setting Default Properties.xml
The Options, Set Default Properties command in the Grid Builder has always allowed you to set default properties for the Grid when you create a new Grid. However, if you created a new Grid from a Template, the default properties that you set were not honored. They were only honored if you created a blank new grid. Now, the default properties are used even if you use a template. This makes it much easier to customize the Grid builder for developers whose native language is not English.