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

Question

Question

Using SQL with Lookup Tables

asked on July 25, 2024 Show version history

Hi everyone, I'm looking to do a query on a lookup table where I join a table onto itself and then recursively get my employees' managers. I'm not getting the option to work with SQL with Lookup Table Queries(in Rules), only with the boxes of SELECT and WHERE and the rest, but I need to work with SQL specifically. Can someone point me in the right direction to use SQL with my table? I can also create a new database and connect to that data source if the lookup table doesn't accept SQL, but then how do I activate that query whenever the form gets filled with the Employee ID? Any videos or suggestion would be appreciated, as I am a beginner with LF.

0 0

Replies

replied on July 25, 2024

I don't have familiarity with LF Cloud — so take my information with a grain of salt — but I believe you can do one of the following:

  1. Query using External data sources | Process Automation | Laserfiche Cloud.
  2. If your information is available via a web service, query using a Web Request Rule (laserfiche.com).
0 0
replied on July 25, 2024

You could create a lookup table with denormalized data, e.g. add a manager column(s).
Lookup Tables does not support joins since they may introduce unexpected performance bottleneck.

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

Sign in to reply to this post.