When attempting to create reports, if adding a field from a variable, the report will default to only showing the first record and nothing further. Furthermore, if using group by, it will recognize other records are available but not show them.


Steps to Reproduce

  1. Edit a catalog item such as Submit an IT request.
  2. Add these variables: Incident Number (reference type to incident), Incident description (multi-line text).
  3. Submit the catalog item a few times to generate some records in sc_req_item.
  4. Set the system property glide.ui.optimize.lists to false.
  5. Create a report on the requested item table (sc_req_item), andadd a filter for Item = <catalog item created or Submit an IT Request>.
  6. Run the report. Observe only one record is displayed, even though there are many records.
  7. Remove the filter and run the report again. Observe all records are shown.


This problem is targeted to be fixed in upcoming patches. The recommended workaround is to have both properties listed below set to their default value of true.



Also see the workarounds to the behaviour described in KB0529493 where dot-walked fields in a list report would not load properly if the referenced property glide.ui.list.optimize is set to true.  It is recommended to set both properties mentioned to true and, if necessary, to first apply the first two workarounds suggested in PRB573139.

Related Problem: PRB1162821

Seen In

There is no data to report.

Intended Fix Version

Jakarta Patch 10
Kingston Patch 7

Fixed In

Jakarta Patch 8a Hot Fix 2

Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-06-08 11:27:17