[Organizations-contact info] The 'Organization accounting code' value contains incorrect '\'(backslash) in the query

Description

ENV: Snapshot.

PRE-CONDITION:

  • The list with ‘Organizations — contact info’ entity type is created

  • Query builder is opened.

STEPS.

  1. Select “Organization accounting code” in the ‘Field’ dropdown.

  2. Select e.g ‘starts with' operator (or 'contains’)

  3. Add value e.g ‘G64758-7483’

  4. Click on ‘Test query’

  5. Click ‘Run query & save’.

ACTUAL RESULT: Opens list’s details page, displays the following query:

Query: (accounting_code starts with G64758\-7483)

When we edit the list, and try to run the same query it will return 0 result, as the query is already incorrect due to the backslash sign in the value.

 

NOTE:

  • The problem is actual for the following fields “Organization code”, “Organization name” with ‘starts with’ operator.

  • The same issue is actual for ‘Organizations — vendor info’ entity type

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

17

Checklist

hide

Activity

Show:

Emma_Haroyan November 18, 2024 at 9:48 AM

Tested on Eureka and OKAPI bugfest env.

Works as expected.

Kathleen Moore November 8, 2024 at 4:36 PM

confirmed all is working as expected on snapshot

Emma_Haroyan November 8, 2024 at 12:46 PM

Tested on Snapshot.

All works as expeced.

Vadym Shchekotilin November 8, 2024 at 8:29 AM

Dev verification:

could you please double check?

Emma_Haroyan November 4, 2024 at 9:42 AM

Note for next time testing.

Instance has such title “Emma's weird test /// ** symbols )))” .

  1. Run such a query “Instance.title contains instance_title”.

  2. Try to modify the query, click on “Actions → Edit lists”

Make sure that this error won’t appear

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Firebird

Fix versions

Release

Ramsons (R2 2024) Bug Fix

RCA Group

Implementation coding issue

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created March 21, 2024 at 7:17 AM
Updated November 18, 2024 at 9:51 AM
Resolved November 8, 2024 at 4:36 PM
TestRail: Cases
TestRail: Runs