{"id":30558,"date":"2026-09-30T08:48:44","date_gmt":"2026-09-30T08:48:44","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=30558"},"modified":"2026-09-30T08:48:47","modified_gmt":"2026-09-30T08:48:47","slug":"sync-data-configuration-in-dynamic-grid-manager-query-wise","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/","title":{"rendered":"Sync Data Configuration in Dynamic Grid Manager (Query-wise)"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">Introduction<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">In the previous blog, we explored how SQL, synchronizaton tables, joins, calculated fields, and other SQL capabilities can be used to build advanced Dynamic Grids.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">But preparing the data is only one part of the process. When a Dynamic Grid uses a SQL synchronizatontable, the data in that table must also be kept up to date with the latest information from Sage 100.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is where the Sync Data option in Dynamic Grid Query Manager becomes important.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"387\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/09\/image-6-1024x387.png\" alt=\"\" class=\"wp-image-30559\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/09\/image-6-1024x387.png 1024w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/09\/image-6-300x114.png 300w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/09\/image-6-660x250.png 660w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/09\/image-6-766x290.png 766w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/09\/image-6.png 1155w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\">What Is Sync Data?<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">The Sync Data option is used to synchronize information from Sage 100 into a SQL synchronizatontable.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">While a Show Grid query is responsible for displaying information to users, a Sync Data query is responsible for preparing or updating the underlying data.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>Query Option<\/td><td>Purpose<\/td><\/tr><tr><td>Show Grid<\/td><td>Retrieves and displays data in the Dynamic Grid<\/td><\/tr><tr><td>Sync Data<\/td><td>Synchronizes and prepares data in the SQL synchronizatontable<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">This separation allows the data-processing logic and the user-facing grid query to remain independent.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">Show Grid vs. Sync Data<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">Show Grid<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A Show Grid query determines what the CRM user sees. It can:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select required fields<\/li>\n\n\n\n<li>Apply filters<\/li>\n\n\n\n<li>Format values<\/li>\n\n\n\n<li>Display calculated fields<\/li>\n\n\n\n<li>Provide hyperlinks<\/li>\n\n\n\n<li>Control the information shown in the grid<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Sync Data<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A Sync Data query determines how the synchronizaton data is maintained. It can:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Remove existing synchronized data<\/li>\n\n\n\n<li>Retrieve information from Sage 100<\/li>\n\n\n\n<li>Combine data from multiple tables<\/li>\n\n\n\n<li>Calculate values<\/li>\n\n\n\n<li>Insert prepared data into the synchronizaton table<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">The two queries work together:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sync Data \u2192 Staging Table \u2192 Show Grid \u2192 CRM User<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">Why Is Sync Data Important?<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">If a grid has to perform complex processing every time a user opens it, this can increase database and ERP system load. Instead, the complex processing can be performed during synchronization. The prepared information is then available in the synchronizaton table for the Show Grid query.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This approach can provide:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Better separation of responsibilities<\/li>\n\n\n\n<li>Simpler grid queries<\/li>\n\n\n\n<li>Reduced repeated processing<\/li>\n\n\n\n<li>Better control over data preparation<\/li>\n\n\n\n<li>Easier maintenance of complex grids<\/li>\n<\/ul>\n\n\n\n<h1 class=\"wp-block-heading\">Types of Sync Data Queries<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">A Query-wise Dynamic Grid can use different Sync Data queries depending on the required synchronization process.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">1. Truncate\/Delete Query<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Existing synchronized data can be removed before loading fresh information. This ensures that outdated records do not remain in the synchronizaton table. The operation can be performed for all data or for a particular company, depending on the design.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">2. Import\/Load Query<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">After the existing data has been cleared or prepared, a second query can retrieve information from Sage 100, process it, and insert the resulting data into the synchronizaton table.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">How Sync Data Works<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Sage 100 \u2192 Retrieve ERP Data \u2192 Delete Existing Data \u2192 Insert Updated Data \u2192 SQL synchronizaton Table \u2192 Show Grid Query \u2192 Sage CRM<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">Keeping CRM Data Updated<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">One of the main purposes of Sync Data is to ensure that information displayed in CRM remains useful and relevant. The synchronization strategy depends on the business requirement.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The synchronization process should consider:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>How frequently Sage 100 data changes<\/li>\n\n\n\n<li>How frequently users need updated information<\/li>\n\n\n\n<li>Amount of data being synchronized<\/li>\n\n\n\n<li>Complexity of the synchronization query<\/li>\n\n\n\n<li>Available system resources<\/li>\n<\/ul>\n\n\n\n<h1 class=\"wp-block-heading\">Scheduling Sync Queries<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">For data that needs to remain updated automatically, synchronization can be incorporated into a scheduled process. The scheduling frequency should be selected according to the business requirement.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Frequent updates \u2013 suitable when users need relatively current ERP information.<\/li>\n\n\n\n<li>Periodic updates \u2013 suitable when minor synchronization delays are acceptable.<\/li>\n\n\n\n<li>Scheduled daily updates \u2013 suitable for information that does not change frequently.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">The important consideration is to balance data freshness with system performance.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">Best Practices for Sync Data<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Separate Sync :<\/strong> Keep data preparation in Sync Data queries.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Avoid Unnecessary Data:<\/strong> Synchronize only the information required by the Dynamic Grid.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Use Appropriate Filters:<\/strong> Filtering data during synchronization can reduce the amount of information stored and processed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Consider Synchronization Frequency:<\/strong> Do not synchronize more frequently than the business requirement demands.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Handle Existing Data Carefully:<\/strong> Delete or truncate operations should be designed carefully to avoid leaving incomplete staging data if the import process fails.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Monitor Large Synchronizations:<\/strong> Large datasets may require additional attention to query execution time and SQL Server performance.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">Conclusion<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">The Sync Data functionality is an important part of Query-wise Dynamic Grid configuration when ERP information is maintained in SQL synchronizaton tables.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">While Show Grid focuses on displaying information to CRM users, Sync Data focuses on keeping the underlying dataset updated. By using separate queries for data preparation and presentation, organizations can build more structured and maintainable Dynamic Grid solutions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>The key concept is:<\/strong> Sync Data prepares the information; Show Grid presents it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the next blog, we will explore Table-wise Dynamic Grid Configuration through a practical example, covering how Sage 100 tables and columns can be selected and configured to create a Dynamic Grid.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction In the previous blog, we explored how SQL, synchronizaton tables, joins, calculated fields, and other SQL capabilities can be used to build advanced Dynamic Grids. But preparing the data is only one part of the process. When a Dynamic Grid uses a SQL synchronizatontable, the data in that table must also be kept up\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/\">Read More: Sync Data Configuration in Dynamic Grid Manager (Query-wise) &raquo;<\/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":[4811,4206,192,4820,4657,332,333,334,335,3987,3985,3986,4653,4525,4550,4551,4642,4646,4654,4680,4681,4813,4812],"tags":[3179,4817,1238,1258,1286,1306,1435,4818,4819,2010,4815,4814],"class_list":["post-30558","post","type-post","status-publish","format-standard","hentry","category-dynamic-grid","category-gumu-integration","category-integration-sage-crm","category-query-wise","category-sage-100","category-sage-crm","category-sage-crm-2017","category-sage-crm-2018","category-sage-crm-2018-crm72","category-sage-crm-2019-r1-sage-crm","category-sage-crm-2019-r1","category-sage-crm-2019-r1-sage-crm-2018-crm72","category-sage-crm-2020-r2","category-sage-crm-2021-r2","category-sage-crm-2022-r1","category-sage-crm-2022-r1-sage-crm","category-sage-crm-2023-r1","category-sage-crm-2023-r2","category-sage-crm-2024-r1","category-sage-crm-2025","category-sage-x3","category-show-grid","category-sync-data-gumu-integration","tag-dynamic","tag-dynamic-grid","tag-gumu","tag-gumu-integration","tag-gumumas","tag-gumux3","tag-integration","tag-query-wise","tag-querywise","tag-sage-crm","tag-show-data","tag-sync-data"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Sync Data Configuration in Dynamic Grid Manager (Query-wise) - Sage CRM \u2013 Tips, Tricks and Components<\/title>\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\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sync Data Configuration in Dynamic Grid Manager (Query-wise) - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Introduction In the previous blog, we explored how SQL, synchronizaton tables, joins, calculated fields, and other SQL capabilities can be used to build advanced Dynamic Grids. But preparing the data is only one part of the process. When a Dynamic Grid uses a SQL synchronizatontable, the data in that table must also be kept up\u2026 Read More: Sync Data Configuration in Dynamic Grid Manager (Query-wise) &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2026-09-30T08:48:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-30T08:48:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/09\/image-6.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1155\" \/>\n\t<meta property=\"og:image:height\" content=\"437\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/\",\"name\":\"Sync Data Configuration in Dynamic Grid Manager (Query-wise) - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/09\/image-6-1024x387.png\",\"datePublished\":\"2026-09-30T08:48:44+00:00\",\"dateModified\":\"2026-09-30T08:48:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/09\/image-6.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/09\/image-6.png\",\"width\":1155,\"height\":437},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sync Data Configuration in Dynamic Grid Manager (Query-wise)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips &amp; tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?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\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/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\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Sync Data Configuration in Dynamic Grid Manager (Query-wise) - Sage CRM \u2013 Tips, Tricks and Components","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\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/","og_locale":"en_US","og_type":"article","og_title":"Sync Data Configuration in Dynamic Grid Manager (Query-wise) - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Introduction In the previous blog, we explored how SQL, synchronizaton tables, joins, calculated fields, and other SQL capabilities can be used to build advanced Dynamic Grids. But preparing the data is only one part of the process. When a Dynamic Grid uses a SQL synchronizatontable, the data in that table must also be kept up\u2026 Read More: Sync Data Configuration in Dynamic Grid Manager (Query-wise) &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2026-09-30T08:48:44+00:00","article_modified_time":"2026-09-30T08:48:47+00:00","og_image":[{"width":1155,"height":437,"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/09\/image-6.png","type":"image\/png"}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/","name":"Sync Data Configuration in Dynamic Grid Manager (Query-wise) - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/09\/image-6-1024x387.png","datePublished":"2026-09-30T08:48:44+00:00","dateModified":"2026-09-30T08:48:47+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/09\/image-6.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/09\/image-6.png","width":1155,"height":437},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/09\/30\/sync-data-configuration-in-dynamic-grid-manager-query-wise\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Sync Data Configuration in Dynamic Grid Manager (Query-wise)"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips &amp; tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?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\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/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":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/30558","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=30558"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/30558\/revisions"}],"predecessor-version":[{"id":30565,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/30558\/revisions\/30565"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=30558"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=30558"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=30558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}