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.
Hello all:
I've come across a problem that I can't quit figure out. I've been asked by the Warehouse employees to make Item Description sortable on the List tab in Inventory Application. I went to Application Designer > INVENTOR application, and in looking at the properties for Description field and three blocks, Sortable, Filterable, and Show Filter are checked.
The Attribute field for this property has item.description in it, which makes sense to me, this is where the description is coming from.
However, on the List tab in Inventory application, the word "Description" is not underlined which means that a user cannot click on it to sort.
Has anyone else had this same request and if so, how did you resolve it ??
Maximo v7.1.1.5
WebSphere 6.1.0.19
Oracle 9
Thanks!
Tammy Wayman
Chugach Federal Solutions Inc.
We had this request about a year after we went live but then it has really
become a non issue. I think our techs have figured out ways around it. I
haven't heard this complaint for over three years.
When we looked at it we figured we would have to create a
inventory.description column then use a trigger to keep it updated from
item.description. The issue wasn't big enough to warrant that solution.
Kevin Wertz
Grifols, Inc.
Clayton, NC
On Wed, Aug 24, 2011 at 2:20 PM, tpw5511 <weatherfree@comcast.net> wrote:
> **
>
>
> Hello all:
>
> I've come across a problem that I can't quit figure out. I've been asked by
> the Warehouse employees to make Item Description sortable on the List tab in
> Inventory Application. I went to Application Designer > INVENTOR
> application, and in looking at the properties for Description field and
> three blocks, Sortable, Filterable, and Show Filter are checked.
>
> The Attribute field for this property has item.description in it, which
> makes sense to me, this is where the description is coming from.
>
> However, on the List tab in Inventory application, the word "Description"
> is not underlined which means that a user cannot click on it to sort.
>
> Has anyone else had this same request and if so, how did you resolve it ??
>
> Maximo v7.1.1.5
> WebSphere 6.1.0.19
> Oracle 9
>
> Thanks!
> Tammy Wayman
> Chugach Federal Solutions Inc.
>
>
>
Could be a possible solution for us. Thanks so much for the suggestion, Kevin.
--- In MAXIMO@yahoogroups.com, Kevin Wertz <wertzee@...> wrote:
>
> We had this request about a year after we went live but then it has really
> become a non issue. I think our techs have figured out ways around it. I
> haven't heard this complaint for over three years.
>
> When we looked at it we figured we would have to create a
> inventory.description column then use a trigger to keep it updated from
> item.description. The issue wasn't big enough to warrant that solution.
>
> Kevin Wertz
> Grifols, Inc.
> Clayton, NC
>
> On Wed, Aug 24, 2011 at 2:20 PM, tpw5511 <weatherfree@...> wrote:
>
> > **
> >
> >
> > Hello all:
> >
> > I've come across a problem that I can't quit figure out. I've been asked by
> > the Warehouse employees to make Item Description sortable on the List tab in
> > Inventory Application. I went to Application Designer > INVENTOR
> > application, and in looking at the properties for Description field and
> > three blocks, Sortable, Filterable, and Show Filter are checked.
> >
> > The Attribute field for this property has item.description in it, which
> > makes sense to me, this is where the description is coming from.
> >
> > However, on the List tab in Inventory application, the word "Description"
> > is not underlined which means that a user cannot click on it to sort.
> >
> > Has anyone else had this same request and if so, how did you resolve it ??
> >
> > Maximo v7.1.1.5
> > WebSphere 6.1.0.19
> > Oracle 9
> >
> > Thanks!
> > Tammy Wayman
> > Chugach Federal Solutions Inc.
> >
> >
> >
>
>
>
>
I would agree with Kevin's approach, even though it is duplicating data
there are significant issues associated with trying to add relationship
fields to the list tab. It can be done but you need to realize that the way
Maximo populates the data is through the MBO, as such if you filter or try
to sort it is making a call to the child MBO for every record and very
quickly becomes an efficiency issue as the number of MBO/database calls
increases rapidly.
As a general rule I'd avoid using relationship fields in fields that are
filterable or sortable unless it is absolutely necessary. If you made it so
it cannot be filtered or sorted the impact is reduced but then the benefits
you are looking to gain are also diminished.
Chris.
On Thu, Aug 25, 2011 at 9:13 AM, tpw4498 <weatherfree@comcast.net> wrote:
> **
>
>
> Could be a possible solution for us. Thanks so much for the suggestion,
> Kevin.
>
>
> --- In MAXIMO@yahoogroups.com, Kevin Wertz <wertzee@...> wrote:
> >
> > We had this request about a year after we went live but then it has
> really
> > become a non issue. I think our techs have figured out ways around it. I
> > haven't heard this complaint for over three years.
> >
> > When we looked at it we figured we would have to create a
> > inventory.description column then use a trigger to keep it updated from
> > item.description. The issue wasn't big enough to warrant that solution.
> >
> > Kevin Wertz
> > Grifols, Inc.
> > Clayton, NC
> >
> > On Wed, Aug 24, 2011 at 2:20 PM, tpw5511 <weatherfree@...> wrote:
> >
> > > **
> > >
> > >
> > > Hello all:
> > >
> > > I've come across a problem that I can't quit figure out. I've been
> asked by
> > > the Warehouse employees to make Item Description sortable on the List
> tab in
> > > Inventory Application. I went to Application Designer > INVENTOR
> > > application, and in looking at the properties for Description field and
> > > three blocks, Sortable, Filterable, and Show Filter are checked.
> > >
> > > The Attribute field for this property has item.description in it, which
> > > makes sense to me, this is where the description is coming from.
> > >
> > > However, on the List tab in Inventory application, the word
> "Description"
> > > is not underlined which means that a user cannot click on it to sort.
> > >
> > > Has anyone else had this same request and if so, how did you resolve it
> ??
> > >
> > > Maximo v7.1.1.5
> > > WebSphere 6.1.0.19
> > > Oracle 9
> > >
> > > Thanks!
> > > Tammy Wayman
> > > Chugach Federal Solutions Inc.
> > >
> > >
> > >
> >
> >
> >
> >
>
>
>