Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
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';
issue is might be with WHERE "system_date" = '01.01.2017'
is the format of system_date is DD.MM.YYYY?
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';
You can check script log at C:\ProgramData\Qlik\Sense\Log\Script