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

Question

Question

Cloud Dynamic Fields Tied to a Query

asked on April 20, 2022

With on-prem Laserfiche, we can register External tables to both database tables and views.  This allows us to have a single table store shared data and then create various views of that table, so that different templates display different data.  In cloud, it appears we can only point Dynamic fields at Lookup tables.  

  • Is there a way to have a Dynamic field tied to a Query instead of a Lookup table?
  • If not, is there some way in cloud to have one Lookup table but essentially create views of that table, that can then be connected to Dynamic fields in a template?
  • Also if not, then I would like to request a feature enhancement to allow Queries to be tied to Dynamic fields.  These queries can essentially be setup exactly like database views and would go a step further to providing the functionality we've come to love from the on-prem version.
2 0

Replies

replied on June 17

Just wanted to check back as it has been a few years on this request and I've not heard back or seen this functionality added.  Can Dynamic Fields in LF Cloud be updated to allow us to tie them to not just External Tables, but also to Queries?  This would essentially give us the same functionality as on-prem where we can have a single table that houses all of our doc types and we create views that each template uses for its dynamic dropdowns.

0 0
replied on June 17

This is currently in the works, on track for a release next quarter. You will be able to use data queries (against lookup tables and self-hosted SQL) as well as web requests.

2 0
replied on June 17

That is wonderful news!  You've made my day smiley

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

Sign in to reply to this post.