mrc logo mrc logo
  • m-Power m-Power
    What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    m-Power Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • Solutions Solutions
    What does m-Power build?
    Overview Database Front-Ends Reporting CRM Systems Business Intelligence Dashboards Inventory Management Mobile Apps ERP Enhancements Modernization Spreadsheets to the web MS Access to the web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Data Exploration Budgeting & Forecasting APIs and Web Services Db2 Web Query Alternative
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Development Services Training Mentoring
  • About About
    Overview Partners Press Releases Careers Events Contact Blog
  • Support Support
    Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • Build Process
  • Record Selections
Back to Manual

Record Selections

Record Selections can be used to display subsets of data in an application.  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.  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.  Record selections make these types of tasks possible.

When first accessing the record selection specification, you will be brought to the following page:

record_selections

Field- Select the desired field. This list is populated by all fields currently selected in the application build process.

Relation- Select the desired relationship.

Value- Select either Constant Value, Application Field Value, or Runtime Value Prompt (only available in reports and summaries).  Enter a value, as necessary.

You can select either Constant Value, Application Field Value, or Runtime Value Prompt from the value drop down depending on the application type.  If choosing Constant Value, input a value.  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.  If you would like your end-user to have the option of inputting a value at runtime, select Runtime Value Prompt.

And/Or- Select "And" if you would like the the application to be filtered by the current record selection and the subsequent record selection, or "Or" if you would like the application to be filtered by either record selection.

Once you've entered the specifications, click accept.  You will be brought to the following screen.

record_selections1

From this page you can edit, copy,  delete, or reorder any existing record selections.  Additonally, you can create a new record selection by clicking on the green plus sign.

For more information on record selections, click here.

Created: July 15, 2013 | Modified: June 12, 2017

Search


Browse By Category

Build Process (13)
Starting with m-Power (8)
Retrievals (10)
Reports (15)
Summaries (4)
Maintainers (17)
Graphs (8)
m-Power Data Explorer (4)
General (24)
Calculations (5)
Utilities (9)
m-Power Administration (23)
Security (11)
Freemarker (6)
m-Painter (29)
Form Validation (5)
External Objects & UDFs (12)
Deprecated Documentation (23)
Bootstrap Templates (7)

Popular Tags

Maintainers Advanced Java Build Process Admin Summaries Data Dictionary Retrievals Compiling Bootstrap Templates Reports Email Report Dates Performance Popular Freemarker Form Validation External Objects Database Graphs Administration Dropdowns DB2 Retrieval SQL Video Excel Tomcat Security mrc-Productivity Series Prompt Screens RPG Parameters m-Painter App Properties Application Properties Getting Started Production Bar Graphs Graph Properties Graphing Maintainer Record Selections Calculations

See all tags »

michaels, ross & cole, ltd. (mrc)

Privacy Policy Cookie Policy Cookie Settings Notice at Collection Do Not Sell or Share My Personal Information

mrc (US)

2001 Midwest Road
Suite 310
Oak Brook, IL 60523
630-916-0662

mrc (UK)

Mortlake Business Centre
20 Mortlake High Street
London, SW14 8JN
+44-20-335-59566


© 2024 mrc. All rights reserved.