Where clause in information Link

[Sundaram Sridharan]

I need to setup a SQL query like

SELECT COLUMN1, COLUMN2 FROM DB1

WHERE COLUMN1 = "Value1" OR COLUMN2 = "Value1"

I also need to ignore case when pulling data. I do not know how to set this up. When I use on demand settings it only allows simple things like define input using a column.

[Varun Khandelwal]

Hi,

The information link SQL can be edited via the Information designer editor. Click the 'SQL' button to modify the sql and include the required clause in it. Try this and see if it helps.