Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Forum Get document name and version in attribute for updating SQL table
    • Sign In

    • State Not Answered
    • Replies 1 reply
    • Subscribers 61 subscribers
    • Views 1310 views
    • Users 0 members are here

    Get document name and version in attribute for updating SQL table

    JSONS
    Offline JSONS over 6 years ago

    ProjectWise Explorer V8i SS4 08.11.11.590

    Is it possible to get the current document name to populate an SQL query statement in the Update Value section of an attribute?

    Scenario: When a specific attribute is updated I want to run an SQL query that would update a custom table with the current Document Name and Version.

    The available $DOCUMENT$, $DOCUMENT.FULLNAME$ AND $DOCUMENT.FULLDESC$ system variables do not provide the data I need. I just need the Document Name and Version.

    If I could have attributes on the form that were automatically populated with the current Name and Version on document creation that would work, but I have not been able to get it to work for me. 

    Any and all suggestions appreciated.

    • Sign in to reply
    • Cancel

    Top Replies

    • Dave Cole
      Offline Dave Cole Thu, Jul 20 2017 4:53 PM +1
      This may be what you are looking for. Version - SELECT O_VERSION FROM DMS_DOC WHERE O_PROJECTNO=$VAULT$ AND O_ITEMNO=$DOCUMENT$ Document Name - SELECT O_ITEMNAME FROM DMS_DOC WHERE O_PROJECTNO=$VAULT…
    Parents
    • Dave Cole
      0 Offline Dave Cole Thu, Jul 20 2017 4:53 PM

      This may be what you are looking for.

      Version - SELECT O_VERSION FROM DMS_DOC WHERE O_PROJECTNO=$VAULT$ AND O_ITEMNO=$DOCUMENT$

      Document Name - SELECT O_ITEMNAME FROM DMS_DOC WHERE O_PROJECTNO=$VAULT$ AND O_ITEMNO=$DOCUMENT$

      • Cancel
      • Vote Up +1 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    Reply
    • Dave Cole
      0 Offline Dave Cole Thu, Jul 20 2017 4:53 PM

      This may be what you are looking for.

      Version - SELECT O_VERSION FROM DMS_DOC WHERE O_PROJECTNO=$VAULT$ AND O_ITEMNO=$DOCUMENT$

      Document Name - SELECT O_ITEMNAME FROM DMS_DOC WHERE O_PROJECTNO=$VAULT$ AND O_ITEMNO=$DOCUMENT$

      • Cancel
      • Vote Up +1 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    Children
    No Data

    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies