{"id":5801,"date":"2013-07-24T09:58:22","date_gmt":"2013-07-24T14:58:22","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/docs\/?page_id=5801"},"modified":"2024-01-04T13:08:32","modified_gmt":"2024-01-04T19:08:32","slug":"multiple-record-retrieval-template","status":"publish","type":"ht_kb","link":"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/multiple-record-retrieval-template","title":{"rendered":"Multiple Row Data List Retrieval Template"},"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\/retrievals\/multiple-record-retrieval-template\">here<\/a> to access the legacy version of this documentation.<\/em><\/p>\n\n\n\n<p>The Multiple Row Data List template is a versatile tool for developers looking to build a wide range of web applications. Whether you are designing simple applications, such as a customer master search, or complex applications, such as a shopping cart, the Multiple Row Data List template is worth considering. The design of this template features displaying data in a grid layout. Additionally, it supports ad-hoc sorting and searching to allow end-users to quickly and easily find important data.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading\"><strong><a id=\"runtime\" class=\"anchor\"><\/a>Runtime Walkthrough<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Multi-Row List Template\" width=\"643\" height=\"362\" src=\"https:\/\/www.youtube.com\/embed\/PO3JCjwJqms?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Template Features<\/h2>\n\n\n\n<p>Below lists out all the template features offered by the Multiple Row Data List template:<\/p>\n\n\n\n<p><strong>Provides Row Count<\/strong><br>Multiple Row inquiries display, by default, 10 rows of data and allows the user to view the total count of records along with navigation arrows to page through the records.<\/p>\n\n\n\n<p><strong>Ability to Ad-Hoc Sort on Any Column<\/strong><br>By clicking the up or down arrows next to the column name, Multiple Row inquiries allow end users to sort the data in ascending or descending order at runtime, based on any field from the application.<\/p>\n\n\n\n<p><strong>Ability to Ad-Hoc Filter on Any Column<\/strong><br>On the pagination bar you will find a button labeled &#8220;Selections&#8221;, this feature allows users to search through records within the application. Here users can control how many records to display per page. Filter on specific fields by selecting a relationship, and the ability to input a value to search for. All of this from the web browser, at runtime.<\/p>\n\n\n\n<p><strong>Paginates Through Record Set<\/strong><br>The Multiple Row inquiry makes it easy to navigate through large number of records by displaying only 10 records per page and allowing users to use the navigation bar to move back and forward through pages. The amount of records displayed per page can be changed by simply clicking the Selections button. <\/p>\n\n\n\n<p><strong>Can Return Back Very Large Files<\/strong><br>The Multiple Row inquiry template is ideal when the database contains many records, this template is designed to perform efficiently even when working with very large datasets.<\/p>\n\n\n\n<p><strong>Built-in AJAX Suggest<\/strong><br>This template makes it even easier to search for a specific record, by taking advantage of the AJAX suggest feature. Click the Selections button, and Just begin typing in the input field, and a drop down list will display all matching records for the text entered. Learn\u00a0<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/m-painter-app-prop\/using-ajax-helpers\" target=\"_blank\"><strong>more<\/strong><\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Template Screens<a id=\"all_chart\" class=\"anchor\"><\/a><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Tables\/Fields<\/h3>\n\n\n\n<p>Here you will see\/modify the table and fields you have selected for your application. Here you can create or modify joins to other tables as well. <\/p>\n\n\n\n<p>To learn more about the Tables\/Fields section, please see&nbsp;<a href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/tablefield-selection\"><strong>here<\/strong><\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Field Settings<\/h3>\n\n\n\n<p>Here you will find the settings for all the fields in the application. Settings such as field descriptions, format codes, and hiding fields can be controlled from this screen.<\/p>\n\n\n\n<p>You can find out more in detail about these options&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/field-settings\" target=\"_blank\"><strong>here<\/strong><\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Dimensions<\/h3>\n\n\n\n<p>Here you can select the field that your application will sequence by; you can have multiple sequence fields. You can re-order the sequences to fit your application\u2019s needs. Retrievals also have the power to allow end users to Ad-Hoc sort at runtime on a specific field or column. <\/p>\n\n\n\n<p>To learn more about Dimensions, please see&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/dimensions\" target=\"_blank\"><strong>here<\/strong><\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Filters<\/h3>\n\n\n\n<p>Filters can be created over any database fields or calculations. They allow you to restrict the records that will be returned from the database at runtime.<\/p>\n\n\n\n<p>To learn more about Filters, please see&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/filters\" target=\"_blank\"><strong>here<\/strong><\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Calculations<\/h3>\n\n\n\n<p>Fields that will apply to the current application only. This can be used to include SQL code in a field, such as cast a numeric field as character, create date conversions, inserting the current date and time, and much more. <\/p>\n\n\n\n<p>To learn more about Calculations, please see <a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/calcs\/m-power-calculation-screen\" target=\"_blank\"><strong>here<\/strong>.<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">External Objects<\/h3>\n\n\n\n<p>This feature allows developers to connect m-Power application with their current business logic, or to extend m-Power capabilities by allowing developers to write their own Java, RPG, or SQL programs, and integrating these programs into the applications. m-Power utilizes \u201clocations\u201d to connect the external objects, these locations vary depending on what the external object does and when it should be executed. The following locations are supported in this template:<\/p>\n\n\n\n<p><strong>*CALCOBJ<\/strong>\u00a0Used when parameter calculations are present in the application. The external object is called after each row is processed.<br><strong>*STRADVSCH<\/strong>\u00a0This location has been deprecated.<br><strong>*ADVRECSEC<\/strong>\u00a0This location has been deprecated. Learn\u00a0<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/security\/row-level-security\" target=\"_blank\">more<\/a>\u00a0about Row Level security.<br><strong>*READRECRD<\/strong>\u00a0This location will call the external object after each record is processed.<br><strong>*SELECTFLT<\/strong>\u00a0This location has been deprecated. Learn\u00a0<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/m-painter-app-prop\/create-dropdowns-in-m-painter\" target=\"_blank\">more\u00a0<\/a>about creating dropdown lists using m-Painter.<\/p>\n\n\n\n<p>To learn more about External Objects, please see <a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/m-power-build-process\/external-objects\" target=\"_blank\"><strong>here<\/strong>.<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Smartlinks<\/h3>\n\n\n\n<p>Smartlinks allow developers to easily link one application (Retrieval, Report, or Maintenance) to any other application, passing key data automatically. The benefit of Smartlinks is that it allows users the ability to quickly &#8220;drilldown&#8221; into other applications based on the selected row. By passing parameters automatically when creating a link in m-Painter, Smartlinks save the developer time by simplifying the process. <\/p>\n\n\n\n<p>To learn more about Smartlinks, please see <a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/m-power-build-process\/working-with-smartlinks\" target=\"_blank\"><strong>here<\/strong>.<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Template Properties<\/h3>\n\n\n\n<p>The Template Properties screen gives developers template specific settings.<\/p>\n\n\n\n<p>To learn more about Template Properties, please see\u00a0<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/template-properties\" target=\"_blank\"><strong>here<\/strong>.<\/a><a id=\"all_chart\" class=\"anchor\"><\/a><a id=\"multiple_chart\" class=\"anchor\"><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><a id=\"in-action\" class=\"anchor\"><\/a><a id=\"properties\" class=\"anchor\"><\/a>Edit Properties<\/strong><\/h2>\n\n\n\n<p>The Edit Properties section allows you to control the behavior of the application. Every m-Power application has properties, however the list of available properties will be different depending on the template selected.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">This section below will only focus on properties that are specific to the Multiple Row Data List template. A complete list of globally shared properties between all templates can be found\u00a0<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/application-properties-overview\" target=\"_blank\"><strong>here<\/strong><\/a>.<\/p>\n\n\n\n<div class=\"wp-block-ht-blocks-tabs wp-block-hb-tabs\"><ul class=\"wp-block-hb-tabs__nav\" role=\"tablist\"><li class=\"wp-block-hb-tabs__head\" data-tab=\"tabs-0\" data-hb-tabs-tab--state=\"active\"><span class=\"wp-block-hb-tabs__head_item\" for=\"tab0\">Program Options<\/span><\/li><li class=\"wp-block-hb-tabs__head\" data-tab=\"tabs-1\" data-hb-tabs-tab--state=\"inactive\"><span class=\"wp-block-hb-tabs__head_item\" for=\"tab1\">Miscellaneous<\/span><\/li><\/ul><div id=\"tabs-0\" class=\"wp-block-hb-tabs__content\" role=\"tabpanel\" data-hb-tabs-tab--state=\"active\"><p><br><strong>Allow Excel Export? <\/strong>&#8212; This template allows end-users to export the data currently displayed on the screen to an Excel output file.<br><br><strong>Automatically Save Row Count?<\/strong> &#8212; When enabled, this feature will allow the end-user to automatically save their default row count within a browser cookie.<br><br><strong>Allow Column Reorder?<\/strong> &#8212; Determines whether or not a dialog window is available to choose column reordering.<br><br><strong>Maximum Rows to Display<\/strong> &#8212; This property controls the maximum number of rows to display when running this application.<br><br><strong>Auto refresh App<\/strong> &#8212; Specify an interval (in seconds) to automatically refresh the application. Zero indicates auto refresh disabled.<br><br><strong>Default Sort Fields<\/strong> &#8212; Specify a semicolon separated list of fields and their sort types (ex FIELD1 ASC; FIELD2 DESC)<br><a href=\"https:\/\/dev.mrc-productivity.com:8017\/webapp\/mrc\/servlet\/mPainter?fullpage=1&amp;func=prop&amp;lib=UPD2024Q1&amp;file=I00001p.xml#appSortModal\"><\/a><\/p><\/div><div id=\"tabs-1\" class=\"wp-block-hb-tabs__content\" role=\"tabpanel\" data-hb-tabs-tab--state=\"inactive\"><p><br><strong>Record Counter Value<\/strong> &#8211; This template will display the total number of records found in the query. If this application contains a very large number of records or is otherwise not performing as well as expected, please disable this feature.<\/p><\/div><\/div>\n\n\n\n<p><strong><a id=\"parameters\" class=\"anchor\"><\/a><\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">URL Parameters<\/h2>\n\n\n\n<p>A complete list of runtime parameters that can be passed to a Multiple Row Data List template can be seen by using Parameter Listing (help=1) tool.<\/p>\n\n\n\n<p>To launch this feature, simply add<strong>&nbsp;?help=1<\/strong>&nbsp;to the end of the URL of any m-Power application and hit Enter.<\/p>\n\n\n\n<p>ex.\u00a0<code>http:\/\/mpowerserveraddress:8011\/mrcjava\/servlet\/DICTIONARY.I00010s?help=1<\/code><\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">This is an example URL. Please substitute your appropriate values, such as the m-Power server address, the dictionary name, and the application number into your own URL.<\/p>\n\n\n\n<p>For more information on the Parameter Listing tool, please see\u00a0<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/troubleshooting-m-power-applications#runtime-parameter-listings-help1\" target=\"_blank\"><strong>here<\/strong><\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Template In-Action<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"\/docs\/vue-images\/multipleRowDataListInAction.jpg\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" src=\"\/docs\/vue-images\/multipleRowDataListInAction.jpg\" alt=\"\"\/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>The Multiple Row Data List template is a versatile tool for developers looking to build a wide range of web applications. Whether you are designing simple applications, such as a customer master search, or complex applications, such as a shopping cart, the Multiple Row Data List template is worth considering&#8230;.<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[249],"ht-kb-tag":[],"class_list":["post-5801","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-retrieval"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/5801","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=5801"}],"version-history":[{"count":170,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/5801\/revisions"}],"predecessor-version":[{"id":13966,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/5801\/revisions\/13966"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/media?parent=5801"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-category?post=5801"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-tag?post=5801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}