If not is there somewhere in the database or a screen customisation that shows all the custom columns created?
Many thanks!
UD fields are stored in table ZDataForm. Limit it with
DataTableID LIKE '%_UD'
Unfortunately it does not have fields for who or when it was created. You could make a change long to capture future creations/changes.
Thanks for that, I can’t find the ZDataForm table, is it a regular Erp table?
Would it just be a table that hold all the UD tables or does it include the UD columns as well (that’s what I’m really after)?
Cheers
Whoops… I meant Ice.ZDataField
Add Table Criteria shown to get just the UD fields.
If you go into User Defined Column Maintenance, and do a table search, it comes up with all of the tables where there are custom fields added. Then if you hit select all, they are all in the tree for you to look at. That seems pretty easy to me.?.?.?
Topic is
“Is it possible to get a list of the custom columns created filtered by the user that created them?”
