Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Forum Setting up a Attribute value to be a concatenation of several others
    • Sign In

    • Replies 2 replies
    • Subscribers 60 subscribers
    • Views 2056 views
    • Users 0 members are here
    • ProjectWise Interface
    • Document Properties
    • SQL Server
    • ProjectWise Integration Server

    Setting up a Attribute value to be a concatenation of several others

    Anonymous
    Anonymous over 10 years ago

    Looking for advice on the best way to set the value of one attribute to be a concatenation of several others.

    I have two interfaces and attributes Title_0, Title_1, Title_2, Title_3 and Title_4. Titles 1 through 4 will be linked to the drawing title blocks and Title_0 will show the full concatenated title using a ", " as the seporator.

    The default interface will show Title_0 as a read only field on the Attributes tab while the other interface will show Title_1 through 4 as editable fields.

    I now I ca use the $Edit#... $ system variable but can you concatenate several and what is the syntax when using system variable setting or do you use the Select statement option?

    Note that the back d database is SQL Server

    • Sign in to reply
    • Cancel
    • Paul Patterson
      Paul Patterson Wed, May 22 2013 10:22 PM

      I'm actually quite interested in this as well.. please post back if you do come up with a solution.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Cancel
    • Jeff Burrill
      Offline Jeff Burrill Thu, May 23 2013 12:01 AM in reply to Paul Patterson

      I don't know if you can do string manipulations of attributes set to use System Variable type. But it should work just fine as a Select statement.

      Set the default and update values as Select statements on Title_0, and have it update the attribute whenever Title_1, Title_2, Title_3 or Title_4 attributes are updated. The SQL is something like this (for SQL server).

      SELECT $EDIT#Title_1$ + ', ' + $EDIT#Title_2$ + ', ' + $EDIT#Title_3$ + ', ' + $EDIT#Title_4$

      Please note that I post here on a voluntary basis and am not a Bentley employee. 

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Cancel

    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