The solution is probably depending on the format of values you paste in your input box in QV and the fields / format of that fields you need to filter.
There are some threads here that are suggesting solutions to similar problems, you might want to search for "input box", "filter" etc. For now, I've found this post as a start:
Thanks for the reply, I understood the concept. The issue is... there will be no delimiters. Folks will be pasting it from an Excel worksheet or a text file and the values will look something like this:
I cannot ask them to delimit the values because sometimes it might be just 2 and sometimes 200.
So there may be a delimiter, a line feed.
Check attached modified sample.
Open the input box entry dialog by clicking in the entry field an then on the "three dots" button to open the editor. You'll see the values just copied in as lines, separated by a line break.
I modified the button action to
to adapt the situation to a line feed as delimiter.
Your situtation might be a bit more complex, if your delimiter is a little different (you can also check for chr(13) CR). But maybe this guides you to some working solution.
comm45417_2.qvw 161.2 K
Call me dumb. But I could not get this to work. This is what I did:
I created a project with 3 objects on it. A list, a button and a text box.
- The Quarter list is called CAL_QTR. I preloaded the list from my SQL Database.
- The button has this code: Action = Select in Field >> Field CAL_QTR >> Search String:='('&replace(var_Quarter,',','|')&')'. I was trying with a Comma Delimiter first.
- In the text box, I clicked on the ellipses (...) to open the editor and typed Q4 2011 and hit the button. But it does not seem to be selecting it.
Not sure what I could be doing wrong?