Using OR operator in data source condition

Need help Database
1

Hi Fellow Bubblers,

I have a repeating group that needs to display results of products from the database and I need to show all products with prices: between $100 to $200 OR $0

Any idea how to apply this?

Thanks

2

Hi there, @fish… one way to go about it is to do a search for products with two constraints… one constraint where the price is greater than $99 and one constraint where the price is less than $201… and merge that search (using the merged with option) with a search for products with a constraint where the price is $0.

Hope this helps.

Best…
Mike

3

Thanks @mikeloc that did the trick!

1 Like