Maximo Open Forum

 View Only

 Querying Assets without a classification

Jump to Best Answer
  • Administration
  • Assets
  • End User
  • Functional
Tim Pratt's profile image
Tim Pratt posted 03-10-2021 08:51
Hi Everyone, I am trying to build a query in the assets application to search for assets without a classification associated with them. I have tried using the ~null~ wildcard in the advanced search, but that is clearly not going to do it as that returns no results. I am assuming because this field actually lives on the CLASSSTRUCTURE object, I need to reference that somehow, but I'm not quite sure how. Any assistance in this area would be greatly appreciated.
Prajesh Pradhananga's profile image
Prajesh Pradhananga Best Answer
Hi Tim,

There is an attribute (classstructureid) in Asset object that get populated when Asset is classified. You can try using below in Where Clause search.

(classstructureid is null)