Filtering changes for position and equipment-based, and plant or site browser

  1. Select System Configuration > Navigation > Start Menu.
  2. Under Menu items tab, select the start menu being used in MFS.
  3. Click Menu items tab, select My Appointments. Take note of the filter you are using.
  4. Select Filter maintenance > Filters.
  5. Select Filter types > Normal > Tablet.
  6. From the Start menu, select the filter used on My Appointments.
  7. Under SQL Query, click Show More.
  8. Within the Select Text area, append this string at the end: 
    Service.ServiceCategory, ModelSite.ModelSite, ModelSite.Description, ModelSitePosition.Position, ConfigurationStructure.ConfigurationStructureID, ServiceProduct.EquipmentNumber, ServiceProduct.SerialNumber
  9. Within the From text area, append this string at the end: 
    FULL JOIN ConfigurationStructure ON ConfigurationStructure.ModelSitePositionID = ServiceOrderHead.ServiceProductID FULL JOIN ModelSite ON ModelSite.ModelSiteID = ConfigurationStructure.ModelSiteID FULL JOIN ModelSitePosition ON ConfigurationStructure.ModelSitePositionID = ModelSitePosition.ModelSitePositionID   LEFT JOIN FullEquipment as ServiceProduct ON ServiceProduct.EquipmentID = ServiceOrderHead.ServiceProductID
  10. Under Column format, click Show More.
  11. Click the Add icon.
  12. Specify this information:
    Description Column Name Data Type Hidden
    Service ServiceCategory Service.ServiceCategory Integer Yes
    ModelSite ModelSite ModelSite.ModelSite Text Yes
    ModelSite Description ModelSite.Description Text Yes
    ModelSitePosition Position ModelSitePosition.Position Text Yes
    ConfigurationStructure ConfigurationStructureID ConfigurationStructure.ConfigurationStructureID Text Yes
    ServiceProduct EquipmentNumber ServiceProduct.EquipmentNumber Text Yes
    ServiceProduct SerialNumber ServiceProduct.SerialNumber Text Yes
    Note: Use the incremented index of the previous column as the index in the SQL query.
  13. Click Save.