Order Form Sample–Part 24

Labels
AJAX(112) App Studio(7) Apple(1) Application Builder(245) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(177) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(18) OAuth(9) OAuth Scopes(1) OAuth2(13) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(11) PKCE(2) Postgre SQL(1) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(183) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(81) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Archive
Blog
Tuesday, October 30, 2012PrintSubscribe
Order Form Sample–Part 24

Currently, the new fields Total and Subtotal do not allow sorting or filtering. You can see this on the grid of Order Form – the Total column does not have a dropdown available, and the field is not displayed as an option in the advanced search bar.

'Total' field in Order Form is not searchable or filterable.

Let’s enable sorting and filtering for these two fields. Switch back to the Project Explorer, and double-click on Orders / Fields / Subtotal* (Currency, read-only).

Subtotal field in the Orders controller of the Project Explorer.

Change the following settings:

Property New Value
Allow Query-by-Example true
Allow Sorting true

Press OK to save the field. Now, double-click on Total field node.

Total field in the Orders controller of the Project Explorer.

Make the same changes:

Property New Value
Allow Query-by-Example true
Allow Sorting true

Save the field, and regenerate the application. On the Order Form page, you can see that the Subtotal and Total fields are now available as options on the advanced search bar.

Subtotal and Total available as options on the advanced search bar.

Both columns also have sorting and filtering options available on the column header dropdown.

Subtotal and Total column header dropdowns are now enabled.