Excludes Lowe’s Business Credit accounts, Lowe’s Visa® accounts and all Lowe’s Canada Credit accounts. Offer cannot be used in conjunction with or on: (i) other credit-related promotional offers (ii) any other promotion, discount, markdown, coupon/bar code, rebate or offer, including any Lowe’s volume or special discount programs (such as but not limited to Contractor Packs™, Buy in Bulk, Quote Support Program (“QSP”), Special Value, New Lower Price, Was:Now, Military Discount, employee discount and Lowe’s Price Match Guarantee) (iii) associate-discretion price adjustments (iv) any services (such as but not limited to rentals extended protection/replacement plans shipping, delivery, assembly or installation fees) (v) fees or taxes (vi) previous sales (vii) gift cards or (viii) Weber or Kichler products. 5% discount will be applied after all other applicable discounts. Valid for purchases in US stores and on. Get 5% off your eligible purchase or order charged to your Lowe’s Advantage Card. String values must be delimited by single quotation marks.įor more information about data types and other information about conventions and standards for OData, see OData Version 4.01.5% Off Your Lowe’s Advantage Card Purchase: You must use the appropriate notation for different data types with filter expressions. Referencing Different Data Types in Filter Expressions
#Sloan royal dual filter bypass 1.0 uri code#
Returns true for customers with the string RED in their location code starting as position 5.įilter=tolower(Location_Code) eq 'code red'įilter=concat(concat(FText, ', '), FCode) eq '2nd row, CODE RED' Returns customer records for customers having a location code beginning with the string BLUE.įilter=replace(City, 'Miami', 'Tampa') eq 'CODERED'įilter=substring(Location_Code, 5) eq 'RED' Query on Customer service. Returns customer records for customers with names containing the string “urn”.įilter=indexof(Location_Code, ‘BLUE’) eq 0 Query on Customer service. Returns all customers names beginning with “S”.įilter=substringof(Name, ‘urn’) Query on Customer service. Returns all customers with VAT_Bus_Posting_Group values that end in RT.įilter=startswith(Name, 'S') Query on Customer service. Returns entry numbers up to and including 610.įilter=endswith(VAT_Bus_Posting_Group,'RT') Query on Customer service. Returns entry numbers 610 and higher.įilter=Entry_No le 610 Query on GLEntry service. Returns entry numbers that are less than 610.įilter=Entry_No ge 610 Query on GLEntry service. However, you cannot use OR operators to apply filters on two different fields.įilter=Entry_No lt 610 Query on GLEntry service. Alert: You can use OR operators to apply different filters on the same field. Returns customers in Spain and the United States. Returns customers in Spain where Payment_Terms_Code= 14 DAYS.įilter= Country_Region_Code eq 'ES' or Country_Region_Code eq 'US' Query on Customer service. Returns entry numbers 611 through 614.įilter=Country_Region_Code eq 'ES' and Payment_Terms_Code eq '14 DAYS' Query on Customer service. Definitionįilter=Entry_No gt 610 and Entry_No lt 615 Query on GLEntry service. The reason is that filters that do not have equivalent C/AL expressions are processed on the Microsoft Dynamics NAV Server tier, while filters that do have equivalent C/AL expressions are processed on the Dynamics NAV database tier. All examples are based either on page 21, Customer (published as Customer), or on page 20, General Ledger Entry (published as GLEntry).įilters that do not have equivalent C/AL expressions might take longer to process compared to filters that do have equivalent C/AL expressions. The following table shows the filters that are supported in Dynamics NAV OData web services and the equivalent C/AL filter expressions.
For example, the following URI filters the City field in the Customer page to return all customers who are located in Miami: International Ltd.')/Customer?$filter=City eq 'Miami' To add a filter to an OData URI, add $filter= to the end of the name of the published web service.
This topic identifies the filter expressions that you can use, describes the equivalent field or table filter that you can use in C/AL, and presents examples to show the syntax for using filter expressions in OData web service URIs and applications. You can use filter expressions in OData URIs to limit the results that are returned in an AtomPub document.