Enfocus Community

I am trying to add a value from an SQL database as private data.

I have an SQL Query that works as long as I am inside the statement builder ("Build SQL statement"-window), but when I finish and insert, the double quotation marks are confused by switch to mean the end of the SQL statement text.

I need the double quotation marks in the SQL statement though, because the columns in the database have spaces and dashes in their names (like for instance "Sell-To Name", that has both).

Is there a way to escape the double quotation marks in the SQL query text so that switch doesn't interpret them as an end to the "Database.Text:SQL"-variable?

This is the SQL Query that works in the statement builder, if I click "Validate statement": When it is inserted into the database variable however, I get errors related to the double quotation marks. This is the code that doesn't work:

You could define the SQL statement as private data


Then just pass the private data variable into the database variable and that should work

Hey! That's genious!
Why didn't I think of that?!

Thank you! I will be trying that tomorrow.

Sadly, that didn't work either.

I now have a privatedata variable named "queryKundnamn" that in my example evaluates to: I then insert it to another privatedata variable: I now get the error: If I try the Query builder again with the string pasted, it works: If I try inserting the variable "queryKundnamn" into the editor, which evaluates to the same string, it doesn't work:

Can you try this?

kundnamn=[Database.Text:SQL="[Job.PrivateData:Key='queryKundnamn']",Connection="printvis"]

I've changed the double quotes around the private data key to single quotes.

I tried it, but I got the same error message.

I have now solved it with scripting instead. Seems like in the script interface it works just fine.

Thanks for your help.