250391

From CTMS

250391-PA-7DGNZZ Remove Case Sensitive Searches

Copyright OBS Logistics © 2007

The information contained herein is the property of OBS Logistics and is supplied without liability for errors or omissions. No part may be reproduced or used except as authorised by contract or other written permission. The copyright and foregoing restriction on reproduction and use extend to all media in which the information may be embodied


FUNCTIONAL OVERVIEW

Client Requirement

Searches being carried out in Maintenance/Locations, are case sensitive in all fields, meaning that a search may fail due to this when the Location does however exist in another case format. Can lead to unnecessary addition and Duplication of an existing Location ID. Added by PA: Should be applied to all fields of the LOCATIONS form which are capable of being 'searched' using the search buttons.



Solution

Users will be able to query a specified field and retrieve all relevant records regardless of the case the query text has been entered in. This will be achieved by amending the property palette functionality available for each field.


The changes will be applied to the Locations form, specifically the following fields :

Location id Location Name Route Code Postal Region Planning Region

Address Line 1 Address Line 2 Address Line 3 Town County PostCode



Scope

This change will be applied to system version MTS V10.5.0 on CONTST and once approved CONPRD. The Locations form will be updated to version 2_48


FUNCTIONAL DESCRIPTION

All searchable fields within the Locations screen and specifically the address tab will no longer be limited to case sensitive searches.

Entering search text in lowercase will also return Upper case matches and similarly, entering uppercase search text will also return lowercase matches.

IMAGE


The above screenshot shows the fields which will have the case sensitivity removed.


IMAGE


References

IMAGE


Glossary

IMAGE



Document History

IMAGE



Authorised By

Dave Meir Development Manager
Suk Sandhu TMSCC MTS Product Manager