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.
------------------------------
Julio Hernandez
Ergonare, Inc.
------------------------------
Original Message:
Sent: 10-28-2025 08:08
From: Jason Johnson
Subject: Search for assets used as tools
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).
#Administration
------------------------------
Jason Johnson
RSI
------------------------------