{"id":5555,"date":"2013-07-05T13:22:06","date_gmt":"2013-07-05T18:22:06","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/docs\/?page_id=5555"},"modified":"2024-06-13T11:46:35","modified_gmt":"2024-06-13T16:46:35","slug":"tablefield-selection","status":"publish","type":"ht_kb","link":"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/tablefield-selection","title":{"rendered":"Table\/Fields Selection"},"content":{"rendered":"\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\"><em>Click <a href=\"https:\/\/www.mrc-productivity.com\/legacy\/m-power-build-process\/tablefield-selection\">here<\/a> to access legacy documentation for this feature<\/em><\/p>\n\n\n\n<p>After selecting the template for your application, you will first be brought to the Table\/Fields Selection specification screen. This is the first screen to specific how the data of your application will be populated. There are four options: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"#databaseTable\" data-type=\"internal\" data-id=\"#databaseTable\">Use Database Table<\/a><\/li>\n\n\n\n<li><a href=\"#sqlComposer\" data-type=\"internal\" data-id=\"#sqlComposer\">SQL Composer<\/a><\/li>\n\n\n\n<li><a href=\"#webService\">Use Web Service<\/a><\/li>\n\n\n\n<li><a href=\"#existingModel\" data-type=\"internal\" data-id=\"#existingModel\">Use Existing Model<\/a><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"databaseTable\">Use Database Table<\/h2>\n\n\n\n<p>The traditional and default option for data population is using a database table. Initially, you will be prompted to select your first table. Notice that all of the tables available to you are all the tables that you have registered to your current data dictionary.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/table_selection_final.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" src=\"\/docs\/vue-images\/tableFieldSelection.jpg\" alt=\"table_selection_final\"\/><\/a><\/figure>\n\n\n\n<p>Here you can filter your registered tables, view more of your tables with the paging buttons, preview data with the magnifying glass button, or select a table using the plus sign.<\/p>\n\n\n\n<p>After doing so, you will be brought to the Field Selection page.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/field_selection_final.jpg\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/field_selection_final.jpg\" alt=\"field_selection_final\"\/><\/a><\/figure>\n\n\n\n<p>Select fields by clicking on the plus sign. If you plan on joining out to any secondary tables, it is important that you select fields in the current table that will also be found in the secondary tables. Once you have selected all desired fields, click Done.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-alert\">If you add a field inadvertently, you can remove it by clicking on the &#8220;X&#8221; button that replaced the plus.<\/p>\n\n\n\n<p>After clicking Done, you will be brought to the &#8220;Selected Tables&#8221; screen. So far, you have only selected one table. Therefore, only this table should appear on this screen.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/selected_tables3.jpg\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/selected_tables3.jpg\" alt=\"selected_tables3\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Table Selection Options<\/h3>\n\n\n\n<p>From the Selected Tables screen you have these available options:<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Select additional fields from the table already selected <\/h4>\n\n\n\n<p>Click on the &#8220;Select Fields&#8221; button on the desired table. This will return you to the Field Selection screen. Select your fields and click &#8220;Done&#8221;. This will return you to the Selected Tables screen.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Edit the selected field settings <\/h4>\n\n\n\n<p>Click on &#8220;Edit field setting&#8221; to be taken to the <a href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/field-settings\">Field Settings screen<\/a><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Join to a different table <\/h4>\n\n\n\n<p>If you want to join to a different table, click on &#8220;Join to additional Table&#8221;. You will be brought to the &#8220;Join to Additional Table&#8221; screen.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/join_table.png\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/join_table.png\" alt=\"join_table\"\/><\/a><\/figure>\n\n\n\n<p>Click on the &#8220;Select&#8221; button to join out to the desired table. This will bring you to the &#8220;Select Join Fields&#8221; screen.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/join_field.png\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/images\/join1.jpg\" alt=\"join_field\"\/><\/a><\/figure>\n\n\n\n<p>All of the fields that are found in both the primary table and the secondary table are shown in this screen. Select the fields you wish to join over and click &#8220;Confirm Joins&#8221;. This brings you to the Field Selection screen. However, you now see the fields that are available to be selected from the secondary table rather than the primary table. Select your fields, and click &#8220;Done&#8221;.<\/p>\n\n\n\n<p>Now that you have selected the fields for your application, you are ready to move onto the last required specification, <a href=\"https:\/\/www.mrc-productivity.com\/docs\/m-power-build-process\/dimensions\">Dimensions<\/a>. To navigate to the Dimensions, you can either click on the &#8220;Dimensions&#8221; icon to the right of the &#8220;Tables\/Fields&#8221; icon or by clicking on the &#8220;Next&#8221; button to the bottom right of the screen.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Show Advanced Join Types<\/h5>\n\n\n\n<p>m-Power allows developers the opportunity to select <em>how<\/em> their joins will function at the table level. To select this, click the &#8220;Show Advanced Join Options&#8221; button.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"\/docs\/images\/join2.jpg\" alt=\"\"\/><\/figure>\n\n\n\n<p>Available options include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Left outer join &#8211; Will include all data residing in the FROM table even if matching data does not exist in TO table.<\/li>\n\n\n\n<li>Right outer join &#8211; Will include all data residing in the TO table even if matching data does not exist in FROM table.<\/li>\n\n\n\n<li>Inner join &#8211; Will only include data residing in FROM table if matching data exists in TO table.<\/li>\n\n\n\n<li>Cross join &#8211; A Cartesian join. Will match every row residing in the FROM table to every row in the TO table.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"sqlComposer\">SQL Composer<\/h2>\n\n\n\n<p>The m-Power SQL Composer allows advanced users to enter their own custom SQL query and m-Power will parse the statement to generate the necessary fields foregoing the traditional Data Dictionary registered table approach to an m-Power build.<\/p>\n\n\n\n<p>Click the following link to learn more about the <a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/sql-query-composer\" target=\"_blank\">SQL Composer<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"webService\">Use Web Service<\/h2>\n\n\n\n<p>The Web Services module is a useful tool for developers to incorporate 3rd party API web services as the datasource for their m-Power applications. This differs from the standard m-Power method of pulling data directly from a database. This module supports consuming any outside web service that returns data in the standard JSON format.&nbsp;<\/p>\n\n\n\n<p>Click the following link to learn more about <a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/api-web-services\" data-type=\"URL\" data-id=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/api-web-services\" target=\"_blank\">Using Web Services<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"existingModel\">Use Existing DX Model<\/h2>\n\n\n\n<p>The m-Power Data Models allows m-Power administrators as well as developers to pre-define queries at the Data Dictionary level. Power users, tired of making the same queries\/joins regularly, can setup common queries, including joins, calculations, and filters, within Data Models to simplify future application development.<\/p>\n\n\n\n<p>Click the following link to learn more about <a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/building-preparing-models-for-data-explorer\" data-type=\"URL\" data-id=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/building-preparing-models-for-data-explorer\" target=\"_blank\">Creating D<\/a><a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/building-preparing-models-for-data-explorer\" data-type=\"URL\" data-id=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/building-preparing-models-for-data-explorer\" target=\"_blank\">X<\/a><a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/building-preparing-models-for-data-explorer\" data-type=\"URL\" data-id=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/building-preparing-models-for-data-explorer\" target=\"_blank\"> <\/a><a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/building-preparing-models-for-data-explorer\" data-type=\"URL\" data-id=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/building-preparing-models-for-data-explorer\" target=\"_blank\">Data Models.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>After selecting the template for your application, you will first be brought to the Table\/Fields Selection specification screen. This is the first screen to specific how the data of your application will be populated. There are four options: Use Database Table The traditional and default option for data population is&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[248],"ht-kb-tag":[],"class_list":["post-5555","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-build-process"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/5555","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=5555"}],"version-history":[{"count":47,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/5555\/revisions"}],"predecessor-version":[{"id":14119,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/5555\/revisions\/14119"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/media?parent=5555"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-category?post=5555"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-tag?post=5555"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}