odbc limit data load within sql-clause

[#1]

hello,

i want to limit the data loaded with a sql-query.

i successfully set up a odbc connection.

the query is very simple, but it does not consider my where-clause.

the resultset is completly different compared doing this query with sql-developer.

with qlik sense i get far more rows back.

why? can you tell me what's wrong here.

SELECT

"id",

"system_date"

FROM "user"."configuration_table"

WHERE "system_date" = '01.01.2017'

[shraddha_g]

issue is might be with WHERE "system_date" = '01.01.2017'

is the format of system_date is DD.MM.YYYY?

[#3 · Accepted solution]

hello,

yes, as i assumed it was my WHERE-clause.

very strange behaviour and no errors during execution -> is there a log-file that can be checked ?

finally my solution was to add the condition

WHERE system_date = to_char(SYSTEM_DATE,'DD.MM.YYYY')='15.02.2017';

[shraddha_g]

You can check script log at C:\ProgramData\Qlik\Sense\Log\Script