23 views

Description

Multilevel Pivot export: When executing export from report designer or report builder, the filter is not applied and an exception from ReportSource.getFullQuery is logged.

Steps to Reproduce

  1. Enable WHTP plugin.

  2. Create a new multilevel pivot.

    For more information, see the product documentation topic Create a multilevel pivot report.

  3. Export from the Report Designer, without scheduling.

  4. Check the logs.

    Note that they contain an exception such as the following:

    Invalid query detected, stack trace below [Unknown field null in table incident]
    Query [undefined]
    com.glide.db.QueryEventLogger.logInvalidQuery(QueryEventLogger.java:57)

    Also, if there was a filter, the export does not honor it.

Workaround

This issue is under review. To receive notifications when more information is available, subscribe to this Known Error article by clicking the Subscribe button at the top right of the article. If you are able to upgrade, review the Fixed In and Intended Fix Version fields to determine whether any versions have or are planned to have a permanent fix.

 


Related Problem: PRB1294262

Seen In

There is no data to report.

Intended Fix Version

Madrid

Fixed In

London Patch 1

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-08-13 16:26:21
Published:2018-08-13