This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
The following was an IBM Notification knowledge base update regarding the WHEREUSED table (sent out 11/29)
Problem(Abstract)
User: The filter for the 'Used On table window' for the Inventory's "Where Used" tab should be enabled by default.
Diagnosing the problem
The following steps have been used to reproduce the problem
1. Go to Inventory.
2. Go to the Where Used tab.
3. In the Used On table window, open the filter row.
~~Notice the Filter Icon is grayed out
Resolving the problem
This is working as design
. such that the Where Used tab in Inventory application is based on a non-persistent object, i.e. there is no WHEREUSED data in the database, and as a result you cannot filter this.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
I have some additional thoughts.
The above answer is technically correct.
There is no FILTER on Inventory application for WhereUsed tab.
The WHEREUSED table is nonpersistent and doesn't really exist,
.but SPAREPART does.
~~~~~~~~~~~~~~~~
So, if the user wanted to search for all assets against an item he could goto the ASSET application and create a Query (using a nested select).
" where ASSETNUM in (select ASSETNUM from SPAREPART where ITEMNUM = `1000') "
Of course this requires that the user have access to the Where clause and understand SQL.
Option 2 might be:
1) Change the Inventory screen design.
2) The current whereused table window is based on a relationship between inventory and the non-persistent object called WHEREUSED which creates the filter problem. The WHEREUSED object is just a different object of the Spare Parts.
3) If you created a relationship from INVENTORY to SPAREPART where the item, item set, and site id matched, it would produce a list of assets for that site that have the item on their spare parts list.
4) Then using app designer, change the relationship on the where used table window to the new one just created.
5) Note: assuming that all the columns are all named the same between SPAREPART and WHEREUSED so the table window would be fine. If not, adjust the attribute names accordingly.
6) Since SPAREPART is a persistent object, the filter should work fine then.
Note: You could also setup a similar relationship between ITEM and SPAREPART (minus the sited) and add a where used tab to the Item Master. This would show a list of assets that reference that part across all sites.
w/br
John Reeve
Manager, Practice Leader Maintenance and Reliability Solutions
Cell: 423 314 1312
http://www.linkedin.com/pub/john-reeve/11/644/9b2