Matches pattern/Different from pattern with underscores doesn't work

[Former Member]

This is the query i have used.

REPLACE (upper (TICKET.ORG_GROUP), '_', '#') LIKE REPLACE (upper(@Prompt('Enter Org Group in upper case - use % as a wildcard or ALL for any value:','C',,Mono,FREE) || '%'), '_', '#') OR ('ALL') IN @Prompt('Enter Org Group in upper case - use % as a wildcard or ALL for any value:','C',,mono,FREE)

requirement should be: 1)If the user enter the value EV_ value should be EV_

2)if the user enter EV_% mean then value should be EV_123,EV_RM,etc

3)if the user enter the %EV_ mean then value should be RVEV_,123EV_ etc

4)if the user enter the %EV_% mean then all value that contain 'EV_'should come.

now (if the user enter the %EV_ mean then value should be RVEV_,123EV_)

this one is not working only EV_ is coming.

i dont know how can fix this issue,

But it currently provides:

EV_xxxx

LVEV_xxx

123EV_xxxx

Etc

Which is what I would expect with %EV_%.

I also need EV% to provide:

EV_xxxx

As well as...

EVxxx

can you plz give me other query or how can i fix

[Former Member · Accepted solution]

Hi Saravananplus,

I think your explanation is a little too convoluted. This could be why you have no responses yet! I mean, the problem is either Universe Designer is not interpreting your syntax correctly, or the syntax you are using is not correct. I have found that 99% of the time, my syntax was not correct.

How to correct it? Good question. You need to try pieces of the code individually to see if they work. And then combine them.

If there is someone who is very familiar with writing syntax for Universe objects, please offer your advise!

I have read this at least three times, and still do not know the solution. Although I admit, it is probably some minor syntax error!

Thanks

[Former Member · Accepted solution]

I believe that this post was supposed to be part of this topic:

It might make more sense if you read that first.