Does anyone know of a way for me to list ALL of the tables that have added fields. i.e. Part_UD.xxx, Customer_UD.xxx etc. ?
I would like to create a BAQ to show this list, however, i am having trouble finding how to do that.
Any suggestions apprecieated.
DaveO
It’s not going to give you an output list to look at, but what I do is just open UD Column Maintenance and click the Table Name search. If you search wide open it will only show the tables with added fields:
If you use Ice.ZDataField (which I think you can get in the cloud), and do a match on the table name:
Then display the properties that you’re interested in.
I actually have a BAQ with a Dashboard that I run in Kinetic (classic dashboard interface). It’s not perfect, but it does the job. I can filter by table name or leave it wide open. The first name is the table it belongs to, but if I export to Excel and remove the first column, it’s in the right format to use DMT. I use it as a tool to export fields out of a development and into a production environment. See if the attached Dashboard Export (with BAQ’s) works for you.
UDFieldsDashboard.dbd (138.6 KB)
