Filesite Document Info

Does somewhere know where the 'Where Used' value(s) are stored, in which table & field? I looked over DocMaster and nothing really stood out.

Thanks

Find more posts tagged with

Comments

guido1

I think what you're referring to is stored in the PROJECTS table

Migrateduser

Hi sshro, If I'm not wrong "Where used" is not stored in any field of the database. I Imagine it is the result of a recursive SQL function which builds the hole path of a doc.

The folder where the document is stored is in project_items table,for the rest of the path, you have to look for it playing with the prj_pid and prj_id of the folders you find until you arrives to the workspace level.

I don't know if interwoven does this query using this way, however it is the only sql way I know to get this information.

Hope it helps
Javi

jny

I'm not sure whether or not you're using the SDK. But if so, you may build your own path like so:

IManDMS dms = new ManDMS();
IManSession sess = dms.Sessions.Add(servername);
sess.TrustedLogin();

IManDatabase db = sess.Databases.ItemByName(databasename);

IManDocument doc = db.GetDocument(1311, 1); //Arbitrary example of valid docnum and ver
IManFolders docPath = doc.Folders; //The folders that contain references to the document
IManFolders whereusedPath = null;
string sWhereusedPath;

foreach (IManFolder fldr in docPath)
{
sWhereusedPath = string.Empty;
//Path returns the folder path of the target folder
whereusedPath = fldr.Path;
//Put the path in a string var
for (int i = 1; i <= whereusedPath.Count; i++)
sWhereusedPath = sWhereusedPath + whereusedPath.ItemByIndex(i).Name + @/;
sWhereusedPath = db.Name + @/ + sWhereusedPath;
}