If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

List query, filtered by singleton ID on detail page

Started by sfs, 09 Sep 2013 04:49:27 AM

Previous topic - Next topic

sfs

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?

sfs

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!