Using Date Ranges with QBR reports in Maximo 7

Technote (FAQ)


Question

Can we use start and end dates as filters with QBR?

Cause

The QBR creation tool doesn't seem to allow the use of greater than or less than operators.

Answer

To implement Date Range filters in QBR, do the following.

1. Create your QBR, but do not include the Date field as a parameter. Be sure to save.

2. In Report Administration, locate the entry for your new QBR report.

3. Add 2 new Parameters titled 'Enter Start Date' & 'Enter End Date'. Set the Attribute to the Date field in question. Set the operator to <= and >= respectively.

4. You can also add the lookup 'datelookup' so that the user can select the dates from a calendar tool.

5. Save and rebuild the Request page XML.

If you have any difficulty implementing this, please open up a PMR with Support and we can assist.


Cross reference information
Segment Product Component Platform Version Edition
Systems and Asset Management IBM Maximo Asset Management Report Admin Platform Independent 7.1.1, 7.5 All Editions

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Maximo Asset Management
Report Admin

Software version:

7.1.1, 7.5

Operating system(s):

Platform Independent

Software edition:

All Editions

Reference #:

1470557

Modified date:

2013-02-12

Translate my page

Machine Translation

Content navigation