{"id":6627,"date":"2013-10-01T13:12:06","date_gmt":"2013-10-01T18:12:06","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/docs\/?page_id=6627"},"modified":"2025-02-27T14:06:18","modified_gmt":"2025-02-27T20:06:18","slug":"address-distribution-list","status":"publish","type":"ht_kb","link":"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/address-distribution-list","title":{"rendered":"Address Distribution List 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\/address-distribution-list\">here<\/a> to access the legacy version of this documentation.<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Overview<\/h2>\n\n\n\n<p>The Address Distribution List Template is a special retrieval template, used exclusively in conjunction with the <a href=\"\/docs\/knowledge-base\/messaging-and-scheduled-tasks\" data-type=\"ht_kb\" data-id=\"13065\" target=\"_blank\" rel=\"noreferrer noopener\">Messaging and Scheduled Task utility<\/a> to send emails messages to a table driven list of email recipients.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">Applications created with this template are not expected to be ran in the browser by the end-user, but rather to be consumed within m-Power&#8217;s Messaging and Scheduled Task utility. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"\/docs\/vue-images\/address_distribution_list1.jpg\" alt=\"\"\/><figcaption class=\"wp-element-caption\">Figure 1. Creating a new Address Distribution List retrieval<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><a id=\"notes\" class=\"anchor\"><\/a>Template <\/strong>Features<\/h2>\n\n\n\n<p>Below lists out all the template features offered by the Address Distribution List retrieval.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><a id=\"dataSelection\" class=\"anchor\"><\/a><\/strong>Tables\/Fields<\/h3>\n\n\n\n<p>Here you will see\/modify the table(s) you have selected for your application, as well as have the ability to create or modify joins to other tables. <\/p>\n\n\n\n<p>To learn more about the Tables\/Fields section, please see <a href=\"\/docs\/knowledge-base\/tablefield-selection\">here<\/a>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Field Settings<\/strong><\/h4>\n\n\n\n<p>Here you will find the settings for all the fields in the application. You can find out more in detail about these options <a href=\"\/docs\/knowledge-base\/field-settings\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><a id=\"sequencing\" class=\"anchor\"><\/a><\/strong>Dimensions<\/h3>\n\n\n\n<p>Here you can select the field that your application will sort by at runtime; you can have multiple Dimension fields. You can re-order the Dimension fields to fit your application\u2019s needs. For practical purposes, it does not matter what you opt to use as a dimension field(s) within this application, as long as your application contains at least one.<\/p>\n\n\n\n<p>To learn more about Dimensions, please see <a href=\"\/docs\/knowledge-base\/dimensions\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><a id=\"recordSelections\" class=\"anchor\"><\/a>Filters<\/strong><\/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 <a rel=\"noreferrer noopener\" href=\"\/docs\/knowledge-base\/filters\" target=\"_blank\">here<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><a id=\"calculations\" class=\"anchor\"><\/a>Calculations<\/strong><\/h3>\n\n\n\n<p>Calculations are a very powerful feature of m-Power; with calculations, developers can create logical fields that will apply to the current application only. For example, in the Address Distribution List template, you may want to create a conditional calculation to create your email group field.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon\">Tip: Multiple email addresses fields can be concatenated together via a calculation, so long as they are separated by a comma. Ex: <code>user1@email.com,user2@email.com<\/code><\/p>\n\n\n\n<p>To learn more about Calculations, please see <a href=\"\/docs\/knowledge-base\/calculated-fields\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><a id=\"externalObjects\" class=\"anchor\"><\/a>External Objects<\/strong><\/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 &#8220;locations&#8221; 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<ul class=\"wp-block-list\">\n<li><strong>*ADVRECSEC<\/strong>&nbsp;&#8211; This location has been deprecated. Learn&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/security\/row-level-security\" target=\"_blank\">more&nbsp;<\/a>about Row Level security.<\/li>\n\n\n\n<li><strong>*CALCOBJ<\/strong>&nbsp;&#8211; This location is used when parameter calculations are present in the application. The external object is called after each row is processed.<\/li>\n\n\n\n<li><strong>*READRECRD<\/strong> &#8211;&nbsp;This location will call the external object after each record is processed.<\/li>\n\n\n\n<li><strong>*SELECTFLT<\/strong>&nbsp;&#8211; This location has been deprecated.<\/li>\n\n\n\n<li><strong>*STRADVSCH<\/strong>&nbsp;&#8211; This location has been deprecated.<\/li>\n<\/ul>\n\n\n\n<p>To learn more about External Objects, please see <a href=\"\/docs\/knowledge-base\/external-objects\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><a id=\"smartLinks\" class=\"anchor\"><\/a>SmartLinks<\/strong><\/h3>\n\n\n\n<p>SmartLinks are not supported in the Address Distribution List Template.<\/p>\n\n\n\n<p>To learn more about <a href=\"\/docs\/knowledge-base\/working-with-smartlinks\" data-type=\"URL\" data-id=\"\/docs\/knowledge-base\/working-with-smartlinks\" target=\"_blank\" rel=\"noreferrer noopener\">Smartlinks<\/a>, please see here.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Template Properties<\/h3>\n\n\n\n<p>The Template Properties screen allows you to adjust specific settings applicable to the template. Depending on the template, some options may or may not be available.<\/p>\n\n\n\n<p>For more on Template Properties, please see <a rel=\"noreferrer noopener\" href=\"\/docs\/knowledge-base\/template-properties\" target=\"_blank\">here<\/a>. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><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 Address Distribution List template. A complete list of globally shared properties between all templates can be found <a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/application-properties-overview\" target=\"_blank\">here<\/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><\/ul><div id=\"tabs-0\" class=\"wp-block-hb-tabs__content\" role=\"tabpanel\" data-hb-tabs-tab--state=\"active\"><p><br><strong>Field to map for email address<\/strong> &#8211;  <mark style=\"background-color:rgba(0, 0, 0, 0);color:#ff0000\" class=\"has-inline-color\">Required<\/mark>. This property controls which field (or calculation) the distribution list should be used to access the valid e-mail addresses within this application.<br><br><strong>Field to map for email group <\/strong>&#8211; This property controls which field the distribution list should use to access the e-mail group column within this application. While not required, this property can be useful for identifying different groups of email addresses from one another.  <\/p><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"parameters\"><strong>URL Parameters<\/strong><\/h2>\n\n\n\n<p>A complete list of runtime parameters that can be passed to an Address Distribution 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. <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 <a href=\"\/docs\/knowledge-base\/troubleshooting-m-power-applications#runtime-parameter-listings-help1\" data-type=\"URL\" data-id=\"\/docs\/knowledge-base\/troubleshooting-m-power-applications#runtime-parameter-listings-help1\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Overview The Address Distribution List Template is a special retrieval template, used exclusively in conjunction with the Messaging and Scheduled Task utility to send emails messages to a table driven list of email recipients. Template Features Below lists out all the template features offered by the Address Distribution List retrieval&#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":[279,298],"class_list":["post-6627","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-retrieval","ht_kb_tag-email","ht_kb_tag-messaging"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/6627","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=6627"}],"version-history":[{"count":50,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/6627\/revisions"}],"predecessor-version":[{"id":14469,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/6627\/revisions\/14469"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/media?parent=6627"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-category?post=6627"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-tag?post=6627"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}