{"id":30560,"date":"2021-11-30T14:35:08","date_gmt":"2021-11-30T14:35:08","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=30560"},"modified":"2025-07-09T09:45:06","modified_gmt":"2025-07-09T09:45:06","slug":"how-to-apply-filter-on-views-in-sage-300-net-api","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/","title":{"rendered":"HOW TO APPLY FILTER ON VIEWS IN SAGE 300 .NET API"},"content":{"rendered":"\n<p>Sage 300 ERP web screens functionalities are being improved with every new release. Sage300c provides various ways to read records of ACCPAC views by opening and composing the business views in .net API. Sometimes we need to set filter on view records for that purpose Sage300c .net API provides us view&#8217;s &#8216;browse&#8217; method.<\/p>\n\n\n\n<p><strong>New Stuff:-<\/strong> <a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/24\/damaged-data-error-in-sage-300\/\" data-type=\"URL\" data-id=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/24\/damaged-data-error-in-sage-300\/\">Damaged Data Error in Sage 300<\/a><\/p>\n\n\n\n<p>So, in this blog we will discuss about browse method used in .Net API and then we can use various methods like Fetch, Go Next, Go Top etc. to iterate through the records. Syntax for Browse method is:<\/p>\n\n\n\n<p>&nbsp;\u201cviewName.browse(string filter, bool ascending)\u201d.<\/p>\n\n\n\n<p>The parameters used in this method are as follows:<\/p>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>Filter: Filter is a simple string that will be passed to the browse method in the .net API to retrieve records based on specific filter. Expressions are evaluated strictly from left to right unless expression contains brackets. Operands must have same datatype. If a constant is string, then it must be enclosed in quotes (\u201c\u201d). Boolean fields are always TRUE or FALSE.<\/li><\/ol>\n\n\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The format of the filter string:<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u201cstring searchFilter = [(condition)(Boolean Operator)(condition)];\u201d<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Condition: operands with relational operator.<\/li><li>Boolean Operator: AND, OR.<\/li><li>Operand: Field name or constants.<\/li><\/ul>\n\n\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;Example of search string can be:<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u201cDesignation = \u201cDeveloper\u201d AND (Age &gt; 30 or Age &lt; 40)\u201d<\/p>\n\n\n\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2.\u00a0\u00a0 Ascending: This parameter determines whether the retrieved records should be in ascending \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0or descending order. It can be either true or false.<\/p>\n\n\n\n<p>Here is the screenshot of sample code:<\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2021\/11\/image1.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\nalign: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2021\/11\/image1.png\" alt=\"Code\"><\/a><\/center>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sage 300 ERP web screens functionalities are being improved with every new release. Sage300c provides various ways to read records of ACCPAC views by opening and composing the business views in .net API. Sometimes we need to set filter on view records for that purpose Sage300c .net API provides us view&#8217;s &#8216;browse&#8217; method. New Stuff:-\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[93,3828,3830,3829,3819],"class_list":["post-30560","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-accpac-views","tag-apply-filter-in-accpac-views","tag-browse-method-in-sage300c","tag-sage300-technical-blogs","tag-sage300c"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Apply Filters on Views in Sage 300 .NET API<\/title>\n<meta name=\"description\" content=\"Learn how to apply filters on views using the Sage 300 .NET API to retrieve specific data and enhance application performance.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Apply Filters on Views in Sage 300 .NET API\" \/>\n<meta property=\"og:description\" content=\"Learn how to apply filters on views using the Sage 300 .NET API to retrieve specific data and enhance application performance.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2021-11-30T14:35:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-09T09:45:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2021\/11\/image1.png\" \/>\n<meta name=\"author\" content=\"Greytrix\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Greytrix\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/\",\"name\":\"Apply Filters on Views in Sage 300 .NET API\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2021\/11\/image1.png\",\"datePublished\":\"2021-11-30T14:35:08+00:00\",\"dateModified\":\"2025-07-09T09:45:06+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2\"},\"description\":\"Learn how to apply filters on views using the Sage 300 .NET API to retrieve specific data and enhance application performance.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2021\/11\/image1.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2021\/11\/image1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"HOW TO APPLY FILTER ON VIEWS IN SAGE 300 .NET API\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2\",\"name\":\"Greytrix\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"caption\":\"Greytrix\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/greytrix\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Apply Filters on Views in Sage 300 .NET API","description":"Learn how to apply filters on views using the Sage 300 .NET API to retrieve specific data and enhance application performance.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/","og_locale":"en_US","og_type":"article","og_title":"Apply Filters on Views in Sage 300 .NET API","og_description":"Learn how to apply filters on views using the Sage 300 .NET API to retrieve specific data and enhance application performance.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2021-11-30T14:35:08+00:00","article_modified_time":"2025-07-09T09:45:06+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2021\/11\/image1.png","type":"","width":"","height":""}],"author":"Greytrix","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greytrix","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/","name":"Apply Filters on Views in Sage 300 .NET API","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2021\/11\/image1.png","datePublished":"2021-11-30T14:35:08+00:00","dateModified":"2025-07-09T09:45:06+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2"},"description":"Learn how to apply filters on views using the Sage 300 .NET API to retrieve specific data and enhance application performance.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2021\/11\/image1.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2021\/11\/image1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2021\/11\/30\/how-to-apply-filter-on-views-in-sage-300-net-api\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"HOW TO APPLY FILTER ON VIEWS IN SAGE 300 .NET API"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2","name":"Greytrix","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","caption":"Greytrix"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/greytrix\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/30560","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=30560"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/30560\/revisions"}],"predecessor-version":[{"id":30566,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/30560\/revisions\/30566"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=30560"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=30560"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=30560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}