[HOLD for payment 2024-08-29] [$250] [Search v2.1] Update search parser grammar to handle special characters

[luacmartins]

Problem

Coming from here, the search parser grammar doesn't handle some special characters very well, for example it throws an error when ; is added to a text input like keyword

Solution

Update the parser grammar to correctly handle special characters:

; should be treated like any other character
(whitespace) should be a logic AND operator when separating filter keys, e.g. amount:200 category:travel means amount=200 AND category=travel. It should also be a logical OR when separating free text, e.g. las vegas means keyword=las OR keyword=vegas
, is used as a logical OR operator when separating values for a filter key, e.g. category:travel,hotel,food means category=travel OR category=hotel OR category=food. It should also be treated as a regular character when used in free text, e.g. las, vegas means keyword="las," OR keyword="vegas"

cc @Kicu @adamgrzybowski @289Adam289 @Guccio163 @SzymczakJ

Upwork Automation - Do Not Edit

• Upwork Job URL: https://www.upwork.com/jobs/~01cfdc085a6131060b
• Upwork Job ID: 1821628463273416803
• Last Price Increase: 2024-08-08
• Automatic offers:
• ikevin127 | Reviewer | 103492420

Issue Owner

Current Issue Owner: @

Issue Owner

Current Issue Owner: @slafortune

[melvin-bot]

Triggered auto assignment to @slafortune (NewFeature), see https://stackoverflowteams.com/c/expensify/questions/14418#:~:text=BugZero%20process%20steps%20for%20feature%20requests for more details. Please add this Feature request to a GH project, as outlined in the SO.

[melvin-bot]

Job added to Upwork: https://www.upwork.com/jobs/~01cfdc085a6131060b