valuelist lookup is not working

Hi!
I need a solution for the following problem.

Actually the requirement is to get all the status of WO in a lookup in the name of All and all the status of WO excluding the "CLOSED" and "CANCEL" in another lookup in the name of Prnding.
I desgnined this report in BIRT 2.3.2 with 2 static list parameters. For this report I have created a new attribute in the name of custom_status which includes all the status excluding the "CANEL" and "CLOSED".
Also I have created a domain "CUSTOM_STATUS" and binded with the CUSTOM_STATUS attibute. Then I created 2 parameters in Maximo as Pending and All.
A lookup in the name of "valuelist" is also created. Pending is binded with the newly created attribute "CUSTOM_STATUS" and the lookup is valuelist.
All is binded with the original STATUS attribute, lookup for this is also valuelist. The thing is, I could pick value from the Pending list, but the report is not showing any data. 0 records is the result. Whats wrong in this? How to get data?

Looking for the reply.....

Thanks,
Preethisha

Find more posts tagged with

Comments

mwilliams

Hi Preethisha,

I'm not sure I'm quite understanding. You're trying to use parameters in BIRT to limit your data but you're getting 0 records every time? Can you explain this a little more? Thanks.

Preethisha

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="72669" data-time="1296144667" data-date="27 January 2011 - 09:11 AM">
Hi Preethisha, 
 
I'm not sure I'm quite understanding. You're trying to use parameters in BIRT to limit your data but you're getting 0 records every time? Can you explain this a little more? Thanks. </blockquote>
 
 
Williams, 
 
I am using two parameters named "pending" and "all". In the pending status, I have added a list of values for the WO status excluding two values "CANCEL" and "CLOSED". 
In all, I haved added all the status values such as APPROVED, WAPPR, INPROG, CANCEL, CLOSED. In BIRT designer, The report is showing correct data. But when I import in MAximo 7.1.1.7 application, Its not getting any records. 
Provided, In Maximo, a look up for fetching the WO Status is there named "STATUS". But I need to get all the status in All parameter. So I have used this status lookup and binded with the status attribute. For the Pending parameter, 
I needed a lookup which will show the WO status excluding the CANCEL and CLOSED. So, I created a synonym domain as CUSTOMP_STATUS and created a custom attribute as CUSTOM_STATUS which will have the WO status excluding CANCEL and CLOSED. 
Then I binded this domain with this customised attribute CUSTOM_STATUS. Moreover, I have a lookup named valuelist. I have used this lookup for both of these parameters Pending and All. In both the Parameters, valuelist is showing correct list of status. 
This CUSTOM_STATUS domain restricts the CANCEL and CLOSED in the look up. I could pick the value for the lookups. I generated the request page. Once I go for the preview, Its showing 0 records. THis happened in Maximo 7.1.1.7. 
Provided, I could get the correct data in BIRT designer 2.3.2. Really I have got confused that whay the same rptdesign is not fetching any records in MAximo application. 
 
waiting for ur reply..... I have attached the rptdesign. pls find it in the attachment

mwilliams

I don't have any experience with Maximo, but it sounds like it's an issue with Maximo and not with BIRT since it works in BIRT, but just not when you use it in Maximo. I will move this post into the Maximo forum. Maybe someone in there has seen this issue before and will know if there is a solution.