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.
Hi
This query is used to lists items below reorderpoint from the inventory application:
Where minlevel > (select sum(curbal) from invbalances where itemnum = inventory.itemnum and location = inventory.location and itemsetid = inventory.itemsetid)
We would however like to be able to make the same question but from the itemmaster application, do be able to put it on a startcenter and display description fields and so on.
Anyone can help me out?, this is way beyond my SQL skills.
BR/David
Try
itemnum in (select itemnum from inventory where minlevel > (select
sum(curbal) from invbalances where itemnum = inventory.itemnum and location
= inventory.location and itemsetid = inventory.itemsetid) and itemnum =
item.itemnum)
Chris
On Sat, Dec 21, 2013 at 5:00 PM, <david.andersson@ericsson.com> wrote:
>
>
> Hi
>
>
> This query is used to lists items below reorderpoint from the inventory
> application:
>
> Where minlevel > (select sum(curbal) from invbalances where itemnum =
> inventory.itemnum and location = inventory.location and itemsetid =
> inventory.itemsetid)
>
> We would however like to be able to make the same question but from the
> itemmaster application, do be able to put it on a startcenter and display
> description fields and so on.
>
> Anyone can help me out?, this is way beyond my SQL skills.
>
> BR/David
>
>
>
Hi Chris
No, diden't work, question times out.
Hello ,
if your problem is with the description field or any related field , you can still use this query and use the following link to know how to show the description from item table :
https://www-304.ibm.com/jct01003c/support/docview.wss?uid=swg21415976
Best regards,
Amir Anwar
Senior Software Engineer
Beshay Steel Egypt
On Sunday, December 22, 2013 1:13 AM, "david.andersson@ericsson.com" <david.andersson@ericsson.com> wrote:
Hi Chris
No, diden't work, question times out.
Hi Chris, I've got a couple of quick questions:
What Version of Maximo (Please always post this with a question)?
Does the query work correctly in Item Master, and not in a result set?
If so, what attributes do you need to show in the Result Set Portlet?
Let me know, Brian
Hi Brian
We are on 7.5, the query below provided by Chris doesn't work from itemmaster ( or from a resultset ). The attributes we want to show on the portlet is mainly the description and two extra fields so I guess the solution provided by Amir will work. But if you can see whats wrong wit the query so feel free:
itemnum in (select itemnum from inventory where minlevel > (select sum(curbal) from invbalances where itemnum = inventory.itemnum and location = inventory.location and itemsetid = inventory.itemsetid) and itemnum = item.itemnum)
BR/David