Request Parameter

Hi!

We have a special request. We want to provide a lookup for static values at the request Parameter page in MAXIMO. For Example:
.) last year
.) last month
.) last week
.) last day

Does anybody know, if this is possible? If I want to provide a look up I have to insert an attribute. but an attribute always maps to a table field in the db?

Thanks a lot for any help!
Chris

Find more posts tagged with

Comments

voller

No ideas???

Thanks Chris

SpaceMan

From what i understand, you can only use textbox parameters in Maximo using 2.1.2. I'm not sure if this changes when you use 2.3.2.

luananicho

I have an exammple of a dynamic date option where you can select dynamic dates for start and end dates (like yesterday, last month, last 12 months, etc.). Is that what you're looking for? I've attached an example.

sbryden

luananicho, Thanks for the example.....

How do you get the static parameter list to display in the requester page in Maximo? Did you have to do anything special on the import of the report or in the reports.xml file for the app folder you placed the report in?

sbryden

This is the only way I know to display a static list for parameters in Maximo 7.1 using BIRT. IF you discover another way, please let me know.

1. Create an ALN domain in the Domains app with your static value list

2. Go to Database Configuration and bring up the main table the report is being ran against (if the report is going to reside within the INVENTORY app, you bring up the INVENTORY table).

3. Add a new column that you will assign this parameter to when setting up the request page and apply the domain you just created to this new column

4. Reference your new field when setting up the request page parameter and use “valuelist” or “valuelistwithvalueonly” as the lookup

luananicho

I finally figured out how to display the static list in Maximo (using the BC70 example above this post).

1. In BIRT, make the DyDate parameter required. I also added another value called [NONE] which is the default.
2. Import the new report to Maximo Report Administrator.
3. When you import and Save, Maximo brings in all the report parameters to the Parameters section at the bottom of the page. Delete them and Save again.
4. Build the Request Page.

When you run the report, you'll get a Request Page with only the e-mail and scheduling sections (no parameters). Since the DyDate parameter is required but Maximo doesn't include it in the report parameters, when you click Submit, the BIRT parameters dialog will pop up.

I've also tested with leaving some parameters on the Maximo Parameters list and deleting just the StartDate, EndDate, and DyDate parameters. That works too. Maximo will include the other parameters on the Request Page, but the dialog for the date parameters (along with all the others) will pop up after you click Submit.

Another interesting note, in Maximo, you determine the order of the parameters by sequence field on the Report page. For the BIRT parameters, it puts them in the order they appear in the BIRT report. So, I moved the date parameters to the top of the parameters list so they appear first.