In a message dated 00-03-09 11:20:21 EST, you write:
n the Query Panel of BO, rather than giving :
Billing ID Matches Pattern ‘RET%’
OR
Billing ID Matches Pattern ‘GED%’
OR
Billing ID Matches Pattern ‘UMB%’
OR
…
Is there a way to make the above something like, Billing ID Matches Pattern ‘RET%,GED%,UMB%’
You can only do this if your database supports it. BusObj writes SQL code that is passed to your database. If this query structure was supported by your database, then you could do it. Unfortunately, I am not aware of any database that would allow you to use this.
Also,
IF I want to allow the users to specify multiple patterns, would it possible to achieve it using a single prompt ?
Ummm, well, yes, potentially. You would have to code the prompt in Designer, rather than in the client. And you would probably have to code for a specific number of prompts, so the user would be required to enter exactly the same number of patterns each time. And you would have to parse the user input and find the delimiter, and would have to expect the user to use the correct delimiter…
Oh heck, just say you can’t do it. It’s easier.
You should, however, be able to do this with a script. Again, that is not something that a query user might be expected to write. The script could be contained in an object in the universe, and would have to do all of those things that I started writing in the previous paragraph. But since a script can be interactive (where SQL cannot), you have more options.
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)