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

Question

Question

Data Query does not show up on Laserfiche forms

asked on August 26 • Show version history

We have created a Data Query on MS SQL database through Remote agent as the database is behind the firewall and we are using Laserfiche cloud. The query is tested and published. 

When we try to add lookup rule on our form to auto-populate certain fields based on data from database, we are unable to get the Data Query in the drop down. Whereas, when we create a Rules service task in business process and try to add the rule with data query, we are able to see the data queries in the drop down. 

Are there any configurations that we are missing? How can we get the Data Queries on the lookup rules of Form?

Thank you,

Shreya 

0 0

Answer

SELECTED ANSWER
replied on August 26

Direct DB Connections lookups from a SQL DB is supported in Forms, but the Remote Worker lookups are not. Too much latency with the Remote Workers. Typically the Remote Worker Lookups are only used within Workflow where time is not an issue.

3 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.