{"id":1656,"date":"2008-07-07T03:45:38","date_gmt":"2008-07-07T08:45:38","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/docs\/?page_id=1656"},"modified":"2021-10-04T09:36:00","modified_gmt":"2021-10-04T14:36:00","slug":"external-object-locations","status":"publish","type":"ht_kb","link":"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/external-object-locations","title":{"rendered":"External Object Locations"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">Servlet Retrieval<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>*CALCOBJ<\/td><td>Used with calculation External Objects or Constant calculations.<\/td><\/tr><tr><td>*STRADVSCH<\/td><td>Before searching change advanced field values. Convert value for search input then process filter.<\/td><\/tr><tr><td>*ADVRECSEC<\/td><td>Row Level Security. Click <a href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/row-level-security\" data-type=\"URL\" data-id=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/row-level-security\">here<\/a> for additional information.<\/td><\/tr><tr><td>*READRECRD<\/td><td>Call object after each record is processed.<\/td><\/tr><tr><td>*SELECTFLT<\/td><td>Used with External drop down lists.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Servlet Reports<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>*JCALCOBJ<\/td><td>Used with calculation External Objects or Constant calculations.<\/td><\/tr><tr><td>*JREADRCRD<\/td><td>Call object after each record is processed.<\/td><\/tr><tr><td>*ADVRECSEC<\/td><td>Row Level Security. Click <a href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/row-level-security\" data-type=\"URL\" data-id=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/row-level-security\">here<\/a> for additional information.<\/td><\/tr><tr><td>*STRSEARCH<\/td><td>Swap record selection.<\/td><\/tr><tr><td>*STRUPBDFT<\/td><td>Set default key input.<\/td><\/tr><tr><td>*SELECT<\/td><td>Set dropdown on data input.<br><strong>Note:<\/strong> This option has been deprecated. Please see <a href=\"https:\/\/www.mrc-productivity.com\/docs\/m-painter-app-prop\/create-dropdowns-in-m-painter\">this<\/a> document for the supported method of creating drop-down lists.<\/td><\/tr><tr><td>*RUNVALID<\/td><td>Validate prompt inputs.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Servlet Summary<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>*JREADRCRD<\/td><td>Call object after each record is processed.<\/td><\/tr><tr><td>*STRSEARCH<\/td><td>Swap record selection<\/td><\/tr><tr><td>*READRECRD<\/td><td>Call object after each record is processed.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Servlet Maintenance Programs<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>*AFTERACT<\/td><td>After any database action call external object.<\/td><\/tr><tr><td>*AFTERADD<\/td><td>After Add action call external object.<\/td><\/tr><tr><td>*AFTERDLT<\/td><td>After Delete action call external object.<\/td><\/tr><tr><td>*AFTERUPD<\/td><td>After Update action call external object.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>*BEFOREACT<\/td><td>Before any database action call external object.<\/td><\/tr><tr><td>*BEFOREADD<\/td><td>Before Add action call external object.<\/td><\/tr><tr><td>*BEFOREDLT<\/td><td>Before Delete action call external object.<\/td><\/tr><tr><td>*BEFOREUPD<\/td><td>Before Update action call external object.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>*CALCOBJ<\/td><td>Used with calculation External Objects or Constant calculations.<\/td><\/tr><tr><td>*READRECRD<\/td><td>Call object after each record is processed.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>*INITACT<\/td><td>Initialize Fields on page load for any Action.<\/td><\/tr><tr><td>*INITADD<\/td><td>Initialize Fields on page load for Add.<\/td><\/tr><tr><td>*INITDLT<\/td><td>Initialize Fields on page load for Delete.<\/td><\/tr><tr><td>*INITUPD<\/td><td>Initialize Fields on page load for Update.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>*ADVRECSEC<\/td><td>Row Level Security. Click <a href=\"https:\/\/www.mrc-productivity.com\/docs\/security\/advanced-record-level-security\">here<\/a> for additional information.<\/td><\/tr><tr><td>*STRADVSCH<\/td><td>Convert search text on filter (work-with only).<\/td><\/tr><tr><td>*STRSEARCH<\/td><td>Swap record selection.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>*STRUPBDFT<\/td><td>Set default key input.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>*SELECT<\/td><td>Create drop-down for add record on Maintain Records Screen.<\/td><\/tr><tr><td>*SELECTFLT<\/td><td>Create drop-down on List Records screen (work-with only).<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>*REDIRECT<\/td><td>URL Redirect, After any Action. Click <a href=\"https:\/\/www.mrc-productivity.com\/docs\/maint\/maintenance-redirection\">here<\/a> for more information on maintainer redirect.<\/td><\/tr><tr><td>*AFTADDRE<\/td><td>URL Redirect, After Add. Click <a href=\"https:\/\/www.mrc-productivity.com\/docs\/maint\/maintenance-redirection\">here<\/a> for more information on maintainer redirect.<\/td><\/tr><tr><td>*AFTDLTRE<\/td><td>URL Redirect, After Delete. Click <a href=\"https:\/\/www.mrc-productivity.com\/docs\/maint\/maintenance-redirection\">here<\/a> for more information on maintainer redirect.<\/td><\/tr><tr><td>*AFTUPDRE<\/td><td>URL Redirect, After Update. Click <a href=\"https:\/\/www.mrc-productivity.com\/docs\/maint\/maintenance-redirection\">here<\/a> for more information on maintainer redirect.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>*FLDVALIDA<\/td><td>Validate Inputs Before Add. Click <a href=\"https:\/\/www.mrc-productivity.com\/docs\/form-validation-techniques\/how-to-validate-user-input\">here<\/a> for additional information on validation.<\/td><\/tr><tr><td>*FLDVALIDU<\/td><td>Validate Inputs Before Update. Click <a href=\"https:\/\/www.mrc-productivity.com\/docs\/form-validation-techniques\/how-to-validate-user-input\">here<\/a> for additional information on validation.<\/td><\/tr><tr><td>*FLDVALIDD<\/td><td>Validate Inputs Before Delete. Click <a href=\"https:\/\/www.mrc-productivity.com\/docs\/form-validation-techniques\/how-to-validate-user-input\">here<\/a> for additional information on validation.<\/td><\/tr><tr><td>*FLDVALID<\/td><td>Validate Inputs Before All Actions. Click <a href=\"https:\/\/www.mrc-productivity.com\/docs\/form-validation-techniques\/how-to-validate-user-input\">here<\/a> for additional information on validation.<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Servlet Retrieval *CALCOBJ Used with calculation External Objects or Constant calculations. *STRADVSCH Before searching change advanced field values. Convert value for search input then process filter. *ADVRECSEC Row Level Security. Click here for additional information. *READRECRD Call object after each record is processed. *SELECTFLT Used with External drop down lists&#8230;.<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[259],"ht-kb-tag":[],"class_list":["post-1656","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-external-objects"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/1656","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=1656"}],"version-history":[{"count":16,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/1656\/revisions"}],"predecessor-version":[{"id":11317,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/1656\/revisions\/11317"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/media?parent=1656"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-category?post=1656"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-tag?post=1656"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}