We're updating the issue view to help you get more done. 

Wildcard searches

Description

From http://www.openvpms.org/project/wildcard-searches :

By default, OpenVPMS supports starts-with matching when performing queries, i.e. it will return all results that start with the entered text.

To match everything containing the entered text, the user must remember to prefix it with a wildcard (* or %).

In general, starts-with queries are faster than contains queries as they can make better use of database indexes.

This project will make contains matching the default for queries that won't adversely affect performance.

This will apply to the following archetypes:

  • products

  • suppliers

  • organisational archetypes (i.e. everything found in Administration - Organisation)

  • document templates

  • lookups

  • types (i.e. everything found in Administration - Types)

  • HL7 services and connectors (i.e. everything in Administration - HL7)

  • archetype descriptors (i.e. everything in Administration - Archetypes)

  • user groups

  • users

  • roles

Configuration

The contains search will be enabled by configuring a flag within the QueryFactory.properties file for each of the relevant archetypes e.g.:

  • product.* org.openvpms.web.component.im.product.ProductQuery,contains=true

This will default to false if not specified.

Environment

None

Status

Assignee

Tim Anderson

Reporter

Tim Anderson

Labels

None

Time Tracking

8h

Components

Fix versions

Priority

Minor