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 · Accepted solution]

Hello again,

So as promised, I have opened a case to SAP and they have confirmed it to be a bug.

The issue should be fixed in 4.2SP8 and the initial release of 4.3.

See note 2754511 for more information.

[former_member615876 · Accepted solution]

how do you open a case? I also have an issue with @variable(BOUSER') when user has domain with "\'