Where is profile info stored?

Looking at a particular folder under a workspace, looking at the profile information, which in this case is invalid.

I wont get into it too deep, but I just need to know, where Worksite is storing the info from this screen, i.e. which table? MHGROUP.???

FYI: I've already looked in DocMaster, Custom2, and Projects, and it is neither of them, it must be another table.

Thank you

Find more posts tagged with

Comments

sschro

No one has any idea?

jny

Looking at a particular folder under a workspace, looking at the profile information, which in this case is invalid.

I wont get into it too deep, but I just need to know, where Worksite is storing the info from this screen, i.e. which table? MHGROUP.???

FYI: I've already looked in DocMaster, Custom2, and Projects, and it is neither of them, it must be another table.

Thank you

Folder profile is stored as name-value pairs. The table that contains these nvp's is PROJECT_NVPS. When you look at the name of the nvp, you will see a prefix of iMan___ with a numeric value append to it. This naming convention is a representation of the custom attribute id. For example iMan___5 = AUTHOR because imProfileAuthor enum has the numeric value of 5. The prefix is to indicate that it's a profile attribute.

We do not recommend accessing the database directly. Database access is carefully tuned to insure scalability and concurrent access. If you access the database directly you throw out all of this careful tuning and run a high risk of your system being unavailable. In all it goes against the core of our 3-tier architecture design.

If you need to manipuate the folder profile, go through the SDK, specifically the folder.IManAdditionalProperties collection object.