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