| Subject: | Syntax error is logged when searching Helpdesk cases with spaces between words, e.g. 'additional fields AND edit'. |
| Summary: | A syntax error is logged when searching Helpdesk cases with spaces between words, e.g. 'additional fields AND edit'. |
| Audit Notes: | Edited by sanjay on 07/10/21 14:10. Edited by sanjay on 07/10/21 13:54. Edited by sanjay on 28/09/21 16:24. |
| 28 Sep 2021 | 03:58PM Comment 1 by Sanjay (Link Technologies) Case L12592 added to project 13.04 |
| 28 Sep 2021 | 04:23PM Comment 2 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 30-09-2021 04:20 PM Time Taken: 4.00 |
| PART A - Development work for this case has been completed. 1. The change will be available in version:13.04.0928 2. The following changes were made(Include Database object names, Program classes, and any other relevant information): - Corrected Full-Text Search filter to clean up the search criteria
3. Affected Areas: - Full-Text Seach using search criteria where there are multiple words involved. e.g. Search for: "Additional Fields AND EDIT" raises an Error in the log. This issue has been corrected.
4. The issue was caused by: - Full-Text Search Syntax Error
5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT
|
|
| 30 Sep 2021 | 12:48PM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 06-10-2021 12:46 PM Time Taken: 1.00 |
|
The following tests were performed:
Table 1 - Test Results
| # | Test Case Details | Pass/Fail | Comments | | 1 | - Search for "additional fields AND edit" under "View All Calls".
- Validate that there is no syntax errors in the database
| Pass | |
Environment Details - OS version:
- Application version:13.03.0930RC1
- Setup on:
- Server:LinkQA4
- Database: UAT-LINKSOFT
- LinkSOFT URL: HTTP://10.0.0.13/LINKSOFT
- Login Details: Standard username and password for user "admin"
Next Step: Closure
|
|
| 05 Oct 2021 | 04:50PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 07-10-2021 04:50 PM |
| Completed Testing |
|
| 07 Oct 2021 | 01:54PM Comment 5 by Sanjay (Link Technologies) ETC was changed from 30/09/2021 to 30/09/2021 |