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

Discussion

Discussion

Feature request: Lookup using SQL query with variables

posted on June 5, 2018

For SQL admins out there that want to get more out of their forms in a more straightforward fashion, it would be helpful if we could get an option to use MSSQL query in the Lookup tab that can utilize variables. Similar to what the Workflow has for querying. 

Right now, if we want to get more complex data, we have to create a SQL View in the selected database and then do lookups to that view.


Thank you for your consideration!

2 0
replied on June 5, 2018

I second this feature request. I heard this request not only from customers, but also from multiple solutions engineers when I used to work at Laserfiche.

1 0
replied on June 5, 2018

Thank you for the request. I passed both this request and the linked one to our business rules team where this may be incorporated. 

1 0
replied on June 5, 2018

Please see the following feature request: https://answers.laserfiche.com/questions/49240/Feature-Request-Custom-Queries-for-Data-Source-Lookups

2 0
replied on June 5, 2018

Thanks Blake! I figured I would start the discussion again since it was 4 years old.

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

Sign in to reply to this post.