External Objects

Business Rules Designer

Business Rules Designer   Jump to: Overview Video Tutorial Creating an m-Power Business Rule Business Rule Process Components Calling Business Rules Other Notes Overview The Business Rules Designer allows developers to create their own custom business processes, directly in m-Power, without any coding. These business rules can be invoked on a per row basis (such […]

Return Data External Object

Return Data External Object   Beginning with the May 2013 update of m-Power, developers will have access to a Return Data Java external object for use within maintenance applications. This object takes in 1 parameter to find a row within a retrieval, and then returns that value(s) to your maintainer. A common example of using […]

Regular Expression External Object

Regular Expression External Object   Beginning with the May 2013 release of m-Power, developers will be able to use a Regular Expression Java external object for parsing field values. The most common example of when this would be done is with the Email Upload template, in order to grab a piece of data from one […]

Working with Lengthy Fields

Working with Lengthy Fields   m-Power has always easily handled fields of lengths less than 1000 characters. Beginning with the August 20th, 2012 update, fields of any length can be used within m-Power. When registering tables, simply add them as normal and the proper field lengths will be registered: Calculations also now support large field […]

Sample External Object (Java) Source Code

Sample External Object (Java) Source Code   package MRCWORKLIB; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import org.apache.log4j.Logger; import com.mrc.dbo.MrcConnection; /**  * Delete Order # from MRCWORKLIB.ORDDET  * 2011-09-22  * @author RH  *  * 2. Define external object  *  * Class Name: MRCWORKLIB.DELDETAIL  * Method Name: run  * Then define one object parm to […]

Maintenance Redirection

Redirecting from a Maintainer Occasionally you may want to redirect to another page after a user has performed an action within a Maintenance application (such as Update, Delete, or Add). One of the most common uses of the redirect is after a user fills out a form. Once they have completed and press the "Accept" […]

Sample External Object (SQL) Source Code

Sample External Object (SQL) Source Code   CREATE procedure MRCWORKLIB.DELDETAIL(  inout orderno decimal(6,0)) LANGUAGE SQL IS DETERMINISTIC MODIFIES SQL DATA BEGIN DELETE FROM MRCWORKLIB.ORDDET WHERE ORDNUM = orderno; END

Sample External Object (RPG)

Calling a Sample External Object (RPG)   This document will explain how to create, register, and call a sample External Object written in RPG. Recall from basic training that the purpose of an External Object is to call your back-end business logic directly through an m-Power web application. In this case, the purpose of this […]

Sample External Object (SQL)

Calling a Sample External Object (SQL)   This document will explain how to create, register, and call a sample External Object written in SQL. Recall from basic training that the purpose of an External Object is to call your back-end business logic directly through an m-Power web application. In this case, the purpose of this […]

Sample External Object (Java)

Calling a Sample External Object (Java)   This document will explain how to create, register, and call a sample External Object written in Java. Recall from basic training that the purpose of an External Object is to call your back-end business logic directly through an m-Power web application. In this case, the purpose of this […]