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

Views: 14

Replies to This Discussion

RSS

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service