on 10-10-2017 3:58 PM
Hopefully someone can provide me with a little clarity , i've spent hours trying to find an answer and doing a little trial and error.
Basically i want to create a condition in the universe that can be plonked in the query filters in webi. This condition would bring up a prompt for a text string to be entered by the user. that captured user input would then have '%' wildcards on either end when passed back for a free text field to be searched.
e.g.
tab1.col1 like @prompt('Enter search text',A','%'+'class\obj'+'%',,)
The field is a free text field that i want users to be able to search for matching text.
so if they type 'Lion' in the prompt
they'd see entries that simply said 'Lion' and entries where 'Lion' was in the middle of a longer text string.
if there's a method of doing this in webi using the object and some clever manipulation of 'matches pattern', i'd be happy to try that instead but whatever i try fails.
p.s. i could use matches pattern and have the prompt text tell the user to 'Enter percentage (%), followed by search text followed by percentage(%) e.g. %blah%. that leaves room for user error though...
You need to put your wildcards outside of the @Prompt function like this...
tab1.col1 like '%' + @prompt('Enter search text','A',,,) + '%'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
79 | |
9 | |
9 | |
7 | |
7 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.