Hi, how can I find a specific SQL Table through out all my LF Forms. I'm wanting to find which LF Form is using Table_A from my SQL DB?
Thanks in Advance
Hi, how can I find a specific SQL Table through out all my LF Forms. I'm wanting to find which LF Form is using Table_A from my SQL DB?
Thanks in Advance
Hi Carlos,
Although this does not give us a list of all forms using specific tables, it does list all forms using a specific data source that we can go through individually. This is another approach to using the the "Data Sources" within Forms.
[cf_external_dbtables]: query the datasource_id for the table name listed within the table_name column.
[cf_bp_datasource_mapping]: query to find bp_id for the datasource_id found through previous query.
[cf_business_processes]: query to find all form names that have bp_id equal to value found in previous query.
My example:
SELECT [datasource_id]
,[database_id]
,[table_name]
,[table_schema]
FROM [LF_Forms].[dbo].[cf_external_dbtables]
where table_name like '<yourtable>'
SELECT B.name, cast(date_created AS DATE) AS date_created, cast(B.date_updated AS DATE) AS date_updated, B.is_triggerpublic as published
FROM [LF_Forms].[dbo].[cf_bp_datasource_mapping] A
inner join [LF_Forms].[dbo].[cf_business_processes] B ON
A.bp_id = B.bp_id
where A.datasource_id = <datasource_id found through previous query>
In Forms, if you click on your username in the upper right hand corner, and then select Administration, you will see a tab for Data Sources in the left column. Unfortunately, all we have available is the SQL database and which processes are using that.
I've requested an enhancement before to this so that it would show the tables. https://answers.laserfiche.com/questions/220186/Feature-Enhancement--Forms-Data-Sources
Yeah, I already know about what you described. I was hoping I can do a SQL query at the Laserfiche DB SQL to find this information I'm looking for. Thanks