How to Add Equipment UDAs in BOQ Reports


 Product(s):Bentley Raceway & Cable Management
 Version(s):CONNECT Edition (10.xx.00.xx)
 Environment:N/A
 Area:Output Manager
 Subarea:N/A
 Original Author:Aadarsh Tale

Background

If you have define custom attributes(UDAs) to the equipment inside your project and you want to see them in an output report. you can follow this article to export your equipment UDAs.

Steps to Accomplish

  1. Define Equipment UDAs which you want to export in reports.
    For example:


  2. Open Output Manager from Output ribbon tab
     
  3. Select the Detail_Equipment report, select the resources and open Edit Template.


  4. Copy the SQL query as shown in the image below:
    “SELECT ROW_NUMBER() OVER (ORDER BY EQPID) AS RECNO, * FROM (SELECT distinct CLASS, MANUFACTURER, EQPDESCR AS DESCR, EQPID, INSERTIONPOINT FROM $(P)_$(S)_EXT_BOQRW WHERE CLASS = 'EQ') CEQP;”


  5. Enter the UDA as shown:
    SELECT ROW_NUMBER() OVER (ORDER BY EQPID) AS RECNO, * FROM (SELECT distinct CLASS, MANUFACTURER, EQPDESCR AS DESCR, EQPID, INSERTIONPOINT, TESTUDA FROM $(P)_$(S)_EXT_BOQRW WHERE CLASS = 'EQ') CEQP;

    Add the query in the SQL Query section from where it is copied, save the template and close BRCM.

  6. Open DB_DataDictionary.xml from the std_dataset’s metadata folder. Add a new entry and enter your UDA name as shown in the image.


  7. Relaunch BRCM and open the Detail_Equipment report template. Now you will see a new field list as your UDA name.



  8. Drag this new Field List and place where you want to see the UDA in the report template.
    For example:


  9. Save and run the report.

See Also

communities.bentley.com/.../reports---output-manager---brcm-connect-edition

Still a Problem?

If above problem still persists, then please create a Service Request and contact the Bentley Product Advantage group.  Please include a list of all relevant details to get in depth analysis for a solution or workaround.

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!