Skip to main content

Which Tables populate the ‘Loose Inventory Due Tab’? Maintenix Version 8.3, SP5 u25.

 

With the Tab description:

Loose Inventory Due idTabLooseInventoryDue A list of loose inventory items that have accumulated enough usage to require maintenance. Use this tab to coordinate the execution of that maintenance work.

 

It is going to be several tables I’m sure, INV_INV being a primary table (for the inventory itself) and likely SCHED_STASK (the activated task(s) against the Inventory).

What are you trying to accomplish by knowing the tables where that data is drawn from?

Hi Tim.

Currently our Loose Inventory Due Tab is empty. Even though there is inventory removed for access and NOT Turned In. The removed Inventory has plenty of SCHED_STASKs. But we do not see any Inventory, Tasks or Dates on the Tab. I wasn’t sure whether the Tab is connected to an ‘Materialised View’ to populate or particular scenarios which trigger the inventory to appear on the Tab.

 

Thanks 

Reg

Looks like that Tab uses a query where the logic is:

  • It is LOOSE INVENTORY
  • Not yet issued
  • IS Serviceable 
  • IS Authorized for the current user to view
  • Has at least one non-historic task due WITHIN THE MINIMUM USAGE FOR RELEASE ← probable reason #1
  • Exclude NaN situations (not sure what NaN stands for)
  • % of remaining usage is greater than the minimum for release >(usage remaining qty/interval)<minimum usage %] ← #2

I’m guessing the minimum usage % remaining is why nothing is showing up...meaning it is not close ENOUGH to trigger it to show up in the queue.

Thanks Tim. I hadn’t considered MINIMUM USAGE FOR RELEASE as being a factor.

Hey Reg,

You can find the qrx driving this page as plain text inside the Maintenix ear. I keep a copy of Maintenix on my computer with all the war and jar files extracted for occasions such as this, so that I can share the information that you will be able to see without access to the full source code.

If you install a copy on your local computer you can extract apps\assetmanagement\app\assetmanagement.ear\maintenix.war. I extracted all the archive files in this folder into their own respective folders.

Within \maintenix\WEB-INF\lib you will find and extract maintenix.jar.

From here you can find the folder maintenix\com\mxi\mx\web\query\todolist which contains the queries that populate all the To Do Lists. LooseInvDue.qrx is used for this page. As explained by Tim, it’s likely that you are not seeing this inventory because it is not turned in (issued_bool = 0).

Thanks Rob.

Reply


Terms & ConditionsCookie settings