Solved: odbc limit data load within sql-clause - Qlik Community

Report Inappropriate Content · ‎2017-02-16

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'

Report Inappropriate Content · ‎2017-02-17

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 · ‎2017-02-17

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

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

Report Inappropriate Content · ‎2017-02-17

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 · ‎2017-02-17

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