Windows 7/8.1/10 (64 bit)
Nikhil Salunkhe, Bentley Product Advantage Group
In OpenPlant PID, user wanted to choose Field Value, here for Manufacturer Property from Picklist which is created in database. After creating database, Picklist is displaying in OpenPlant PID but unable to select any of the Field Value. Sql Select Statement and Data connecting string were causing this issue in OpenPlant PID. So, in below Wiki article, we are defining the steps on how to select Manufacturer Field Value from Picklist with the corrected Sql Select Statement and Data connecting string.
Create a Database for ‘Manufacturer’ inside Dataset of a Project, here Metric Project by using Microsoft Access Database, here Access 2013 (Manufacturer.mdb) Go to Start Menu and click on Access 2013
Fill below data in Database, then right click on Manufacturer and click on Design view. See below image
Define Data type for every field name after changing to Design view.
Save database with 2002-03 Compatible version then close the file.
Launch Class editor.
Open OpenPlant_PID.01.07.ecschema.xml schema.
Supplement with OpenPlant_PID_Supplemental_Imperial.01.07.ecschema.xml schema
Expand Classes tab and navigate to Vessel class in Plant Base Object, select Properties tab, go to Manufacturer Property and click ‘Override’ then select Manufacturer property, right click and Add External Data source Definition Mapping and Extend Type Custom attributes.
Change Location to OpenPlant_PID_Supplemental_Imperial.01.07 and click Ok
ECProperty name : MANUFACTURERExtendType : There are two Extended types 1. ShowPickListViewDatabaseForm ( Displays a detached form from which to select your data. You will select the data and click OK to close the form and populate the field.)
2. ShowPickListviewDataBase ( Displays a list from which to select your data that is attached to the element info dialog.)
Note : Kindly ensure that Sql Select Statement is correctly defined.
Right click on Vessel, go to Element information and select manufacturer Property in General info Section and Select ‘TANKS ARE US’ option. See below image.
Notice the change in Manufacturer property ‘TANKS ARE US’, See below image.
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!