{"id":1841,"date":"2011-08-30T03:45:11","date_gmt":"2011-08-30T08:45:11","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/docs\/?page_id=1841"},"modified":"2021-12-08T10:33:09","modified_gmt":"2021-12-08T16:33:09","slug":"one-click-data-view","status":"publish","type":"ht_kb","link":"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/one-click-data-view","title":{"rendered":"One Click Data View"},"content":{"rendered":"<p><!-- Begin Content --><\/p>\n<p>Included with m-Power beginning with the September 7th, 2011 version, the One Click Data View feature allows developers to take a sneak peak at their data with the push of a single button! Prior to this feature, developers who were unfamiliar with certain tables in their environment were forced to do the following:<\/p>\n<ul>\n<li class=\"padleft\">Read countless pages of documentation from their database vendor.<\/li>\n<li class=\"padleft\">Ask a colleague for advice as to in which tables their data can be found.<\/li>\n<li class=\"padleft\">Blindly build retrievals over every table in their environment they thought might apply to them so they could see the data within.<\/li>\n<\/ul>\n<p>To utilize this feature, navigate to the Admin section, then to Registered Tables. Find the &#8220;Data&#8221; column, and click on the magnifying glass to bring up a view of the live data that resides in the table for which you clicked.<\/p>\n<p><img decoding=\"async\" class=\"border\" src=\"\/docs\/images\/dataview1.jpg\" \/><\/p>\n<p>Once clicked, a new window will appear that will allow you to view, sort, and search through the live data within this single table.<\/p>\n<p><strong>Note:<\/strong> The library\/schema and table name will be displayed above the dataset.<\/p>\n<p><img decoding=\"async\" class=\"border\" src=\"\/docs\/images\/dataview2.jpg\" \/><\/p>\n<p>Alternatively, m-Power gives you the ability to view your dataset <em>while<\/em> building your application. During table selection, simply click on the &#8220;View Table&#8221; icon next to any table listed to see the live data that resides within that table.<\/p>\n<p><img decoding=\"async\" class=\"border\" src=\"\/docs\/images\/dataview3.jpg\" \/><\/p>\n<p><strong>Note:<\/strong> This feature is designed to allow developers to view the contents of one table at a time. If you would like to see the contents of multiple tables joined together, please consider creating a <a href=\"https:\/\/www.mrc-productivity.com\/docs\/retrievals\/what-is-a-retrieval-and-when-should-i-use-them\">retrieval<\/a> or an <a href=\"https:\/\/www.mrc-productivity.com\/docs\/general\/loading-sql-views-into-m-power\">SQL View<\/a> to achieve this.<\/p>\n<p><!-- End Content --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Included with m-Power beginning with the September 7th, 2011 version, the One Click Data View feature allows developers to take a sneak peak at their data with the push of a single button! Prior to this feature, developers who were unfamiliar with certain tables in their environment were forced to&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[264],"ht-kb-tag":[],"class_list":["post-1841","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-deprecated-documentation"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/1841","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/comments?post=1841"}],"version-history":[{"count":9,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/1841\/revisions"}],"predecessor-version":[{"id":11594,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/1841\/revisions\/11594"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/media?parent=1841"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-category?post=1841"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-tag?post=1841"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}