250391: Difference between revisions
(New page: = 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 fo...) |
|||
| Line 110: | Line 110: | ||
== Authorised By == | == Authorised By == | ||
{| border="1" | |||
| '''''Dave Meir''''' | |||
| Development Manager | |||
|- | |||
| '''Suk Sandhu''' | |||
| TMSCC MTS Product Manager | |||
|} | |||
Revision as of 14:31, 4 February 2009
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
SET-UP
Pre-requisites
None
Menu Structure
Unchanged
Data
No data changes – changes are functional.
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.
APPENDIX A TABLE UPDATES REQUIRED
No table changes are required for this development
APPENDIX B QUOTE & DOCUMENT HISTORY
IMAGE
References
IMAGE
Glossary
IMAGE
Document History
IMAGE
Authorised By
| Dave Meir | Development Manager |
| Suk Sandhu | TMSCC MTS Product Manager |
