[Project Service] 500 server error while searching a project name with special characters

[codejamtc]

Expected behavior

Should not display a server error

Actual behavior

500 server error while searching a project name with special characters

main.22d51792a5c88e848e51.js:130 GET https://api.topcoder-dev.com/v5/projects/?fields=id,name,description,members,invites,status,type,actualPrice,estimatedPrice,createdAt,updatedAt,createdBy,updatedBy,details,lastActivityAt,lastActivityUserId,version,templateId&sort=lastActivityAt+desc&perPage=20&page=1&name=*Ticket-3809%7Bcodejam%7D+Edited* 400
(anonymous) @ main.22d51792a5c88e848e51.js:130
e.exports @ main.22d51792a5c88e848e51.js:130
Promise.then (async)
e.exports @ main.22d51792a5c88e848e51.js:223
Promise.then (async)
c.request @ main.22d51792a5c88e848e51.js:223
c.<computed> @ main.22d51792a5c88e848e51.js:223
(anonymous) @ main.22d51792a5c88e848e51.js:130
t.getProjects @ main.22d51792a5c88e848e51.js:162
(anonymous) @ main.22d51792a5c88e848e51.js:28
t @ main.22d51792a5c88e848e51.js:17
f @ main.22d51792a5c88e848e51.js:28
(anonymous) @ main.22d51792a5c88e848e51.js:28
(anonymous) @ main.22d51792a5c88e848e51.js:192
(anonymous) @ main.22d51792a5c88e848e51.js:223
(anonymous) @ main.22d51792a5c88e848e51.js:192
value @ main.22d51792a5c88e848e51.js:223
value @ main.22d51792a5c88e848e51.js:282
b @ main.22d51792a5c88e848e51.js:28
C @ main.22d51792a5c88e848e51.js:28
_ @ main.22d51792a5c88e848e51.js:28
setTimeout (async)
(anonymous) @ main.22d51792a5c88e848e51.js:28
w @ main.22d51792a5c88e848e51.js:28
(anonymous) @ main.22d51792a5c88e848e51.js:282
e.notifyAll @ main.22d51792a5c88e848e51.js:130
close @ main.22d51792a5c88e848e51.js:28
closeAll @ main.22d51792a5c88e848e51.js:28
perform @ main.22d51792a5c88e848e51.js:28
perform @ main.22d51792a5c88e848e51.js:28
_ @ main.22d51792a5c88e848e51.js:28
closeAll @ main.22d51792a5c88e848e51.js:28
perform @ main.22d51792a5c88e848e51.js:28
batchedUpdates @ main.22d51792a5c88e848e51.js:192
batchedUpdates @ main.22d51792a5c88e848e51.js:28
dispatchEvent @ main.22d51792a5c88e848e51.js:192
main.22d51792a5c88e848e51.js:130 Uncaught (in promise) Error: Request failed with status code 400
    at e.exports (main.22d51792a5c88e848e51.js:130)
    at e.exports (main.22d51792a5c88e848e51.js:223)
    at XMLHttpRequest.f.<computed> (main.22d51792a5c88e848e51.js:130)

Steps to reproduce the problem

• Login as Manager
• Create a project with the name="Ticket-3809{codejam} Edited" if not available
• Go to Project listing page > Filter with the project name column="Ticket-3809{codejam} Edited" (Paste the name)

Screenshot/screencast

https://monosnap.com/file/5QQnVlzqceTqwItHHrgFZlaHVab895

Environment

• OS: Window 10
• Browser (w/version): Chrome 80.0.3987.163
• User role (client, copilot or manager): Manager
• Account used: TCConManager

[maxceem]

• This should be fixed in the Project Service https://github.com/topcoder-platform/tc-project-service
• The fix in Project Service should also support requirements in this issue https://github.com/topcoder-platform/tc-project-service/issues/572 and in this issue https://github.com/appirio-tech/connect-app/issues/3865
• So this issue has to be fixed in general for all the search fields: keyword, name, code - search shouldn't get broken if we use some special characters. But we should still support wildcard search with * where we support it now.
• Create unit tests to fully verify that fixes work for all the fields:
  • search good without wildcards but with special characters
  • search good with wildcards * and together with special characters