MAM 7.6.1.2:

I'm considerding adding a tab to WOTRACK that has a table control. The table control source would be a db view of all WOs in Maximo...with calculated fields...ISTASK=0 (not tied/related to the current WO in WOTRACK).

Screenshot of an OOB table control: https://i.stack.imgur.com/kUF7E.png

Pros - Easy Excel export:

• I can specify the columns that aren't included in the WOTRACK list view
• I can define the column order (unlike Application Export)
• I don't need an object structure (unlike ad-hoc reports and Application Export).
  • Changes to the ad-hoc report's ROS mean the report can't be edited. Which is inconvenient.
• Proper column titles are downloaded to Excel (unlike the Export Data option in reports and Application Export)
• No extra formatting for users to delete in Excel (unlike the Export Report option in reports)

Cons:

• Loading all WOs every time a user viewed a WO in WOTRACK would be an unwanted load on the system.

Question:

Is it possible to make it so the data is only loaded into the table control if the user clicks a custom "view data" button?
(kind of like what we see in the list view -- the data only gets loaded when the user clicks the search button)

Thanks.
#AssetandFacilitiesManagement
#Maximo

I wonder if the data would only ever be loaded/queried if the user actually clicked on that custom tab. Maybe a custom "view data" button isn't needed.

Although, if I were to have multiple table controls in the same tab, then a "view data" button would good.

On the table in application designer choose for it to Start Empty. That will prevent Maximo from returning records until someone acts on the table in some way.

To have a View Data button you probably can call an action automation script that gets your table control from the UI and calls an action on it to fetch the records. I haven't tried this but if you have issues let me know and I can give it a shot.

------------------------------
Steven Shull
------------------------------