Maximo List Archive

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.



Set a default value to a table column filter

From: shirleyvelez.pmtech (2015-02-04 08:53)

I need to set up some default values for the filters that appear on the opening screen of the applicatios. For example as it is set in Asset in which the site is set to a default. How can I do that?


From: swkim (2015-02-05 09:28)

I am curious how to do this as well. I know for Inventory > Item Master... the !=OBSOLETE filter is in the java .class file that is called when the module is run. Hope you don't have to customize the .class file.


From: Shirley Velez (2015-02-05 13:35)

We're working with IBM on this, I'll let you know. For now, they've sent me
this link but I truly don't know how to do it
http://www-01.ibm.com/support/docview.wss?uid=swg21508907
On Feb 5, 2015 1:28 PM, "swkim@getty.edu [MAXIMO]" <MAXIMO@yahoogroups.com>
wrote:
>
>
> I am curious how to do this as well. I know for Inventory > Item Master...
> the !=OBSOLETE filter is in the java .class file that is called when the
> module is run. Hope you don't have to customize the .class file.
>
>
>
>
>


From: therron (2015-02-05 11:04)

Please clarify this for me: Do you want a static filter or a dynamic filter? If you want a static (not changing, same for everyone) filter, I can help you. If you need a dynamic filter (which is what I think you are asking for -- Person A works at Site X so he needs it to filter to Site X, but Person B works at Site Y so he needs it to filter to Site Y) I don't think I can help -- unless you made a static filter, copied/cloned the app, changed the static filter for the cloned app, and then through Security settings you have Person A access the app with that static filter and the other person uses the other app.

Travis Herron


From: incomm (2015-02-05 11:26)

For a static value like 'OBSOLETE' you should be able to do it by adding a Default Value control to the List tab's table object, then setting it to whatever value you need (make sure the Default type is Query).

For a dynamic value, it may be possible to use the Default Value control as well, and do something similar to the setup for a custom application with parent-child, i.e. use the Data Source ID and From Attribute fields in that control. It works with a parent-child relationship (automatically setting the filter for the child records to match the unique value in the parent record), but I've never tried it with other scenarios.

The above setup is only designed to have a default filter on the List tab, which the user can remove if they want to. If you don't want the user to be able to remove the filter, then you'd have to switch to a data restriction or an application restriction.



From: Shirley Velez (2015-02-05 15:33)

It's just when I try to add Default Value to this field the application
says I can't use it in a table column
On Feb 5, 2015 3:27 PM, "incomm@shaw.ca [MAXIMO]" <MAXIMO@yahoogroups.com>
wrote:
>
>
> For a static value like 'OBSOLETE' you should be able to do it by adding a
> Default Value control to the List tab's table object, then setting it to
> whatever value you need (make sure the Default type is Query).
>
> For a dynamic value, it may be possible to use the Default Value control
> as well, and do something similar to the setup for a custom application
> with parent-child, i.e. use the Data Source ID and From Attribute fields in
> that control. It works with a parent-child relationship (automatically
> setting the filter for the child records to match the unique value in the
> parent record), but I've never tried it with other scenarios.
>
> The above setup is only designed to have a default filter on the List tab,
> which the user can remove if they want to. If you don't want the user to be
> able to remove the filter, then you'd have to switch to a data restriction
> or an application restriction.
>
>
>
>
>
>
>


From: incomm (2015-02-05 12:13)

Yeah, you have to add it to the far left-hand side of the table control, where it says "tablebody ..."