Can not use "Does Not Begin With" in my filters

Is there a reason that many of the filter comparison operators can not be user to filter a report, such as "Does Not Begin With".  When using this comparison operator, I get the following error:

However, I just noticed that although the filter say "Does not begin with", the error below says "Not Like"

Description : Invalid sql query near 2017-01-01'}
AND "AR_InvoiceHistoryDetail"."ProductLine" Not Like 'LBSP%'
AND (AR_Customer.CountryCode = 'USA'
OR AR_Customer.CountryCode = 'US' )
AND RTRIM("AR_Customer"."CustomerType") = 'GOV'
AND RTRIM("AR_Customer"."CustomerType") <> 'D'
AND RTRIM("AR_Customer"."CustomerType") <> 'INT'
AND AR_Customer.TaxSchedule <> 'INT'
AND AR_InvoiceHistoryHeader.SalespersonNo <> 'MN'
AND AR_InvoiceHistoryHeader.SalespersonNo <> 'MN'
AND (AR_InvoiceHistoryHeader.ShipToState = 'AR'
OR AR_InvoiceHistoryHeader.ShipToState = 'MS'
OR AR_InvoiceHistoryHeader.ShipToState = 'TN'
OR AR_InvoiceHistoryHeader.ShipToState = 'LA' )
AND (AR_InvoiceHistoryHeader.ShipToZipCode Like '381%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '386%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '387%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '388%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '389%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '390%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '391%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '392%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '393%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '394%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '395%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '396%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '397%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '712%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '713%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '714%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '715%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '716%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '717%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '718%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '719%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '720%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '721%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '722%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '723%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '724%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '725%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '726%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '728%'
OR AR_InvoiceHistoryHeader.ShipToZipCode Like '729%' )
)
GROUP BY
RTRIM("AR_Customer"."CustomerName"),
CASE WHEN AR_Options.Divisions = 'Y'
THEN
"AR_Division"."ARDivisionNo" + '-' + "AR_InvoiceHistoryHeader"."CustomerNo"
ELSE
"AR_InvoiceHistoryHeader"."CustomerNo"
END,
RTRIM("AR_Customer"."CustomerType"),
"AR_InvoiceHistoryHeader"."InvoiceDate",
MONTH("AR_InvoiceHistoryHeader"."InvoiceDate"),
"AR_InvoiceHistoryDetail"."ProductLine",
Year("AR_InvoiceHistoryHeader"."InvoiceDate"),
"AR_InvoiceHistoryDetail"."ItemCode",
AR_InvoiceHistoryHeader.ShipToZipCode,
AR_Customer.AddressLine1,
AR_Customer.AddressLine2,
AR_Customer.City,
AR_Customer.CountryCode,
AR_InvoiceHistoryHeader.ShipToState,
"AR_InvoiceHistoryDetail"."ProductLine" + ' - ' + "IM_ProductLine"."ProductLineDesc",
AR_Customer.State,
AR_InvoiceHistoryHeader.ShipToAddress1,
AR_InvoiceHistoryHeader.ShipToAddress2,
AR_InvoiceHistoryHeader.ShipToCity

Number : -2146233088
Source :
Driver Error : Unknown
SQL State : Unknown

Parents Reply
  • 0 in reply to dhalpin

    Reaching out to any Sage Intelligence user to see if they could quickly test in report manager if you can successfully use the filter "does not begin with". I've tried on numerous installs and get the same error. Wouldn't this be a program issue? The sql statement associated with does not begin with needs to be edited for the program. It's not just one report.

Children
No Data