Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Archive > 2018Jan2 - Deletes > Reports that use LIKE with an asterisk return no results

Reports that use LIKE with an asterisk return no results

Created by Su-Lyn Rosenberry-ret, last modified by Kevin.Swinson on Jan 02, 2018

Views: 633 Votes: 0 Revisions: 4

Overview

 

When you use LIKE with an asterisk together in a custom SQL or SWQL filter in Orion Report Writer reports, the report displays no results. Some versions of the product may display an SQL error.

 

For example, a filter like the following causes the report to return no results.

 Caption Like 'AX3-*'

Environment

  • Orion Platform 2015.1.2 and later
  • NPM 11.5.2 and later
  • SAM 6.2 and later

 

Cause 

When the filter is saved, some of the characters are stripped.

 

 

 

Last modified

Tags

Classifications

Public