Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Saved Query on window return no record

Description

saved query on window save value as upper case and result no record

how to reproduce :

  1. open window business partner

  2. input “joe” in search key field and press enter or click ok button

  3. the result is 1 record for JoeBlack record

  4. open search window and save query

  5. on advance tab, it will show search on search key with operator Like and value ‘JOE%’

  6. click lookup record and clear search key field

  7. select the saved query on top left

  8. the result is “no record” instead show 1 record

Environment

None

Activity

Show:

Carlos Ruiz February 27, 2025 at 8:43 PM

Thanks - nice work with this ticket.

Now is just pending to create an NF13 wiki page to explain the new find operator.

zuhri utama February 27, 2025 at 7:40 AM

hi . Thx for the feedback. I fixed the bug.

Carlos Ruiz February 26, 2025 at 4:12 PM

Hi - I tested successfully the new operator.

But I found a different problem now, I cannot save the “Like (Ignore Case)”

The test case goes like this:

  • open Business Partner window

  • in Find dialog switch to Advanced tab

  • Fill

    • Field = Name

    • Operator = Like (Ignore Case)

    • Query Value = c%

  • Save

    • ERROR → when saved the operator changes to Like

Carlos Ruiz February 25, 2025 at 8:26 AM

Hi - I didn’t add a patch, just tested your pull request on oracle.

zuhri utama February 25, 2025 at 12:40 AM

hi , can you share your patch that u tested? I can’t find where to put the function upper on code. It’s better using your tested code. thx

Fixed

Details

Assignee

Reporter

Labels

Fix versions

Priority

Created January 10, 2025 at 9:34 AM
Updated 4 days ago
Resolved February 27, 2025 at 8:42 PM