{"id":5646,"date":"2013-07-15T10:34:12","date_gmt":"2013-07-15T15:34:12","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/legacy\/?page_id=5646"},"modified":"2017-06-12T12:06:11","modified_gmt":"2017-06-12T17:06:11","slug":"record-selections","status":"publish","type":"page","link":"https:\/\/www.mrc-productivity.com\/legacy\/m-power-build-process\/record-selections","title":{"rendered":"Record Selections"},"content":{"rendered":"<h1>Record Selections<\/h1>\n<p>Record Selections can be used to display subsets of data in an application.\u00a0 For instance, imagine a retrieval built over a sales history table with over 100,000 records. It is not always practical to show all 100,000 records at one time.\u00a0 Perhaps an end-user needs to be able to select a particular date range, or the data needs to be secured so that employees in different departments can only access specific sales records.\u00a0 Record selections make these types of tasks possible.<\/p>\n<p>When first accessing the record selection specification, you will be brought to the following page:<\/p>\n<p><a href=\"https:\/\/www.mrc-productivity.com\/legacy\/images\/record_selections.png\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"381\" class=\"alignnone  wp-image-5647\" alt=\"record_selections\" src=\"https:\/\/www.mrc-productivity.com\/legacy\/images\/record_selections.png\" srcset=\"https:\/\/www.mrc-productivity.com\/legacy\/images\/record_selections.png 800w, https:\/\/www.mrc-productivity.com\/legacy\/images\/record_selections-150x71.png 150w, https:\/\/www.mrc-productivity.com\/legacy\/images\/record_selections-300x142.png 300w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p>Field- Select the desired field. This list is populated by all fields currently selected in the application build process.<\/p>\n<p>Relation- Select the desired relationship.<\/p>\n<p>Value- Select either Constant Value, Application Field Value, or Runtime Value Prompt (only available in reports and summaries).\u00a0 Enter a value, as necessary.<\/p>\n<p style=\"padding-left: 60px;\">You can select either Constant Value, Application Field Value, or Runtime Value Prompt from the value drop down depending on the application type.\u00a0 If choosing Constant Value, input a value.\u00a0 This value, which the end user cannot change, will be compared to the field based on the relationship chosen. Choosing Application Field Value will allow you to select another field in your application to compare against the previously selected field.\u00a0 If you would like your end-user to have the option of inputting a value at runtime, select Runtime Value Prompt.<\/p>\n<p>And\/Or- Select &quot;And&quot; if you would like the the application to be filtered by the current record selection and the subsequent record selection, or &quot;Or&quot; if you would like the application to be filtered by either record selection.<\/p>\n<p>Once you&#39;ve entered the specifications, click accept.\u00a0 You will be brought to the following screen.<\/p>\n<p><a href=\"https:\/\/www.mrc-productivity.com\/legacy\/images\/record_selections1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"287\" class=\"alignnone  wp-image-5652\" alt=\"record_selections1\" src=\"https:\/\/www.mrc-productivity.com\/legacy\/images\/record_selections1.png\" srcset=\"https:\/\/www.mrc-productivity.com\/legacy\/images\/record_selections1.png 800w, https:\/\/www.mrc-productivity.com\/legacy\/images\/record_selections1-150x53.png 150w, https:\/\/www.mrc-productivity.com\/legacy\/images\/record_selections1-300x107.png 300w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p>From this page you can edit, copy,\u00a0 delete, or reorder any existing record selections.\u00a0 Additonally, you can create a new record selection by clicking on the green plus sign.<\/p>\n<p>For more information on record selections, click <a href=\"https:\/\/www.mrc-productivity.com\/legacy\/general\/working-with-record-selections\">here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Record Selections Record Selections can be used to display subsets of data in an application.\u00a0 For instance, imagine a retrieval built over a sales history table with over 100,000 records. It is not always practical to show all 100,000 records at one time.\u00a0 Perhaps an end-user needs to be able to select a particular date [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":5340,"menu_order":10,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-5646","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/5646","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/comments?post=5646"}],"version-history":[{"count":18,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/5646\/revisions"}],"predecessor-version":[{"id":8831,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/5646\/revisions\/8831"}],"up":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/5340"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/media?parent=5646"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}