Vista Customization-VA Inquiry Equipment Std Maint Items

Scenario: Looking to have a list of Standard Maintenance Group Items and Last Done info on the EM Equipment Form

Requirements: None

Example Solution:

  1. Open the VA Inquiries form
  2. Enter udEMStandardMaintenanceItems in the Query Name field
  3. Enter Equipment Standard Maintenance Items in the title and description fields
  4. Type = SQL
  5. Query Text as follows:
    select s.StdMaintGroup ,s.Description as GroupDescription ,i.Description as ItemDescription, i.LastDoneDate, i.LastHourMeter, i.LastOdometer FROM bEMSH s (Nolock) LEFT OUTER JOIN bEMEM e (Nolock) on s.Equipment = e.Equipment and s.EMCo = e.EMCo LEFT OUTER JOIN bEMSI i (NoLock) on s.Equipment = i.Equipment and s.EMCo = i.EMCo and s.StdMaintGroup = i.StdMaintGroup where s.Equipment = @EQ and s.EMCo = @EMCo
  6. Change Column as desired in Columns tab
  7. Setup Parameters as follows:
    1. @EQ, Type = 4, Datatype = bEquip
    2. @EMCo, Type 0, Value = 1, Datatype = bEMCo
  8. Save and Open EMEquipmentForm Inquiry
  9. On Links tab add udEMStandardMaintenanceItems in Related Query Field
  10. Set Display Seq = 1
  11. Double Click the udEMStandardMaintenanceItems record to load the Inquiry links form and set @EQ = Equipment and @EMCo to use default value.
  12. Open EM Equipment Form
  13. Open Form Properties from the Tools menu
  14. Add a tab page Maintenance Items on the Tab Pages tab.
  15. Select Maintenance Items tab and click edit
  16. Set Control Type to 3 and select
    udEMStandardMaintenanceItems in the Query Name field.
  17. Save and close/reopen forms.
  18. Test tab to validate functionality.



Leave a Reply

Your email address will not be published. Required fields are marked *