• Where can I find reference material for writing Projectwise SQL queries?

    Hi, I need to populate some attributes using SQL queries. I can't find any information on the table names, or field ID's. Can anyone point me in the right direction please?
  • Populating Document Attribute with 'Connected Project GUID' With SQL Statement

    Hi all, I've been trying for a while now to cobble together an attribute that contains a "Get Link"-like address to the target document. The intention is to keep a trail to the source document whenever it's exported (through attribute exchange), attribute…
  • Error in ProjectWise Administrator

    Hello community, When I try to create a new datasource (in the server that I created in "SQL Server") in "Projectwise Administrator" I get the following message: "You will not be able to modify global Projectwise Integration Server properties on (my…
  • Projectwise database register issue

    Hi , I've got some issue in connecting database through Orchestration Framework. I've tried connect via ODBC and Direct Database Connection, both of them show the same error " Invalid object name 'eimVersion'. " How do I fix this issue. Thanks for every…
  • SQL Statement to create a filtered picklist for Doc Code Attribute

    Hi, I am currently building a new set of environments for my organisation and have started to build the document code. I have managed to successfully define it but I would like to introduce a few smarts like filtering it around a project number and…
  • Saved Search with Complex SQL Query

    I am creating a ProjectWise SAVED SEARCH that will list all Work Area folders that have discipline folders (a,c,e,i,m,s,cs) that have permissions (folder and/or document) assigned to groups or users other than "Administrator" (1) or "CADD Admins" (2)…
  • Sub-Work Areas and Work Area Property Inheritance

    Is there a way for sub-work areas to access the work area properties of a parent work area? In this post it mentions that you may be able to drive them via SQL statement, but I'm having trouble getting that to work. The Value area of a work area property…
  • Custom SQL non clustered indexes

    Is this true? From our database team ... Our DBAs feel we no longer need to ask Bentley’s approval to create non-clustered indexes. They just need to inform the PW Administrators that they are creating it, after having tested it in the environments. Index…
  • PW: Generate document file name and description automatically (SQL)

    Hi. I am working on a new document import wizard. So far I am able to create a Document code generator which stores the ID to an attribute. This attribute is used as document name automatically. I have also created an Attribute tab with several other…
  • Proejctwise - SQL Statement

    Hi I have been trying to find the SQL statement to extract the value from a Projectwise attribute and place into a new attribute (placeholder) Current string 123456-CAL-DRG-0001 Required string CAL-DRG-0001 ie..remove the first 7 chars I would…