Sending Filter and Order Expressions to a Page

If you want to send multiple arguments to a page, you must separate them with "&" characters. This example duplicates and modifies the Pick_a_Customer page to create the Apply_Filter_and_Order page.

Creating the Apply_Filter_and_Order Web Component

  1. Display the Web Project Control Panel.

  2. Select and right click the "Pick_a_Customer" web component.

  3. Select Duplicate. Enter "Apply_Filter_and_Order" and click Duplicate.

  4. Select and right click the "Pick_a_Customer" A5W page.

  5. Select Duplicate. Enter "Apply_Filter_and_Order" and click Duplicate.

  6. Select the "Apply_Filter_and_Order" web component and click Edit.

  7. Display the Grid Fields page.

  8. Select "<Logicalrecno>" in the Selected Fields list.

  9. In the Link Properties > Link Address field click to display the Link Address Builder.

  10. Enter the following Link Address and click OK.

Customers.a5w?Customers_Filter=lastname > "{lastname}"&Customers_Order="lastname + firstname"

Note : Remove the space characters from the finished URL.

  1. Click Save and Close.

Creating the Apply_Filter_and_Order Page

The first step in creating the new page is to remove the previous component.

  1. Display the Web Project Control Panel.

  2. Edit the "Apply_Filter_and_Order" page.

  3. Display the WYSIWYG tab of the HTML Editor.

  4. Select the components on the page and click Delete.

  5. Click and Yes.

  6. Place the cursor where you want to insert the new grid component and click Insert Component.

  7. Click Select to display the Select Component dialog.

  8. Select the "Apply_Filter_and_Order" web component and click OK.

  9. Click OK, then save and close the HTML Editor.

  10. In the Web Project Control Panel. right click on the "Apply_Filter_and_Order" page and select Publish (Local Webroot) and open.

  11. Click on the triangle next to any entry. The Customers page will display all those records where the lastname value is greater than the one you selected. The records will be ordered by lastname, then by firstname.

See Also

Contents, Opening a Page with a Grid Component and Showing Selected Records, A5W Page Link, Filter, and Order Syntax

Supported By

Alpha Five Version 6 and Above