Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki Filter a Cable Report
    • Sign In
    • +OpenUtilities
    • Access Service Request Manager
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • +OpenUtilities sisNET - English
    • +OpenUtilities Substation
    • Promis.e Paths
    • -Promis.e Wiki
      • +CONNECT Edition - Promis.e
      • About Promis.e
      • +Administration Features - Promis.e
      • +APIs_VBA - Promis.e
      • +Automation Features - Promis.e
      • +Component Features - Promis.e
      • +Component Management - Promis.e
      • +CONNECT Services - Promis.e
      • +Data Manager - Promis.e
      • +Database Platform Support - Promis.e
      • +Display - Promis.e
      • +Drawing Management - Promis.e
      • +Engineering Design Considerations - Promis.e
      • Error - Object reference...General
      • +Find_Replace - Promis.e
      • Finding the Tutorial
      • +Installation_Configuration - Promis.e
      • +Interoperability - Promis.e
      • +Licensing - Promis.e
      • +Maintenance Features - Promis.e
      • +Migration - Promis.e
      • +OS Support - Promis.e
      • +Panel Layout - Promis.e
      • +Performance - Promis.e
      • +PowerPlatform Support - Promis.e
      • +Print_Publish Features - Promis.e
      • +ProjectWise Integration - Promis.e
      • Promis.e Help file
      • -Reports_Output Features - Promis.e
        • +Graphical Plan - Reports_Output Features - Promis.e
        • Red insertion point arrows visible on exported DWG
        • -Reporting - Reports_Output Features - Promis.e
          • Error - No active project to generate report
          • Error on Run Reports - DevExpress, UseNativeFormat
          • Error on Run Reports - No template selected
          • Export PLC I/O Text
          • Filter a Cable Report
          • Open Run Reports Faster
          • Panduit Labels
          • Run Reports
        • +Wiring Diagram - Reports_Output Features - Promis.e
      • +Template Management - Promis.e
      • +Text Tools - Promis.e
      • Training FAQs
      • +Wire Numbering - Promis.e
      • +Wiring Features - Promis.e
      • +Project Management - Promis.e
      • Promis.e Title
      • Working from home with Promise.e
    • Replace Family - Find_Replace - Promis.e
    • SQL Server Login

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

    Filter a Cable Report

      Product(s): Promis.e, Bentley Substation
      Version(s): through 08.11.13.73
      Environment: N/A
      Area: Reports_Output Features
      Subarea: Reporting

    How do I filter the built-in cable reports?

    Background

    If you want to filter the built-in cable list reports such as Cable List or Field Wire List, you should notice there are variable names in the drop down list for filtering that are repeated with different prefixes. The prefixes are:

    • T1 - Target 1, properties applying to the device at the first end of the cable
    • T2 - Target 2, properties applying to the device at the other end of the cable
    • Cable – The properties of the cable symbol itself.

    Therefore, the variable named “T1_Installation” is for the Installation name of the Target 1 device connected to the one end of the cable, where “Cable_Installation” is the variable for the Cable symbol’s Installation name.

    At the top of the list are also some variables that don’t have a prefix, such as Installation, Location, and Device Tag. This is a special set of variable names that have OR type logic built into them. The Filter dialog does not allow for user-defined OR type logic so these variable names will apply to both target devices on the ends of the cables.

    Steps to Accomplish

    Example 1 - Filtering Field Wire List for all connections to cable CAB1

    1. In the Run Reports dialog highlight the "Field Wire list - Letter".

    2. Select the Filters button.

    3. From the drop down list in the Field column select "Cable_DeviceTag".

    4. For the Relationship column select the equals sign (=).

    5. For the Value column type in "CAB1".

    The resulting report should provide a list of all information for the conductors whose Device Tag is CAB1.

    Example 2 - Filtering for all cables connected to devices in Installation "A"

    1. In the Run Reports dialog highlight the "Field Wire list - Letter".

    2. Select the Filters button.

    3. From the drop down list in the Field column select "Installation".

    4. For the Relationship column select the equals sign (=).

    5. For the Value column type in "A".

    The resulting report should provide a list of all information for the conductors whose Target 1 or Target 2 device Installation name is "A". Conductors whose Target 1 and Target 2 device Installation names do not match this filter will not be listed. Therefore unused conductors will also be excluded from the report.

    Note: To use a wildcard (*) in the Value column, select "Like" in the Relationship column.

      Original Author: Tani_S

    Keywords: hide unused conductors, cable cores

    • promis.e
    • Reports_Output Features
    • cables
    • how to
    • Bentley Substation
    • en
    • Reporting
    • SELECTsupport
    • Run Reports
    • Share
    • History
    • More
    • Cancel
    • Tani_S Created by Tani_S
    • When: Wed, Aug 20 2014 12:38 PM
    • Matt_P Last revision by Communities MVP Matt_P
    • When: Mon, Feb 6 2017 5:32 PM
    • Revisions: 7
    • 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