duplicated single quotes in date when used as result from another query

[sylvain_dutilh]

Hello

We have a custom connection to a database system, with a set of PRM/SBO files we have been maintaining.

It behaves differently when we filter on dates, depending on the scenario.

The PRM files stipulates :

<Parameter Name="USER_INPUT_DATE_FORMAT">\d\a\t\e 'yyyy-mm-dd'</Parameter>

Which, when used in webi in a prompt, generates correctly our query :

...
where date_value = date '2019-07-01'

But, When we use this date object to get the result from another query, with the same datatype date, WebI double quotes the entire string, which then generates a wrong SQL:

...
where date_value = 'date ''2019-07-01'''

Does anyone have any idea how to get rid of this doubling of quotes? It only happens when using "Result from another query".

Edit :

BO Version is 4.2 SP7.
Database connection is through jdbc but custom connector, to a Denodo VDP database.

Thank you !

Sylvain

[denis_konovalov]

I have fixed your tags to better align with your question. Please be more careful next time.
Providing versions of the products used , type of DB and connection used also help community members understand your issues better.

[sylvain_dutilh]

I have opened a support case, I will keep you updated when I have an answer from the support.