Opening a Lookup Window in Search Mode

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, April 16, 2012PrintSubscribe
Opening a Lookup Window in Search Mode

Lookup windows can display the first page of data, or present search options instead upon activation.

In a sample Northwind application, navigate to Orders page. On the action bar, press New Orders. Click the (select) link in the first data field, Customer Company Name.

Customer Company Name lookup link on New Orders form

The lookup window will show the first page of data rows. The default page size is ten.

Default Customer ID lookup window in Code On Time web application

A user can perform Quick Find or activate the advanced search bar to narrow down the list of available data rows.

Advanced search bar in the lookup window

Let’s activate the search mode immediately when the lookup window is displayed for the first time. This will be useful if the number of lookup records is large. The display of the first page of data has little use in such cases.

Start Code On Time web application generator, click on the project name, and select Design. In the Project Explorer, switch to Controllers tab. Double-click on Orders / Fields / CustomerID node.

Scroll down to the Lookup section. Toggle the checkbox next to Search On Start property.

'Search On Start' property enabled for CustomerID field in Code On Time Designer

Press OK to save the field. On the tool bar, press Browse to generate the application and open it in your default web browser.

Navigate to the Orders page, and create a new order. Activate the Customer Company Name lookup, and you will see the lookup window open in advanced search mode.

Lookup window opened in advanced search mode

Enter the search parameters and press Search to find a record. Alternatively, you can just press the Search button without entering any search parameters, and a full list of customers will appear.

List of records pulled in Customer ID lookup window