Data Field Search Options

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
Monday, June 4, 2012PrintSubscribe
Data Field Search Options

The Advanced Search Bar automatically determines multiple search options for each search field, based on the type of the field.

Advanced Search Bar with search options dropdown activated for a date field.

It is possible to limit the amount of options displayed to the user.

Let’s require users to search by the Birth Date field on the Employees grid view, and only permit between, equals, and includes search options.

Start the Project Designer. In the Project Explorer, switch to Controllers tab, and double-click on Employees / Views / grid1 / BirthDate data field node.

Birthdate data field of grid1 view in the Employees controller.

Make the following changes:

Property New Value
Search Mode Required
Search Options
$between,=,$in

Press OK to save the data field. On the toolbar, click Browse to regenerate the web application.

Navigate to the Employees page, and expand the advanced search bar.

Birth Date search field showing search options of 'between', 'equals', 'includes', and 'does not include'.

The Birth Date search field will appear first, with a limited subset of search options. The first search option will be activated when the search bar is opened for the first time.

For the Last Name field, instead of having the default first search option of equals, let’s change it to begins with, and preserve the rest of the search options.

Go back to the Project Designer. In the Project Explorer, double-click on Employees / Views / grid1 / LastName data field node.

Last Name data field of grid1 view in Employees controller.

Make the following changes:

Property New Value
Search Mode Suggested
Search Options
$beginswith,*

Press OK to save the data field, and click Browse on the toolbar.

Activate the search bar on the Employees page, and you will see that Last Name shows up by default. The begins with search option will show up first, but the user can change it to any other option.

Last Name search field showing search option 'begins with' first.