NOTE: ActiveX controls must be allowed for this software to function properly  click for info.

Have you ever found yourself copying and pasting to get your query to look like this->   

Where wonum in ('1662',' 2637','9372','9367')

Now there is a quicker way. 

Just paste the work orders into the first text box and hit the button. Copy from virtually any application and paste directly into Maximo. It's that simple.

This tool will allow you to filter or sort data in programs such as excel and access, then return the data in Maximo for editing.

It is great for closing a lot of jobs at once.

1.) Copy the column of data from excel or any other application (you can even hand type work orders in the textbox).

2.) Make sure you are in the right Query Converter Module.

3.) Paste into the left textbox and choose the correct button (in this case it's the WoNumber button).

4.) As you push the button, the SQL query gets generated in the right textbox.

5.) Press the copy text button (this will copy the query to the global clipboard).

6.) Now you are ready to paste to the advanced query area in Maximo and execute the query.

You Must Sign up as with a membership to use the full software.

Examples of what you can use this Query Tool for:

To complete, close or status a lot of work orders at once.

To query multiple lead crafts at once.

To query certain jobs that you have exported to a spread sheet just by copying the work order numbers.

To query work orders that contain a list of multiple  PM numbers or Job Plan neumbers.

There is no end to this tool.