Displaying position description and product description in AsBuilt Meter Readings tab
- Using M3 Mobility Core Toolbox, proceed to Filter Maintenance.
- Select Filter Types > Normal > Tablet.
- Copy (MFS-MAI) WO Operation As Built Meter Readings.
-
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 - Click Save.
- Go to System Configuration > Dialog Design.
- Copy ServiceAssignment Version 0.
- Using the copied version, select As-Built Meter Readings.
- Select EditableFilterControl.
- Select the newly copied Filter group.
- Click Close.
- Add role to the new dialog.
- Click Save.