You are viewing limited content. For full access, please sign in.

Question

Question

Custom Query "from" parameter

asked on May 21, 2018

I am migrating from Sharepoint to Laserfiche and have a staging table per SP library. This Table has important field information that I need to extract. 

The imported files include the table that needs to reference.

When using "Custom Query" to read from the reference table the parameter is not being populated and the "Query" is just being sent, resulting in a syntax error.

This is not an issue with declaring the parameter, the query also has a parameter for where clause which works perfectly if I hard code a table.

 

Does the Custom Query activity has a "feature" where parameter are only detected after a "Where" ?

Note - designing with workflow 10.2.0.216

0 0

Answer

SELECTED ANSWER
replied on May 22, 2018

The activity uses parameterized queries to protect against SQL injection. Table names are not valid parameters in this case.

A potential workaround (and its drawbacks) is discussed in this thread.

0 0

Replies

replied on May 22, 2018

Thanks Miruna, and yes that is the workaround I am using. Would it be possible to the documentation to be updated for the Custom Query. Its not really clear where parameters can and can't be used and in what type of query. SQL injection protections are not mentioned anywhere on the page.

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.