Creating a result set query in Maximo

This entry is part 3 of 5 in the series Maximo Start Centers

Did You Know...

As Maximo Experts, we have developed several add-on products for Maximo that mobilize the work force, simplifies assignments, provides ad-hoc reporting capabilities and facilitates the seamless integration of Service Requests into Maximo.

Check out our products by clicking on the following links: EZMaxMobileEZPlanner and EZInsight.

Find Out More

12 thoughts on “Creating a result set query in Maximo

  1. Regarding table “joins” in the where clause, I assume you can only use it for filtering criteria, not pulling in additional fields from those tables, correct?

      1. Hi Chon,

        Has there been any development in enabling using table joins in a where clause to pull additional fields from the joined tables? I would like to create a result set with Log fields from SR application

  2. I’m trying to make a result set query based on work logs (to show all work logs entered in the previous 24 hours) but I’m not really sure how I’d go about it. Thoughts?

    1. You cant do it directly against worklogs and show it in some type of portlet. Only thing you could possibly do is query workorder that have worklogs entered in the past 24 hours. Otherwise, you might have to create a custom view.

Leave a Reply