Workspace Name (SQL)

Our workspace names are a combination of the values from cparent_alias + custom_alias + c_descript from the Custom2 table.

Is this value also stored in a table elsewhere? Doesn't seem to be in DocMaster, Projects or Project_Items.

Ideas?

Thanks,

Steve

Find more posts tagged with

Comments

Migrateduser

Hi sschro, If I'm not wrong the only place where you store your workspace name is prj_name / prj_description in projects table.

The other references in rest of tables are using prj_id.

Hope it helps
Javi

sschro

Hi sschro, If I'm not wrong the only place where you store your workspace name is prj_name / prj_description in projects table.

The other references in rest of tables are using prj_id.

Hope it helps
Javi

Thanks.

It appears the value(s) I'm looking for are not in the Project tables. I'm looking for the Workspace name, it seems the project tables contain the workspace folder names, i.e. Correspondence.

Maybe the Workspace name does come from Custom1 & Custom2, but I assumed because the matter number are there, and in Docmaster, the Workspace name would also be somewhere else, ultimately...

Thoughts?

Migrateduser

Look at the projects table the rows with subtype = 'work', here you will get the name of the workspace.

Hope it helps
Javi

sschro

Look at the projects table the rows with subtype = 'work', here you will get the name of the workspace.

Hope it helps
Javi

Got it. Thanks.

Select DM.DocNum, P.PRJ_ID, PRJ_Name
From MHGROUP.Projects P
Inner Join MHGROUP.DocMaster DM On DM.DocNum = P.DocNum And P.SubType = 'Work'
Where DM.C1ALIAS = '15868' And C2ALIAS = '0001USZA'