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 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:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.