Direct Query Native quoting

[rbecher]

Hi,

how can we quote the native string? This doesn't work (double single quotes):

DIRECT QUERY

DIMENSION

NATIVE('to_date(ERDAT,''YYYYMMDD'')') as ERDAT

...

- Ralf

[rajeshvaswani77]

Hi Ralf,

Finally did the quote work.

Please let know.

I am facing the same issue.

Thanks,

Rajesh Vaswani

[florentina_doga]

try this exemple

DIRECT QUERY

dimension

   product

measure

  value

FROM dbo."table";

[rbecher]

How your answer is related to my question?

[petter]

Tried this NATIVE function with DIRECT QUERY on an Oracle database and it worked well for me. Which version and service release did you get a problem with? How is it "not working" for you? Error message or null values or what?

[rbecher]

And how do you qoute inside of NATIVE?

My last try was a year ago against SAP HANA..

[petter]

Exactly like you did with two consequtive single quotes. But I assumed it was Oracle since you didn't mention which database you used. I tested this with QlikView 11.20 SR12.

[framacdev]

I know the post is a little bit old but I also ran into the same issue a few days ago.

I needed a string url within my Direct Query to extract pictures from a website.

I resolved the issue adding two variables to the Qlik Sense script.

I am working with Qlik Sense April 2019 Patch 1 and ElevateDB database.

Here is the script sample:

LET vWebsiteURL = chr(39) & 'https://mywebsite.com/img/' & chr(39);
LET vWebsitePIC = chr(39) & '.png' & chr(39);

LIB CONNECT TO 'ODBC Connection (new_user)';

invoice:
DIRECT QUERY
DIMENSION

SalesRep,
NATIVE('$(vWebsiteURL) + SalesRep + $(vWebsitePIC)') As Picture
MEASURE
SubTotal
FROM "Database".orders
;