{"id":794,"date":"2022-08-19T11:31:31","date_gmt":"2022-08-19T11:31:31","guid":{"rendered":"http:\/\/markedcode.com\/?p=794"},"modified":"2023-12-22T16:32:51","modified_gmt":"2023-12-22T16:32:51","slug":"d365-table-browser-record-count","status":"publish","type":"post","link":"https:\/\/markedcode.com\/index.php\/2022\/08\/19\/d365-table-browser-record-count\/","title":{"rendered":"D365 &#8211; Table Browser Record Count"},"content":{"rendered":"\n<p>Sometimes we need to know the number of records in a table in D365. This can be difficult if there is not an easily identifiable entity with a 1 -to-1 relationship with the table. Thankfully, we can use the table browser to calculate the total number of rows. In order to do this, we will first open the web based table browser to our table of interest, then on the right hand side we will click the ellipsis and select &#8216;Show footer&#8217;.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"207\" src=\"http:\/\/markedcode.com\/wp-content\/uploads\/2022\/08\/img1-3-300x207.png\" alt=\"Show footer\" class=\"wp-image-796\" srcset=\"https:\/\/markedcode.com\/wp-content\/uploads\/2022\/08\/img1-3-300x207.png 300w, https:\/\/markedcode.com\/wp-content\/uploads\/2022\/08\/img1-3.png 750w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/figure>\n\n\n\n<p>Doing this will add a new panel at the bottom of our screen. Here we a value indicates the total number of rows in the table browser.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"160\" src=\"http:\/\/markedcode.com\/wp-content\/uploads\/2022\/08\/img2-3-300x160.png\" alt=\"Row count\" class=\"wp-image-795\" srcset=\"https:\/\/markedcode.com\/wp-content\/uploads\/2022\/08\/img2-3-300x160.png 300w, https:\/\/markedcode.com\/wp-content\/uploads\/2022\/08\/img2-3.png 403w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/figure>\n\n\n\n<p>Keep reading about D365 tips and tricks here: <a href=\"https:\/\/markedcode.com\/index.php\/category\/d365\/\">https:\/\/markedcode.com\/index.php\/category\/d365\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sometimes we need to know the number of records in a table in D365. This can be difficult if there is not an easily identifiable entity with a 1 -to-1 relationship with the table. Thankfully, we can use the table browser to calculate the total number of rows. In order to do this, we will<\/p>\n","protected":false},"author":1,"featured_media":982,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[7],"tags":[25],"class_list":{"0":"post-794","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-d365","8":"tag-d365-table-browser-record-count"},"_links":{"self":[{"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/posts\/794","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/comments?post=794"}],"version-history":[{"count":3,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/posts\/794\/revisions"}],"predecessor-version":[{"id":1159,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/posts\/794\/revisions\/1159"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/media\/982"}],"wp:attachment":[{"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/media?parent=794"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/categories?post=794"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/tags?post=794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}