Maximo Open Forum

We are looking for a where clause to find all assets that have been used as a tool on a workorder. My first thought is:

assetnum in (select asset from TOOLTRANS where assetnum is not null)

But the assets returned do not have anything in their "View Tool Usage" (at least none that were spot checked).

You wrote that you were thinking of using the following WHERE clause:

assetnum in (select asset from TOOLTRANS where assetnum is not null)

I assume you meant to say:

assetnum in (select assetNum from TOOLTRANS where assetnum is not null)

Anyways, the problem is that it should be:

assetnum in (select RotAssetNum from TOOLTRANS where assetnum is not null)

The AssetNum in the ToolTrans is the Asset being charged, which normally defaults to the AssetNum on the WO being charged.  The RotAssetNum represents the Asset that was used.

You are correct, sorry about the oversight. And your where clause did the trick, thank you so much!

assetnum in (select asset from TOOLTRANS where assetnum is not null)