Can the DESCRIPTION_LONGDESCRIPTION field be used in a Query Based Report ?

Technote (FAQ)


Question

Can the DESCRIPTION_LONGDESCRIPTION field be used in a Query Based Report ?

Answer

Please check if DESCRIPTION_LONGDESCRIPTION is a persistent field or not.

- Go to the Database Configuration application.

- Open the object having the DESCRIPTION_LONGDESCRIPTION attribute. eg) WORKORDER

- Go to the Attribute tab and find the DESCRIPTION_LONGDESCRIPTION attribute.

As you can see, the DESCRIPTION_LONGDESCRIPTION attribute is not persistent. This means that this field does not exist on disk in a database table but only exists as a memory structure.

So the answer is no, the DESCRIPTION_LONGDESCRIPTION field cannot be used in a Query Based Report.


Any non-persistent fields such as DESCRIPTION_LONGDESCRIPTION cannot be used in Query Based Report.

To add longdescription in QBR report, you can configure the Work Order ROS (Report Object Structure) to include the child Long Description object using the relevant relationship.

For more detail, please reference below URL.
https://www.ibm.com/developerworks/mydeveloperworks/blogs/a9ba1efe-b731-4317-9724-a181d6155e3a/entry/bilog_brownies_bronies_and_adding_ld_to_ros2?lang=en

Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Maximo Asset Management
Report Admin

Software version:

7.1, 7.1.1, 7.5

Operating system(s):

Platform Independent

Reference #:

1568123

Modified date:

2014-10-03

Translate my page

Machine Translation

Content navigation