Maximo Open Forum

 View Only

 Add expired/expiring items to start center portlet

Jump to Best Answer
  • Everything Maximo
Benita JeffreyMcKensie's profile image
Benita JeffreyMcKensie posted 03-08-2023 10:30

Good afternoon,

I'm looking to add inventory (expired and items expiring within the next 60 days) to my start center portlet.

Does anyone have a query for this?

Adam Ames's profile image
Adam Ames posted 04-11-2023 13:53 Best Answer

Hi Benita,
For SQL the query where clause would look like this,

inventory.status != 'OBSOLETE' and inventory.siteid = (select defsite from maxuser where userid=:user ) and exists(select 1 from invbalances where itemnum = inventory.itemnum and location = inventory.location and siteid = inventory.siteid and itemsetid = inventory.itemsetid and exists(select 1 from invlot where itemnum = invbalances.itemnum and location = invbalances.location and siteid = invbalances.siteid and itemsetid = invbalances.itemsetid and lotnum = invbalances.lotnum and useby <= (getdate() + 60)))

Related Content