How to do WildCards

building reports webintelligence
1

Hello All,

I want to achieve this request:

Need a report that would work in a manner similar to Customer Search, but based upon addresses.

1)Able to use wild cards in case of misspellings
2)Be non-case sensitive in the search field
3)List the matches the same as Customer Search.

FYI, I have Addresses object.

Thanks for your help.

Pooja

ktm :us: (BOB member since 2008-11-12)

2

What is Customer Search?

Look at the Upper() and Match() functions.

Nick Daniels :uk: (BOB member since 2002-08-15)

3

Hello Nick,
Thanks for your reply.I drop the address object into the Query filter and make Address Match pattern"Enter Address" as prompt.

Is this the way to do?How can i use the Upper() function.

Basically they want prompt which allow them to fetch the data based upon their inputs.

Thanks
Pooja

ktm :us: (BOB member since 2008-11-12)

4

Pooja,

I think you will have to create a condition in the universe roughly like below:-

ucase(Address_object) = ucase(@prompt(‘Enter the address:’))

Note - ucase is for oracle

Cheers.

BO_Stuffed (BOB member since 2008-03-29)