Adding a dot notation/joined attribute to a Result Set portlet in Maximo.

Answer

When you first set up a result set portlet, you are presented with a list of persistent attributes/columns for the object that the query is based on. These attributes are initially pulled from Maximo Data Dictionary and then placed inside the RESULTSETCOLS table. By default, there is no available related object attribute or dot-notation/join attributes.

To add a related/dot notation attribute, perform the following (see example below):

1. Prepare and execute an insert statement for your particular database.
2. Delete the existing portlet.
3. Reconfigure the portlet.

The new dot notation column should now be available in the Column display tab.


Example:
You need to see LOCATION.DESCRIPTION in a result set configured with a query based on the Work Order Tracking (WOTRACK) application, where LOCATION is the name of the relationship WOTRACK object has with LOCATION object.

If a portlet was created previously using a query based on WOTRACK, data would exist in the RESULTSETCOLS table where APP=WOTRAK.


Sample insert statements
Prepare and execute an insert statement similar to the ones shown below, depending upon your database product:

ORA (Oracle):
insert into resultsetcols
( app, attribute, maintable, resultsetcolsid ,rowstamp)
values
('WOTRACK', ' LOCATION.DESCRIPTION ', 'WORKORDER', resultsetcolsseq.nextval, maxseq.nextval);


DB2:
insert into resultsetcols
( app, attribute, maintable, resultsetcolsid)
values
('WOTRACK', 'LOCATION.DESCRIPTION ', 'WORKORDER', nextval for resultsetcolsseq);

update maxsequence
set maxreserved=(select max(resultsetcolsid) from resultsetcols)
where tbname='RESULTSETCOLS' and name='RESULTSETCOLSID';


SQS (Microsoft SQL Server):
insert into resultsetcols
( app, attribute, maintable, resultsetcolsid)
values
('WOTRACK', ' LOCATION.DESCRIPTION ', 'WORKORDER', resultsetcolsseq.nextval);