topic Issue with 'where' during Oracle Dev connection in App Development

Issue with 'where' during Oracle Dev connection

Asiolinka — Wed, 12 Oct 2022 07:42:13 GMT

Hello,

I have an issue with date filter during connection with Oracle Dev database.

Trying to put :

SELECT *
FROM "xyz"."database" where date = 'YY-MM-DD';

Tried to find any correct date format but still does not work.

Any ideas what should I do to filter base from connection level?

Re: Issue with 'where' during Oracle Dev connection

Or — Wed, 12 Oct 2022 07:44:21 GMT

Whatever you would have used on the database end - you should be able to copy your query from PL/SQL Developer or whatever other tool you use to query the Oracle DB.

Re: Issue with 'where' during Oracle Dev connection

Mark_Little — Wed, 12 Oct 2022 07:56:06 GMT

HI @Asiolinka

Adding to what @Or has said, you are also assuming that the date column is being read by Qlik as date field, Maybe try formatting the DATE(Date)