Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Forum Populate ProjectWise System Attribute value in an Environment attribute
    • Sign In

    • State Suggested Answer
    • Replies 4 replies
    • Answers 1 answer
    • Subscribers 62 subscribers
    • Views 1124 views
    • Users 0 members are here
    • attribute

    Populate ProjectWise System Attribute value in an Environment attribute

    Qadeer Hussain
    Offline Qadeer Hussain over 3 years ago

    I want to update value of system attribute STATE in an Environment attribute. For Example If STATE is IN PROGRESS then this should update into an Environment Attribute. I thought System variable will have this value but it is not so it look like I will need a SQL select statement. Can someone help me out please?

    • Sign in to reply
    • Cancel
    Parents
    • Andzej Prokopovic
      0 Offline Andzej Prokopovic Tue, May 12 2020 5:04 AM

      Hello Qadeer,

      Please try to add the following SQL statement to the environment variable:

      "

      select o_statename from dms_stat where o_stateno = (select o_stateno from dms_doc where o_itemno = '$DOCUMENT$' and o_projectno = '$VAULT$')

      "

      It should return current state name for the document.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Qadeer Hussain
      0 Offline Qadeer Hussain Tue, May 12 2020 7:48 AM in reply to Andzej Prokopovic

      This is working in part but it is displaying previous state. For example i have States A, B, C D so when document is in state B, attribute showing state A, and when it is in state C, attribute show state B.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Andzej Prokopovic
      0 Offline Andzej Prokopovic Tue, May 12 2020 8:09 AM in reply to Qadeer Hussain

      The attribute value update depends on the setting for attribute update. It can be updated when a specific attribute from the same environment is updated or any attribute from the same environment is updated. This is how it works. If you would set that new attribute to be updated when any attribute in the environment is changed then value for that attribute should be updated as well. If during the state change non of the attributes of that environment are updated then this new attribute will not be updated.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Qadeer Hussain
      0 Offline Qadeer Hussain Tue, May 12 2020 8:24 AM in reply to Andzej Prokopovic

      Thanks - got it. I will have to change the rule engine.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Reject Answer
      • Cancel
    Reply
    • Qadeer Hussain
      0 Offline Qadeer Hussain Tue, May 12 2020 8:24 AM in reply to Andzej Prokopovic

      Thanks - got it. I will have to change the rule engine.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Reject 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