Solved

Reader where clause

+1

The where clause woks perfectly in a sql Script but when I use it for a Reader if fails to filter the dataset.

Am I missing some syntax?

Has anyone got examples of where clause syntax for a Reader?

icon

Best answer by erik_jan 25 April 2019, 16:30

Userlevel 4

At first sight it looks OK. What do you mean by "fails to filter"? Do you get everything or nothing at all?

Userlevel 2

+12

I believe that if you use the SELECT, the WHERE is ignored.

But you can add the where clause in the SELECT parameter and leave the WHERE empty to get the right result.

Or you can leave the SELECT empty and then the WHERE will be added to the table reader as a filter.

+1

I get everything in the database

+1

Ahh erik_jan thats it !

Once I removed the select the where clause filtered the data.

I will try the where in the Select parameter as well

Thanks

Sign up