Hello,
I was wondering if somebody could tell me what the table name is for the categories tab within a record/folder/file? The record that I am interesting are physical storage items in case that makes a difference.
there are a few tables storing data, you can get a copy of the DB schema from your OT account manager. The table most likely to have your data, in a useable format, is LLAttrData.
Tobias,
As Greg mentions, your OT AE can arrange a copy of the database schema documentation for you.
Even with that, what I would say are that there are some aspects of the tables that may or may not be explained in the schema documentation thoroughly.
In your case for example, as Greg points out, category data is stored in LLAttrData but this isn't the master data for what you see displayed in your screenshot - that information is coming from LLAttrBlobData. LLAttrData is a simplified reporting table and there are administrative settings in the product that influence how it is populated thesedays.
Additionally, depending on configuration - there's also different tables used for Physical Items that can also record information in a similar fashion to categories (this would show on a separate tab).
You've not described why you're needing to access the data or your goals……that would help respondents here give you options.
Regards,
David
