Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
AutoPLANT | OpenPlant | PlantWise
  • Product Communities
  • More
AutoPLANT | OpenPlant | PlantWise
AutoPLANT | OpenPlant | PlantWise Wiki How to Customize Existing View by Adding new Column and mapping it to Show Required Data from Database
    • Sign in
    • -AutoPLANT | Bentley Raceway and Cable Management | OpenPlant | PlantWise Wiki
      • +OpenPlant
      • -Bentley AutoPLANT
        • AutoPLANT Product Group Compatibility
        • +AutoPLANT Modeler CONNECT Edition
        • +AutoPLANT Modeler V8i
        • +AutoPLANT Piping
        • +AutoPLANT Equipment
        • +AutoPLANT I&W
        • +AutoPLANT P&ID
        • +AutoPLANT Isometrics
        • +AutoPLANT AutoISOGEN
        • -Bentley Data Manager
          • Data Manager [FAQ]
          • ERROR Data Manager Is Not Able To Find The Object Equipment List 3 [TN]
          • MSSQL database structure changes do not appear in Data Manager
          • DataManager Load Error: The Microsoft Jet database engine Cannot open the file DataManager.mdb.
          • Error Received: This tag has been locked by a child project upon editing records in DataManager.
          • Error: The field could not be updated. Please check query definition
          • General - Bentley Data Manager
          • How To Customize Data Manager Report
          • How to Customize Existing View by Adding new Column and mapping it to Show Required Data from Database
          • How to Edit Existing View and Change Criteria to List Required Components
          • How to export data to Excel from Bentley DataManager?
          • How to fix Data Manager Crashing While Trying to Start Oracle Project in it
          • How to re-apply focus to applications you can't see on your monitor.
          • How to Setup Kernel level debugging of the DataManager application?
          • Message Please install OpenPLANT PID or Bentley I&W or AutoPLANT Modeler to run DataManager
        • +Vision/Document Manager
        • +Drawing Flattener
        • +DataSheets
        • +Specification Generator
        • +ProjectWise Integration
      • +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
    • How to Associate the Specification Based on Service in OpenPlant Modeler Connect

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

    How to Customize Existing View by Adding new Column and mapping it to Show Required Data from Database

    Applies To
    Product(s): OpenPlant PID
    Version(s): 08.11.10.XXX (SS5) | 08.11.11.XXX (SS6)
    Environment: Windows 7/8.1/10 (64 bit)
    Area: Data Manager
    Subarea: Customization
    Original Author: Kestutis Mitkus, Bentley Product Advantage Group

    Background

    In this Wiki Article we will try to explain how to Add new columns which will be showing required information from database on existing Process Instrument List. Sometimes, when user generates a Data Manager Report there requirement is to have separate columns with information to which Equipment or Pipeline instrument it is connected. Currently in Process Instrument List we can see one column "PLANT CONNECTION" in which we can se all plant component type tags together.

    Steps to Accomplish

    1. Launch Data Manager.
    2. Navigate to View > Process Instrument List.
    3. Right-Click and select to Edit it


    4. In Opened dialog select 'Design...' button and in Design View dialog select 'Design with Access' button.


    5. In opened Access window we need to understand how this relationship between all tables is working


      On Bottom Table We can see that PLANT CONNECTION Column is displaying TAG_NO values from TAG_REG table.

      TAG_REG table contains various records and we can see from mapping, that the required records are filtered by using KEYTAG value, which is mapped with PLANT_KEY value from INSTR table.

      Lets look to INSTR and TAG_REG tables and compare PLANT_KEY with KEYTAG





      Now we can see that TAG_REG KEYTAG are same like PLANT_KEYs in INSTR table and this explains how system knows which TAG_REG table record has Instrument tag.
      So in current situation PLANT_CONNECTION column is displaying all possible Instrument Tags from TAG_REG table.

      Now we can create one column which will be displaying only PROCESS Line Instrument Tags - PROCESS_CONN and one more column which will show us only EQUIPMENT Instrument Tags - EQUIPMENT_CONN.

    6. Right Click on Empty area and in opened dialog select EQUIPMENT, PROCESS and TAG_REG tables to add

    7. Now map PLANT_KEY field with KEYTAG in PROCESS table and then KEYTAG from PROCESS table to KEYTAG in TAG_REG table.


      Do the same with EQUIP and TAG_REG_1

    8. Double-click each arrow and select second option


    9. Go to end of Table in bottom and select on new field to TAG_REG table and then TAG_NO field to be displayed. As well you can ad different Column name by adding "PROC_CONN:" at the beginning of Field name.


      Do the same with EQUIP and TAG_REG_1

    10. Save all Settings & Close the dialog.


    11. Now Move your new Columns from end of this list to the beginning, that we could see it on same place where PLANT CONNECTION column was. I have removed PLANT CONNECTION column, because same information will be displayed in new columns. Click OK and check all changes in Process Instrument List


    12. Click OK and check all changes in Process Instrument List

    Below video will help you to get the explanation from steps 6 to 12:
    Click here to play this video

    See Also

    Corrections & Comments

    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 PID
    • Add new Colum
    • Customize View
    • View
    • Data Manager
    • Process Instrument list
    • AutoPLANT Data Manager
    • edit view
    • OpenPLANT PowerPID
    • Share
    • History
    • More
    • Cancel
    • Kestutis Mitkus Created by Bentley Colleague Kestutis Mitkus
    • When: Thu, Nov 15 2018 8:26 AM
    • Devendra Warke Last revision by Devendra Warke
    • When: Thu, Oct 10 2019 8:49 AM
    • Revisions: 3
    • 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

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