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

Question

Question

Workflow Custom Query Max Length

Workflow
Updated October 3, 2018
asked on October 2, 2018

Workflow is limiting me to a 7,000 character max in the Custom Query activity.  That may seem like a lot of characters, but I have a query I'm trying to adapt from a manual process to an automated one in Workflow and LFForms, and it's nearly 3 times that long.

I really don't want to rewrite the query if I can help it.

Is there any way around that 7,000 character max?

0 0

Answer

SELECTED ANSWER
replied on October 3, 2018

There is not. You could look into turning your query into a stored procedure and call that instead from Custom Query.

0 0
replied on October 3, 2018

Unfortunately, with this particular database, we have read-only access - that's actually why my query is so big, because we can't do temporary tables or anything fancy like that.

Thanks for the info @████████ - I'll start working on re-writing my query. sad

Suggestion for a future enhancement would be to increase the max length on that activity - or give us the ability to chose the max length.  This isn't the first time I've hit this wall...

 

0 0
replied on October 3, 2018

Sounds like you have a legit business need that should be discussed with management. A query like that with restrictions can cause more load on the system. 

0 0
replied on October 3, 2018

At this point, I'm moving forward with doing several separate queries and using the activities in Workflow to do calculations and analysis in place of everything that my joins were doing in the larger query.

0 0

Replies

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

Sign in to reply to this post.

Details
Related Posts
Loading ...