Displaying position description and product description in AsBuilt Meter Readings tab

  1. Using M3 Mobility Core Toolbox, proceed to Filter Maintenance.
  2. Select Filter Types > Normal > Tablet.
  3. Copy (MFS-MAI) WO Operation As Built Meter Readings.
  4. Using the copied filter, update these values:

    Filter group properties

    • Main table: AsBuiltStructureMeters
    • Extra Table 1: AsBuiltStructure
    • Extra Table 2: MeterIdentifierExtended
    • Extra Table 3: ProductDescription
    • Double Click Behavior: Launch Link
    • Bookmark/Link: AsBuiltMeterReading

    SQL Query

    • Select:
      AsBuiltStructureMeters.AsBuiltStructureMetersID, AsBuiltStructure.Position, AsBuiltStructure.ComponentProductNo, AsBuiltStructure.ComponentSerialNumber, MeterIdentifierExtended.MeterIdentifier, MeterIdentifierExtended.Description, AsBuiltStructureMeters.MeterValueSinceNew, AsBuiltStructureMeters.LastMeterReadingDATE, AsBuiltStructureMeters.LastMeterReadingValue, MeterIdentifierExtended.MeterUsage, MeterIdentifierExtended.NumberOfDecimals, AsBuiltStructure.PositionDescription, ProductDescription.ProductName
    • From:
      AsBuiltStructureMeters LEFT JOIN AsBuiltStructure on AsBuiltStructure.AsBuiltStructureID = AsBuiltStructureMeters.AsBuiltStructureID LEFT JOIN MeterIdentifierExtended on MeterIdentifierExtended.MeterIdentifierExtendedID = AsBuiltStructureMeters.MeterIdentifierExtendedID LEFT JOIN ProductDescription on ProductDescription.ProductID = AsBuiltStructure.ComponentProductID and ProductDescription.LanguageID = %L
    • Where:
      AsBuiltStructureMeters.EquipmentID = %PA AND MeterIdentifierExtended.TimeUnit <= '2'

    Column Format

    Table 1.
    Description Index in SQL query Data type Card view index Hidden Column Name Database Column Column Primary Key
    As-Built Structure Meters Identifier 0 Text -1 Yes AsBuiltStructureMeters.AsBuiltStructureMetersID AsBuiltStructureMeters.AsBuiltStructureMetersID -1
    Position 1 Text -1 No AsbuiltStructure.Position AsbuiltStructure.Position -1
    Position Description 11 Text 0 No AsbuiltStructure. PositionDescription AsbuiltStructure. PositionDescription -1
    Item Number 2 Text -1 No AsbuiltStructure. ComponentProductNo AsbuiltStructure. ComponentProductNo -1
    Item Description 12 Text 0 No ProductDescription. ProductName ProductDescription. ProductName -1
    Serial Number 3 Text 1 No AsbuiltStructure. ComponentSerialNumber AsbuiltStructure. ComponentSerialNumber -1
    Meter Identifier 4 Text 2 No MeterIdentifierExtended.MeterIdentifier MeterIdentifierExtended.MeterIdentifier -1
    Meter Description 5 Text 2 No MeterIdentifierExtended.Description MeterIdentifierExtended.Description -1
    Meter Value Since Installation 6 Float 3 No AsBuiltStructureMeters.MeterValueSinceNew AsBuiltStructureMeters.MeterValueSinceNew -1
    Last Meter Reading Date 7 DateTime 3 No AsBuiltStructureMeters.LastMeterReadingDATE AsBuiltStructureMeters.LastMeterReadingDATE -1
    Last Meter Reading 8 Text -1 No AsBuiltStructureMeters.LastMeterReadingValue AsBuiltStructureMeters.LastMeterReadingValue -1
    Meter Usage 9 Integer -1 Yes MeterIdentifierExtended.MeterUsage MeterIdentifierExtended.MeterUsage -1
    Number of Decimals 10 Integer -1 Yes MeterIdentifierExtended.NumberOfDecimals MeterIdentifierExtended.NumberOfDecimals -1
  5. Click Save.
  6. Go to System Configuration > Dialog Design.
  7. Copy ServiceAssignment Version 0.
  8. Using the copied version, select As-Built Meter Readings.
  9. Select EditableFilterControl.
  10. Select the newly copied Filter group.
  11. Click Close.
  12. Add role to the new dialog.
  13. Click Save.