IBM Support

Result Set Portlet in 7.6

Technical Blog Post


Abstract

Result Set Portlet in 7.6

Body

There is a change of function in 7.6 to allow info from related records to be displayed in result set portlets. 

For example, below are the steps to display the name of the reported by person for Service Requests:

1 Create a new object structure for SR
2 Consumed by is REPORTING
3 Enter 2 rows in the source objects:
   - SR object
   - Person object (parent object is SR, relationship is PERSON).

   Enter a description in the Reporting Description  field.  Enter Single in the Cardinality field
4 Save the record
5 Grant access to security group in the report administration application via the “Report Object Structure Security” action
6 Go to Start Center.  Add the Result Set Portlet by Clicking on the Change Content/Layout icon

NOTE: Layout and Configuration application needs to be granted to the Security Group

7 Click the Edit icon from the Result Set Portlet.

Application is SR. 

Go to the Query field.  Select a saved query from the SR application

Select SR from the Object List and add Service Request

Select Person from the Object List and add Name, First Name, Last Name
image

 

 

 

 

 

 

 

6  Click Save and click the Finish button
7 The result set will look like the screen shot below:

image

Below are the links for technotes and documentation:

https://www.youtube.com/watch?v=DWdAdTYIvfw

https://eclient.lenexa.ibm.com:9445/search/?fetch=source/TechNote/1980423

http://www.ibm.com/support/knowledgecenter/SSLKT6_7.6.0/com.ibm.mbs.doc/startcntr/t_disp_rel_obj_att_res_set.html

 

The old way below is no longer applicable to 7.6

/support/pages/node/405839

[{"Business Unit":{"code":"BU005","label":"IoT"}, "Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11131063