- HTML Code Operations

HTML Code Operations

Like the SQL Operations described above, HTML operations use HTML to create operations that display HTML code. The HTML Operations can create a new level of customization by using HTML to enhance WOW Applications. Below is an example of an HTML Operation being used to create a welcome screen for a WOW application.

This is what the welcome page would look like based on the HTML code above.

For more information on HTML code programming visit http://www.w3schools.com/html/default.asp

Other Operation Types

• • Associated Java Operation - [PRO] Specifies a Java class where actual code can be executed.

  • Associated Join - [PRO] An operation that joins data from two separate systems.

  • Association 1-1 - An operation associated with a field. This operation will display a single row.

  • Association 1-Many - An operation associated with a field. This operation will display a results table (one or more rows).

  • Authentication - Authentication allows for added security when using a WOW Application. Each user will have to enter a username and password before they can view or edit the application in question.

  • Auto Populate - [EE] An SQL operation associated with a field that will retrieve information and populate other fields in the given Row based on the value of that field.

  • Auto-run - Batch Process - [PRO] An operation that is scheduled to run automatically when an application is started.

  • Auto-run - Email - [PRO] An SQL operation that returns a list of rows which contain email fields (usage ID -40). These email fields can be used in conjunction with the Auto Run capabilities of WOW.

  • Blob Download - [PRO] An operation associated with a field (similar to Association 1-1) where Blob data (.jpg, image, etc.) is downloaded when the field is clicked on.

  • Execution Group - Operation that actually runs one or more other operations. After defining the Execution Group operation, define other (normal) operations and set their "parent operation" to the Execution Group operation. The other operations will not appear in the TOC, but instead will be run when the Execution Group operation is run. For example, if the other operations were called OP1 and OP2, when the Execution Group operation is run, the results would contain results from OP1, followed by results from OP2.

  • File Upload - [PRO] Operation associated with a field (similar to Association 1-1) where a file is uploaded when a field is clicked.

  • HTML Code - Inserts HTML directly into your applications. This can be used to customize your program with a startup screen, logo, or any other custom HTML code you would like to add to your application. For details on how to change your theme or the look and feel of your application using HTML Code operations, please click here.

  • HTML Code Association - As the name suggests, this is the association version of the HTML Code operation. It provides the same functionality as the HTML Code operation but is set on a field as an association. However, since it is an association, row parameters (??field) can be placed anywhere in the HTML code.

  • HTML Reference - Specifies a Web Site address that WOW will open in a new window.

  • HTML Reference Association - [PRO] Similar to all associations in that upon execution, values from a source row may be used to retrieve dynamic content for an http URL. For example, if a selected record contained address information, you could create an HTML Reference Association that linked to Google™ Maps or some other Internet mapping service. Dynamic content in the URL can be replaced in a similar fashion to replacing values for SQL fields.

  • JSP Reference - [PRO] Inserts a JSP file directly into your applications. Use the JSP File field, to specify the path to the JSP file.

  • Possible Values - Uses data from a database to create the possible values of the field.

  • Possible Values Search - Possible Values operation opens in a popup window so that the Possible Value for a particular field canbe picked from a result set dynamically. Allows the user to specify search parameters and see other values in the row while selecting field value.

  • Possible Values Selector - Behaves in a similar fashion to the Possible Values operation; however, this operation causes a round-trip to the server when the value of the field changes.

  • Referrer Authorization - Used to allow only users coming from a certain web page into your application.

  • Tabbed - A secondary operation displayed in a tabbed layout.

  • User Authentication List - An application can be secured by creating a User Authentication List operation which is defined by a comma separated list of user names and passwords. When the user logs on to an application with list based security they are prompted for their user name and password. This is a useful option when the WOW developer wants to quickly implement application level security for a small group of users without having set up table or user profile based security.

  • User Authorization List - An operation that holds a static list of user names (in the operation's code field) defined when this operation is created and is used to restrict access to certain fields or operations. This authorization operation is useful when a small number of users will have restricted access to certain fields and/or operations.

  • User Authorization Operation - An operation that dynamically returns a single column of user names. This type of operation is a more dynamic solution than the user authorization list. An SQL statement is defined that returns a result containing a single column of user names.

  • User Group Authorization List - [EE 7.0] An operation that holds a static list of user group names (in the operation's code field) defined when this operation is created and is used to restrict access to certain fields or operations. Users can be designated to belong one or more groups (e.g. LDAP groups). This authorization operation is useful when a small number of users will have restricted access to certain fields and/or operations. The application signon would also need to be configured to collect a user's list of groups they belong to. Currently, only LDAP groups are supported (see Configure Group Search Properties for more details).

  • User Group Authorization Operation - [EE 7.0] is a more dynamic solution than the user group authorization list. An SQL statement is defined that returns a result containing a single column of user group names. The application signon would also need to be configured to collect a user's list of groups they belong to. Currently, only LDAP groups are supported (see Configure Group Search Properties for more details).

  • View Selected Association - An operation associated with a field. This operation will display the selected record (source row) in a Details view without hitting the database again.

TODO: Link above operation types to additional content.