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

Question

Question

Is there a way to get a list of all external tables in use by Forms?

Laserfiche Forms Version 10
Updated January 14, 2021
asked on January 14, 2021

I'm looking for an easy way to list out all of my BP Forms that have external lookups so i can identify what tables and views are in use and which ones are old and no longer needed and also, if i need to change a table, I need to know every form that needs to be edited.  Right now the only way i can see to do this is to manually go through every BP and every form and look at the lookup rules.  Extremely time consuming and tedious.

0 0

Replies

replied on January 14, 2021

If you go into the Administration page and open Data Sources, you can see a list of all data sources along with the server, database name, database type, and how many processes are attached.

If you click on a data source, it shows the details including a list of the attached processes; that's not going to tell you which tables or views are in use, but it at least tells you what processes to look at.

0 0
replied on January 14, 2021

Thanks Jason, 

I've already looked there and as you say, its not very helpful.  So my question to Laserfiche,  if a system admin that designs a bunch of forms leaves the org and there's a new person, why isnt there a better way for the new person to find this information out?

0 0
replied on January 14, 2021

If you have access to the forms database you should be able to construct a query to get what you need.  

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

Sign in to reply to this post.

Details
Related Posts
Loading ...