{"id":20486,"date":"2019-09-17T09:41:54","date_gmt":"2019-09-17T09:41:54","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=20486"},"modified":"2019-09-17T09:42:16","modified_gmt":"2019-09-17T09:42:16","slug":"get-all-the-records-of-dataset-grid-control-swiftly","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2019\/09\/get-all-the-records-of-dataset-grid-control-swiftly\/","title":{"rendered":"Save Time! Now get all the records of Dataset Grid control Swiftly"},"content":{"rendered":"

Introduction<\/strong><\/h2>\n

With the help of PCF (PowerApps Component Framework) Control, we design control for Dataset\u00a0Grid, which\u00a0we can add on any OOB and custom entity to show records that are available in the selected view. We show data for\u00a0the available set\u00a0of columns that are added in\u00a0the selected view. To show all records data in Dataset Grid control, first, we need to load all records in Dataset Context property (context.parameters.sampleDataSet).<\/p>\n

Problem<\/strong><\/h2>\n

Recently we developed a PCF Control for Dataset where we have shown all the records of selected view on one page. But for a large set of records it takes a long time to load because at a time we are able to load only the count of records that are set in settings of Dynamics 365 CRM as shown below:<\/p>\n

\"PCF\"<\/p>\n

Solution<\/strong><\/h2>\n

To overcome this hurdle, we used loadNextPage() method of Paging<\/a> to load all the records of dataset as illustrated below:<\/p>\n

context.parameters.sampleDataSet.paging.loadNextPage();<\/p>\n

Using loadNextPage() method, we successfully loaded all the records of selected view in Dataset Context property (context.parameters.sampleDataSet). But when there were large number of records it took a long time to load all the records. This led us to find an alternative to load all the records in lesser time. We found the setPageSize() method of Paging<\/a>, where we can set the page size of Dataset Context property (context.parameters.sampleDataSet) as mentioned below:<\/p>\n

context.parameters.sampleDataSet.paging.setPageSize(number);<\/p>\n

To load all the records of selected view in Dataset Grid control it is necessary to make some changes in updateView() function as shown below:<\/p>\n

 public\u00a0updateView(context:\u00a0ComponentFramework.Context<IInputs>):\u00a0void\u00a0{\r\n\r\nif\u00a0(!context.parameters.sampleDataSet.loading)\u00a0{\r\n\r\nif\u00a0(context.parameters.sampleDataSet.paging\u00a0!=\u00a0null\u00a0&&\u00a0context.parameters.sampleDataSet.paging.hasNextPage\u00a0==\u00a0true)\u00a0{\r\n\r\n\/\/set\u00a0page\u00a0size\r\n\r\ncontext.parameters.sampleDataSet.paging.setPageSize(5000);\r\n\r\n\/\/load\u00a0next\u00a0paging\r\n\r\ncontext.parameters.sampleDataSet.paging.loadNextPage();\r\n\r\n}\u00a0else\u00a0{\r\n\r\n\/\/After\u00a0load\u00a0all\u00a0the\u00a0records,\u00a0render\u00a0the\u00a0HTML\u00a0to\u00a0show\u00a0the\u00a0records\r\n\r\n}\r\n\r\n}\r\n\r\n}<\/pre>\n
Conclusion<\/strong><\/h2>\n
In this way, we can easily load all the records of selected view in lesser time by using setPageSize() method of Paging.<\/p>\n","protected":false},"excerpt":{"rendered":"
Introduction With the help of PCF (PowerApps Component Framework) Control, we design control for Dataset\u00a0Grid, which\u00a0we can add on any OOB and custom entity to show records that are available in the selected view. We show data for\u00a0the available set\u00a0of columns that are added in\u00a0the selected view. To show all records data in Dataset Grid\u2026 Read More: Save Time! Now get all the records of Dataset Grid\u2026 »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":20489,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,44,38,1929],"tags":[1170,1941],"class_list":["post-20486","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-365","category-power-apps","category-microsoft-powerapps","category-pcf","tag-microsoft-powerapps","tag-pcf-control"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t