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) Log in to a Istanbul Patch 6+ instance
2) Add variables(Incident Number (reference type to incident), Incident description (multi-line text)) to a catalog item (for example the OOB "Submit an IT Request").
3) Submit the cat item a few times so that we can generate some records in sc_req_item.
5) Set the property glide.ui.optimize.lists to false
6) Create a report on the requested item(sc_req_item) table and  add a filter set to Item = <catalog item created or Submit an IT Request>
7) Run the report It displays one record though it has many on it.
8) Take the filter out and run the report, it shows all the records.
9) Observe in the localhost logs that the transaction from step 7 threw a NPE


Set the following property:


Testing is recommended prior to application in production.

Related Problem: PRB1162821

Seen In

There is no data to report.

Intended Fix Version


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-03-14 10:10:25