How to find the related App(s)

Scriptcase 9
#1

I have several big projects with over 600 Apps and 300+ tables. Sometimes I need to locate and list quickly all the Apps which use a specific table. Using search option would not work as it only search for App name, not a used table(s).
There is this REPORT option but it is super inconvenient as well, because If I need a lsit of Apps using two or three tables I cannot do this. This REPORT option also shows tons of INSERT lines which (as end result) make the list super huge (in my case and hard to track.

Does anybody have an efficient method for this ?

#2

UPDATE:
while researching the REPORT option, I discovered major bug. The reports is completely messed up and shows incorrect data. It shows (for example) table which uses and App, but when you open the App there is no reference to this table. Total mess !

REPORTED THIS TO NETMAKE, so hopefully in 5-6 years it will get fixed :frowning:

#3

Dear aklass,
I have the same problem.

If I want to know which table or view is used in which app, I go to the Data Dictionary and select Synchronize Applications. I select the tables I am looking for and click on Synchronize Applications / Next.
The tables are displayed along with the apps in which they are used. A report with this data would be better, but at least it’s a way to assign tables to apps.
I’m not familiar with the report option. Could you provide more details? Even if it’s a long report, you can filter it by Insert in database.

Good luck
Axel

#4

tables can also be used in lookups , or even in PHP code. there is no way you can pull all that information in a report. just fix what does not work and leave what works, the golden software rule :slight_smile:

#5

Hi, you can use scriptcase db with this select

select distinct Cod_Apl , Cod_Prj , NomeTabela
from sc_tbapl