Multi Like Values

[areebasad]

   Dears,

Do you have a way to but many values in the like statement without the need to rewrite the condition many times on the Reporting configurations?

Regards

[RSAAdmin]

Areeb,

You'll want to do something like this:

fieldname IN ('value1','value2','value3')

Or you could create a variable in the parameter section which references a watchlist.  Clicking the help icon on the WHERE clause screen will explain this further.

Cheers!

[areebasad]

Dear.

The fieldname IN ('value1','value2','value3') take the Values as is, assume I want to like the Values 172.16.% and 192.168.16.% the IN () Does not help.

The Watch List does not allow REGEXP for the Reporting Process, So i Could not use the Values 172.16.%, 192.168.16.% in the watchlist to LIKE.