Powerful Search Capabilities - A Standard Feature of Basix:Platform®

01 July 2007

A range of native database searching capabilities are built into Basix:Platform® and therefore available for every business application built on this platform. This means that your valuable business data is available on screen for any purpose and the end-user has the power to review, analyse, edit and export business data like never before (subject to security privileges).

As standard feature of Basix:Platform®, EMS has provided 3 search facilities for the end-user as well as powerful filtering, sorting and grouping capabilities within the Basix™ data grid or Gridview.

Simple Query by Form facility:

Firstly, a "Query By Form" facility built into every Basix™ form allows users to simply type in or select criteria from dropdown lists on any screen field on the form. A user can then press ENTER and will immediately see all the matching data records and related child items returned from the database. Depending on your Servers and client PCs, you could typically expect to see 100,000 records returned in to the Basix™ card view form or grid view within a few seconds. These records are then available for review, edit, export, print etc or they can be further refined, grouped, filtered, graphed or mapped using the powerful in-built capabilities of the Basix™ data grid or Gridview.

Advanced Searching:

A more advanced or complex searching capability is offered on the Basix™ data grid or Gridview and this is available on every form. The built-in filtering capabilities of this grid have been leveraged to provide an advanced search facility as shown below.

This advanced search capability would be used by end-users where complex AND/OR options are required and multi-level nesting of condition, complex operators (see example above). This Advanced Search feature includes automatic drop-down list (where appropriate) to simplify creation of the advanced search criteria. The Search runs on the click of a button and returns all matching records into the Cardview or Gridview form.

Saved Searches:

Query by Form or Advanced searches may be stored in the database as either public or private "Saved Searches" using a button on the Basix:Platform® User Interface. This means that your end-users can setup and run their own Saved Searches to retrieve any data or the System Administrator can set up "Public" saved searches for everyone to use. This means that end-users can access data that is relevant to only them and their job very quickly by double clicking a saved search icon within the list of Saved Searches. An example would be the purchasing officer creating a saved search to show all outstanding purchase orders that have not yet been filled. This report could be run regularly and avoids the need to enter criteria for each search.