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

    Michael Reilly
    Michael Reilly
    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?
    • Answered
    • 6 months ago
    • ProjectWise
    • ProjectWise Design Integration Forum
  • Populating Document Attribute with 'Connected Project GUID' With SQL Statement

    Henrik Thornkvist
    Henrik Thornkvist
    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…
    • Answered
    • 9 months ago
    • ProjectWise
    • ProjectWise Design Integration Forum
  • Error in ProjectWise Administrator

    DENNIS ROBERT MORALES MARTINES
    DENNIS ROBERT MORALES MARTINES
    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…
    • over 1 year ago
    • ProjectWise
    • ProjectWise Design Integration Forum
  • Projectwise database register issue

    REI
    REI
    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…
    • Answered
    • over 1 year ago
    • ProjectWise
    • ProjectWise Design Integration Forum
  • SQL Statement to create a filtered picklist for Doc Code Attribute

    Russell Bunn
    Russell Bunn
    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…
    • over 2 years ago
    • ProjectWise
    • ProjectWise Design Integration Forum
  • Saved Search with Complex SQL Query

    Warren Malveau
    Warren Malveau
    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)…
    • over 3 years ago
    • ProjectWise
    • ProjectWise Design Integration Forum
  • Sub-Work Areas and Work Area Property Inheritance

    Mike Dillner
    Mike Dillner
    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…
    • over 4 years ago
    • ProjectWise
    • ProjectWise Design Integration Forum
  • Custom SQL non clustered indexes

    Sandy McLean
    Sandy McLean
    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…
    • Answered
    • over 6 years ago
    • ProjectWise
    • ProjectWise Design Integration Forum
  • PW: Generate document file name and description automatically (SQL)

    torbjorn.s
    torbjorn.s
    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…
    • over 9 years ago
    • ProjectWise
    • ProjectWise Design Integration Forum
  • Proejctwise - SQL Statement

    AndyL
    AndyL
    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…
    • over 10 years ago
    • ProjectWise
    • ProjectWise Design Integration Forum
  • View related content throughout ProjectWise
  • More
  • Cancel