Hi I'm new here. I'm lost in Google-ing for the answer, so I hope you guys can help me out. I'm using Cognos with IBM Maximo.
I'm trying to build a report, which combines detailed information of each workorder, combined with a list of child activities:
Page 1:
WO 1 details
- Activty 1.1
- Activty 1.2
- Activty 1.3
- Activty 1.4
Page 2:
WO 2 details
- Activity 2.1
- Activity 2.2
I've managed to build a Page Set to display the detail information of each workorder in a table of singletons. Now I would like to add a list of only the activaties of each workorder, which are parent=wonum (workorder number).
My page set has a query that selects workorder 1 to 10, so I have 10 pages with workorder details, but when I add the query for the activities with the filter parent=wonum, it displays all activties for wonum 1 to 10. So my question is, how can I filter on only the wonum that is displayed on that page?
I managed to fix this by setting up 2 master-detail relationships. First one on the page in Page Explorer, where there's a relation between the main query and the query used to display the main WO on every page.
Second relationship is on the sub list with the parent-child relation ship between the query of the main WO per page, and the query of the sub details.
Good luck!