You can translate the question and the replies:

Multiple "WHERE OR" conditions for multiple parameters on view

With Denodo 5.5, is it possible to parameterize a view with multiple parameters such that it uses "OR" in the constructed "WHERE" clause? I want to do a select where a particular string may appear in one of several different fields, and I want to select all records where it appears in any of those fields.
08-04-2016 14:51:41 -0400

1 Answer

Hi! You can add a view parameter to the view to achieve this (create a SELECTION view if you are working with a base view) Then in the WHERE CONDITIONS tab, you can select 'Specify where expression' and have an expression similar to: view.field1 = view_param OR view.field2 = view_param OR... Hope this helps!
Denodo Team
08-04-2016 20:28:15 -0400
You must sign in to add an answer. If you do not have an account, you can register here