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
  • Maintainers
  • Utilizing Prompt Maintainers
Back to Manual

Using Prompt Maintainers within a Retrieval

 

The purpose of this document is to explain the process needed to have a user interface in which end-users enter a value on a Prompt page, then are redirected to a retrieval. The retrieval shows them the appropriate information based on the data entered from the Prompt.

To make this application, you will need to create the following:

· Multiple Record Retrieval (data output)

· New Table (In which the maintenance application will be written over)

· Single Row Maintainer (Prompt Page)

Step 1 — Build your Retrieval (data output)

When building your retrieval, please keep in mind what field you wish to pass to your retrieval. For instance, if I want my end user to search on customer name, I need to remember that the Customer Name field is CNAME. Otherwise, please build your retrieval as you normally would.

Note: Please remember the application number, as you will need it in Step 3.

Step 2 — Build your new table.

The purpose of this table is to serve as a container for your maintenance application data to reside in. In fact, once the data goes into this table, there is no need for the data to ever be examined. Create your table by going to the Admin screen, then click on the Registered Tables option. Lastly, click the "Create New Table" icon.

In the above picture, note that I created a two column table. One will hold a sequence key, while the other holds the name of the field that I wish to search on. In my case, I have named this SEARCHVALUE.

Note: The sequence field should be numeric.

Step 3 — Create your Maintenance Application (The Prompt)

· The Maintenance application needs to be written over the table you created in Step 2.

· Be sure to use the "Single Record Maintainer" template.

· Choose all fields.

· Set the SEQNO field as the Sequence Key.

· Go into Field Settings, and change SEQNO's field description to SEQNO *AUTOSEQ. This will set this field as an auto-sequential field. Click Accept.

·Build your application and click Edit Properties. Navigate to the After Actions tab, select Redirect: Add, and click the blue question mark. This dialog, seen below, will help you choose an application to redirect to, and map any parameters to it. In our case, we want to choose the retrieval made in step 1. In the additional parameters box, enter "rls_CNAME=CT". This tells our target retrieval that we will be searching on the CNAME field and that we want to use the contains search relationship. Lastly choose 'custom' from the dropdown next to our SEARCHVALUE field, and enter val_CNAME. This will map our input search value, to the built in search parameter in our retrieval.

Lastly, open m-Painter. You should see something like this:

Right click on the SEQNO row, and select "Hide Row". While the row will not be hidden within m-Painter, when the application is run, this row will be hidden. Please save your changes in m-Painter.

That's it! Simply run your Maintenance application. Enter part of a Customer Name, and press Accept. Your After Action property will take the user's input and pass it to the Inquiry only showing you the valid records!

Note: Your maintainer will keep a record of all searches that have been entered in the table it is built over. If you did not want this behavior, you could enable the 'Skip Database Action' option in the app properties.

Created: October 22, 2009 | 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

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

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.