{"id":131,"date":"2009-02-09T05:37:00","date_gmt":"2009-02-09T05:37:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=131"},"modified":"2024-04-16T09:58:09","modified_gmt":"2024-04-16T09:58:09","slug":"working-with-grids-the-partial-load-property","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/02\/09\/working-with-grids-the-partial-load-property\/","title":{"rendered":"Working with grids: The Partial Load property"},"content":{"rendered":"

The following can be a valuable piece of information to you in case you are handling code for grids.<\/p>\n

We shall use the example of the \u2018Bin Transfer\u2019 task.<\/p>\n

Suppose you have to work with the total number of rows that are loaded in the grid when a warehouse \u2013 item combination is chosen in the lookups. You would use the DataRowCnt property of the grid control or the glGridGetDataRowCnt function to get the no. of rows in the grid. But the value returned will not be the total no. of rows in the grid but only those rows which are currently visible in the grid. If the user scrolls down and then checks the DataRowCnt property the value returned will be higher. Of course, this would be noticed only if there are at least more than 10 rows for the warehouse \u2013 item combination.<\/p>\n

Consider our following example:
\nWe have purchased 27 quantities of an item named \u2018TestItem\u2019 distributing 1 quantity each in a different bin. So there is 1 quantity of TestItem in 27 different bins.<\/p>\n

Next we open the Bin Transfer task and add the warehouse \u2013 item combination. The grid loads with the details for each bin. We have added a button named \u2018Get Data Row Count\u2019 on the form. We have written code in the click event of the button to get the DataRowCnt property of the grid control and display the value in a message box.<\/p>\n

\"sage<\/p>\n

If you would check the DataRowCnt now you will get a value of 10 when there are actually 27 rows in the grid.<\/p>\n

\"Grids<\/p>\n

Now if you scroll down to the end of the grid and then check the DataRowCnt you would get the correct value of 27.<\/p>\n

So, in order to get the correct no. of rows, the user will have to scroll down to the last row in the grid. But if you need to find the total no. of rows without having any user interaction you can\u2019t use the DataRowCnt property. This is where the PartialLoad property can help. The PartialLoad property of the Grid Data Manager object is responsible for populating the rows in the grid. If this property is set to \u2018True\u2019 the rows are not loaded unless the user scrolls down in the grid. If this property if set to \u2018False\u2019 all rows are loaded and no user interaction is needed.<\/p>\n

So, you need to change the source code and set the PartialLoad property of the Grid Data Manager object to \u2018False\u2019. Now you can get the correct total no. of rows as soon as the grid is loaded without requiring the user to scroll down.<\/p>\n

This information can be helpful to you in case you come across such a situation while working with grids on any MAS 500 screen.<\/p>\n

For any further assistance, feel free to contact us at sage@greytrix.com<\/a>.<\/p>\n

About Us<\/strong><\/span>
\nGreytrix<\/a> is a one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.<\/p>\n

Greytrix\u00a0has some unique solutions of\u00a0Sage 100 integration with Sage CRM<\/a>,\u00a0and Salesforce.com<\/a> along with Sage 100 Migration from Sage 50 US<\/a>, Sage Intacct<\/a>, QuickBooks<\/a>, Sage Business Vision and Sage Business Works. We also offer best-in-class\u00a0Sage 100 customization and development services\u00a0<\/a>to Sage business partners, end users, and Sage PSG worldwide.<\/p>\n

For more details on Sage 100 Services, please contact us at\u00a0sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

The following can be a valuable piece of information to you in case you are handling code for grids. We shall use the example of the \u2018Bin Transfer\u2019 task. Suppose you have to work with the total number of rows that are loaded in the grid when a warehouse \u2013 item combination is chosen in\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[83,213],"tags":[],"class_list":["post-131","post","type-post","status-publish","format-standard","hentry","category-grid-handling","category-tips"],"yoast_head":"\nGrid operations: The Partial Load attribute<\/title>\n<meta name=\"description\" content=\"Discover The rows in the grid are filled in using the Grid Data Manager object's PartialLoad attribute.\" \/>\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\/sagemas\/2009\/02\/09\/working-with-grids-the-partial-load-property\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Grid operations: The Partial Load attribute\" \/>\n<meta property=\"og:description\" content=\"Discover The rows in the grid are filled in using the Grid Data Manager object's PartialLoad attribute.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/02\/09\/working-with-grids-the-partial-load-property\/\" \/>\n<meta property=\"og:site_name\" content=\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2009-02-09T05:37:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-16T09:58:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2009\/02\/sage-100-bin-transfers.jpg\" \/>\n<meta name=\"author\" content=\"greysagemas\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagemas\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/02\/09\/working-with-grids-the-partial-load-property\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/02\/09\/working-with-grids-the-partial-load-property\/\",\"name\":\"Grid operations: The Partial Load attribute\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/02\/09\/working-with-grids-the-partial-load-property\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/02\/09\/working-with-grids-the-partial-load-property\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2009\/02\/sage-100-bin-transfers.jpg\",\"datePublished\":\"2009-02-09T05:37:00+00:00\",\"dateModified\":\"2024-04-16T09:58:09+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\"},\"description\":\"Discover The rows in the grid are filled in using the Grid Data Manager object's PartialLoad attribute.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/02\/09\/working-with-grids-the-partial-load-property\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/02\/09\/working-with-grids-the-partial-load-property\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/02\/09\/working-with-grids-the-partial-load-property\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2009\/02\/sage-100-bin-transfers.jpg\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2009\/02\/sage-100-bin-transfers.jpg\",\"width\":648,\"height\":356,\"caption\":\"sage 100 bin transfers\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/02\/09\/working-with-grids-the-partial-load-property\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Working with grids: The Partial Load property\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\",\"name\":\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\",\"description\":\"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/?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\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\",\"name\":\"greysagemas\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagemas\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Grid operations: The Partial Load attribute","description":"Discover The rows in the grid are filled in using the Grid Data Manager object's PartialLoad attribute.","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\/sagemas\/2009\/02\/09\/working-with-grids-the-partial-load-property\/","og_locale":"en_US","og_type":"article","og_title":"Grid operations: The Partial Load attribute","og_description":"Discover The rows in the grid are filled in using the Grid Data Manager object's PartialLoad attribute.","og_url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/02\/09\/working-with-grids-the-partial-load-property\/","og_site_name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","article_published_time":"2009-02-09T05:37:00+00:00","article_modified_time":"2024-04-16T09:58:09+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2009\/02\/sage-100-bin-transfers.jpg","type":"","width":"","height":""}],"author":"greysagemas","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagemas","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/02\/09\/working-with-grids-the-partial-load-property\/","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/02\/09\/working-with-grids-the-partial-load-property\/","name":"Grid operations: The Partial Load attribute","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/02\/09\/working-with-grids-the-partial-load-property\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/02\/09\/working-with-grids-the-partial-load-property\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2009\/02\/sage-100-bin-transfers.jpg","datePublished":"2009-02-09T05:37:00+00:00","dateModified":"2024-04-16T09:58:09+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728"},"description":"Discover The rows in the grid are filled in using the Grid Data Manager object's PartialLoad attribute.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/02\/09\/working-with-grids-the-partial-load-property\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/02\/09\/working-with-grids-the-partial-load-property\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/02\/09\/working-with-grids-the-partial-load-property\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2009\/02\/sage-100-bin-transfers.jpg","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2009\/02\/sage-100-bin-transfers.jpg","width":648,"height":356,"caption":"sage 100 bin transfers"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/02\/09\/working-with-grids-the-partial-load-property\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagemas\/"},{"@type":"ListItem","position":2,"name":"Working with grids: The Partial Load property"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/","name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","description":"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagemas\/?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\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728","name":"greysagemas","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagemas"},"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/comments?post=131"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/131\/revisions"}],"predecessor-version":[{"id":4912,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/131\/revisions\/4912"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/media?parent=131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/categories?post=131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/tags?post=131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}