Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenPlant | AutoPLANT
  • Product Communities
OpenPlant | AutoPLANT
OpenPlant | AutoPLANT Wiki Populate Service Code in Pipeline Based on Service Description
    • Sign In
    • -OpenPlant | AutoPLANT Wiki
      • -OpenPlant
        • +CONNECT Services - OpenPlant
        • +Example Configuration - CONNECT Edition
        • +Installations - OpenPlant CONNECT Edition Applications
        • +OpenPlant Download Links & Videos
        • OpenPlant Product Compatibility
        • +OpenPlant Modeler CONNECT
        • +OpenPlant PID CONNECT
        • +OpenPlant Isometrics Manager CONNECT
        • +OpenPlant Orthographics Manager CONNECT
        • +OpenPlant Support Engineering CONNECT
        • +OpenPlant Project Administrator CONNECT
        • +OpenPlant CONNECT Edition-PlantSight Integration
        • -OpenPlant Modeler v8i
          • +Component - OpenPlant Modeler
          • +Drawing Generation- OpenPlant Modeler
          • +Errors, Logs, Messages, Crashes - OpenPlant Modeler
          • +Import/Export- OpenPlant Modeler
          • +Installation - OpenPlant Modeler
          • OpenPlant HVAC-OpenPlant Modeler
          • OpenPlant Modeler [FAQ]
          • +OpenPlant Specification Generator
          • +ProjectWise - OpenPlant Modeler
          • -Properties - OpenPlant Modeler
            • -Fundamentals of External Database Query in OpenPlant Modeler
              • How to Add Database Connection String Variable in Managed Workspace
              • Populate Service Code in Pipeline Based on Service Description
            • How to Add Component's Facing Property in Element Information dialog
            • How to Add Inch Sign with Nominal Diameter in Pipeline Tag
            • How to Add New/Existing Property to Nozzle Manager Dialog in OpenPlant Modeler
            • How to Add/Remove Properties in Flyover Hints
            • How to Associate the Specification Based on Service
            • How To Change Attributes of Pipe Based on Component State Using Named Expression
            • How to Change the Units of Measurement for ECProperty in OPM
            • How To Create and Populate Service Description Property on Piping Component Element Information
            • How to Exclude Plant Area Property From Consistency Checker
            • How to get Joint Type Information on Gaskets
            • How to Identify Inconsistency of Component Data with Consistency Checker
            • How to Map Spec Field with OpenPlant Modeler Property
            • How to Modify Supports in Bulk in OpenPlant Modeler
            • How to Move Properties Between Categories
            • How to Populate Header Nominal Diameter for Tap Connection in OpenPlant Modeler
            • How to Prefix 'DN' with Pipe Size in OPM
            • How to Set Default Value on EC Property
            • How to Show Nominal Diameter in Three-Digit Format for Support Tag Name
            • How to Update Bolts and Gaskets in OpenPlant Modeler
            • How to Update Pipeline Tag Name or Component Property After any Changes in Schema
            • To Modify Equipment Tag For FreeForm Nozzle in OpenPlant Modeler
            • To Modify Pipeline Tag Name in OpenPlant Modeler
            • To Obtain Arc Length for Pipe Bends in OpenPlant Modeler
          • +Release Notes - OpenPlant Modeler
          • +Schema - OpenPlant Modeler
          • +Settings/Attributes - OpenPlant Modeler
          • +Structural Modeling Components (SMC)- OpenPlant Modeler
          • +Tasks - OpenPlant Modeler
          • +Training - OpenPlant Modeler
        • +OpenPlant Isometrics Manager v8i
        • +OpenPlant Project Administrator v8i
        • +OpenPlant PID v8i
        • +OpenPlant Orthographics Manager v8i
        • +OpenPlant Support Engineering v8i
        • +OpenPlant ModelServer v8i
        • +OpenPlant Reporting v8i
        • How to Connect with Bentley Technical Support Team using Microsoft Teams
        • How to Connect with Bentley Technical Support Team using Microsoft Teams via Browser
        • How to get list of installed applications/programs on Windows Machine using Command Prompt.
        • How to get list of Windows Updates installed on the machine using Command Prompt.
        • How to Package WorkSpace to be Shareable to Users for OpenPlant Projects
      • +Bentley AutoPLANT
      • +Bentley Navigator
      • +Bentley PlantSpace
      • +Plant Project Tools
      • +Bentley Raceway and Cable Management
      • i-model Composition Service for S3D
      • Working from home with OpenPlant
      • Working from home with Bentley Raceway and Cable Management
      • Working from home with AutoPLANT Modeler
      • Your Feedback is important to us!

     
     Questions about this article, topic, or product? Click here. 

    Populate Service Code in Pipeline Based on Service Description

    Applies To
    Product(s): OpenPlant Modeler
    Version(s): 08.11.09.XXX (SS5) | 08.11.11.XX (SS6)
    Environment: Windows 7/8.1/10 (64 bit)
    Area: Properties
    Subarea: External Database Query
    Original Author: Harpreet Singh, Bentley Product Advantage Group

    Background

    User’s requirement is to select service description in create pipeline dialog and pipeline tag should get its corresponding Service code based on description. Below is the picture of access database table.

    Steps to Accomplish

    1. Load OpenPlant_3D.01.07 schema and supplement it with OpenPlant_3D_Supplemental_Modeling.01.07 & OpenPlant_3D_Supplemental_ModelingViews.01.07 schemas.

      These schemas are generally located in C:\ProgramData\Bentley\OpenPlantModeler V8i\WorkSpace\Projects\%PROJECT_NAME%\Dataset\schemas folder.

    2. Click the Properties tab and go to SERVICE class.



    3. Switch to Properties tab and select NAME property.



    4. Click Override button to be able to modify this property.



    5. Add EXTERNAL_DATABASE_QUERY custom attribute.



      Refer Fundamentals of External Database Query in OpenPlant Modeler for the steps to add this custom attribute.

    6. Add the values as shown below in the picture.



    7. Add Extend Type custom attribute and give the value as shown below.



    8. Go to Pipeline (PIPING_NETWORK_SYSTEM) class and select SERVICE property.



    9. Override the property and add Calculated ECProperty Specification custom attribute.



    10. Add below expression and other values in the custom attribute as shown below:

      this.GetRelatedInstance("SERVICE_IS_RELATED_TO_NAMED_ITEM:1:SERVICE").NAME

    11. Now select SERVICE_NAME property and Override the property.

    12. Add External DB Query custom attribute on it and give the values as shown below.

    13. Add Extend Type custom attribute on this property now.

    14. In Property Display Status custom attribute change the values from “Show: read-only” to “Show: editable” as shown below.

    15. Now, load “OpenPlant_Supplemental_Tagging” schema in class editor.

    16. Go to PIPING_NETWORK_SYSTEM class and switch to properties tab.

    17. Select SERVICE_NAME property and remove ‘Calculated ECProperty Specification’ custom attribute.

    18. Save all the changes in schema.

    19. Add Connection String Variable in the PCF file as shown.

    Verify the Results

    1. Launch OpenPlant Modeler.

    2. In create pipeline dialog, click   button to add new Service.

    3. In the Create Service dialog, select the Service description and save.


    4. You will see the description in association tab.




    5. Now switch to properties tab and select service code from the drop down in Service Name property.




    6. Pipeline tag will be updated with service code.

    See Also

    http://communities.bentley.com/products/plant/design___engineering/w/plant_design_and_engineering__wiki/31250.fundamentals-of-external-database-query-in-openplant-modeler

    Comments or Corrections?

    Bentley's Product Advantage Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!

    • OpenPlant Modeler
    • Select statement
    • 08.11.11.XXX pw
    • External Database Query
    • query
    • Service Code
    • Service Description
    • SQL
    • Share
    • History
    • More
    • Cancel
    • Harpreet Singh Created by Harpreet Singh
    • When: Sat, Oct 15 2016 6:50 AM
    • Harpreet Singh Last revision by Harpreet Singh
    • When: Tue, Nov 22 2016 7:58 AM
    • Revisions: 6
    • Comments: 0
    Recommended
    Related
    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