Skip to main content
Solved

Aurena Lobby "Like" Filter


lopespetro
Hero (Customer)
Forum|alt.badge.img+13

How All.

How could I set up a parameter in Aurena Lobby to understand “Like” where condition with % so I will be able to type a part of the text.

In the example bellow, if I use like condition with %, the element in Aurena doesn’t not work, just in IEE. IF I remove the %, it works fine.

Is it possible?

Tks a lot!

this way works without %.

 

In Aurena Lobby does not with %

UPPER(ITEM_DESCRIPTION) LIKE NVL(UPPER('%$CPF_NOME$%'),'%')

 

 

Best answer by Tomas Ruderfelt

If there is a problem with % in your version maybe try this:

UPPER(ITEM_DESCRIPTION) LIKE UPPER(CHR(37) || '$CPF_NOME$' || CHR(37))

 

CHR function gives you character “%” if you use number 37. You can find the ascii number of a character by doing:

SELECT ASCII('%')

FROM dual

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+20
  • Superhero (Employee)
  • 492 replies
  • Answer
  • June 7, 2022

If there is a problem with % in your version maybe try this:

UPPER(ITEM_DESCRIPTION) LIKE UPPER(CHR(37) || '$CPF_NOME$' || CHR(37))

 

CHR function gives you character “%” if you use number 37. You can find the ascii number of a character by doing:

SELECT ASCII('%')

FROM dual


lopespetro
Hero (Customer)
Forum|alt.badge.img+13
  • Author
  • Hero (Customer)
  • 278 replies
  • June 7, 2022
Tomas Ruderfelt wrote:

If there is a problem with % in your version maybe try this:

UPPER(ITEM_DESCRIPTION) LIKE UPPER(CHR(37) || '$CPF_NOME$' || CHR(37))

 

CHR function gives you character “%” if you use number 37. You can find the ascii number of a character by doing:

SELECT ASCII('%')

FROM dual

Hi @Tomas Ruderfelt , it worked fine!

Tks a lot for attention and help!

Br.

Lopes


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings