Search this site
Embedded Files
Skip to main content
Skip to navigation
WOW Builders Guide
Home
*** WOW Support & Copyright Info ***
*** WOW: Video Tutorial Index ***
- WOW Quick Start
1. License and Version
- How to Install the WOW License
Tomcat and JDK Versions
2. Getting Started
* WOW Community Edition 7.0 Free Web Rad Tool
* WOW Makes WebSphere Easy
* WOW Version Control
* WOW: Install Troubleshooting Windows to AS400
- Modifying the WOW Interface
- Understanding Development Accounts
- WOW Installation Instructions
- WOW Init Parameters
3. Managing WOW MetaData with H2
4. Creating Connections
- Connecting to Different Databases
- Connecting to Microsoft Access and Excel
- Connecting to MS SQL Server
- Connecting to MySQL
- Connecting to Oracle
- Connecting to PostgreSQL
- Connecting using jTDS jdbc driver (open source)
- ConnectionOverrides Property Group
- IBM i Library List and Connection Properties
- Working with Connections
Connecting to IBM i (AS400)
5. Creating Applications
* Create QR code Web Application from a Database
* How to create a Web Data Inquiry Application in 5 minutes
* WOW: Modernizing AS400 Applications Quickly
* WOW: The fastest IBM i Application ever created
6. Controlling the Login
7. Creating Operations
* WOW Application / Operation Lock Status Property
* WOW Hover Panels & Drilldown Associations
- Application / Operation Lock Status property
- Controlling the Display Order of Operations
Hiding Operations
- Creating a Custom Please Wait Page
- HTML Code Operations
- User Defined Theme - HTML Code Operation
HTML Copy to Clipboard
Include HTML Operation in All WOW Pages
- Send to Support
- Setting a Next Operation
- SQL Operations
- Using a Please Wait Page
Auto-refresh
8. Selecting Records using SQL
- Controlling Which Columns Display
- Multiple Item Select
- Other Queries Using the SELECT Statement
- Searching within a string
- Using SQL IN To Select Multiple Values
- Wild Card (%) & LIKE in SQL
Reports with Breaks
Subqueries or WITH Clauses
9. Setting Key Position Field to Select Unique Records
10. SQL Tips
* IBM i SQL Assistant
- Inserting Records Using Parsing
- Inserting Records without SQL Commands
- Joined Inserts
11. Updating Records
- Joined Updates
- Table Updates
- Using a WHERE clause with the UPDATE statement
12. Inserting and Deleting Records
- Deleting Rows Without SQL Commands
- Inserting Records
- Joined Deletes
13. Field Descriptors
* WOW Date & Number Formatter Class Property
- Advanced Settings
- Copying a Row and Changing the User ID Field
- Dynamic Association Field
- Field Descriptor Formatter Class property
- Authorization Settings
- Database Settings
- Display and Possible Value Settings
- Datepicker
Formatting Columns With CSS
- Editing Rows and Basic Settings
Shared Field Descriptors (FDs)
- FD Cross Reference Tracker
- Settings
- Settings: Required and Not Required fields
- Field Descriptor Views and Prompting
- Last Field Value (*Last)
Field Level Help
13. Updating
14. WOW Features and Derived FDs
* Display Association Value Fields
* Tab Operations
- Conditionally Required Field
- Creating a Derived Field Descriptor
- Dashboard 2x2 & 3x3
- Extending Dashboards
- How to set up Dashboards
- Display Association Value Fields
- Displaying Images
- HTML5 Word-Wrap Feature
- MySQL FullText Search
- Predictive Search
- How to create: Derived FD
- How to create: Possible Values
- How to create: SQL Operation
- Resizable Column / Table
- Row Index Field Feature
- Run Operation Export to File
- Show Changed Value Only Field
15. WOW Toolbar and Icons
* WOW Toolbar
- Admin Window and Edit Operation
- Edit Application and Current Connection
- Edit Theme CSS and Session Logging
- SQL Execution and Enable Layout Management
16. Parameters: Types & Definitions
- Class Parameters: Syntax and Usage
- Executing Context, Request Attribute, SQL Replacement Text
- SQL Replacement Text: details
- Row, User, Global Variables, and Usage ID
- Runtime and Request
- Session, Special User Library, Row Collection, Current Application & Operation
- Setting Global Variables & Defaulting Param. Values
- SQL & Field Descriptor Prompt
- Table, Parameter, and Context
17. Application Level Property Settings
18. Operation Property Groups
- AutoRun {}, Browser{}, and Chart {}
- Config {}, CSV{}, and Detail Display{}
-DetailDisplay {} property group
- DisplayColumns {} and Email{}
- FieldSet{}: LayOut, Order, Appearance, and Customize
- Adding Empty Cells and Text
- Changing Column and Row Spans
- Join {} and LayoutDisplay {}
- OperationLabels {} and Horizontal Parameters
- OptionalSignon {} & Paging{}
- gotoPage property
- rowsPerPage property
- rowsPerPageText property
- ParameterOperators {}, PDF{}, & PleaseWait{}
- PossibleValues {} and ReportBreak {}
- SignOn {} and SpooledFile{}
- SQLContext {}, StoredProcedure {}, Styles {}, & Tabs {}
- TableDisplay {}
{TableDisplay} details
- XLS{}
-Action {}, Actions {}, ActionDescriptor{}
-FieldDescriptor{}
19. WOW Wizards
Tomcat Log Files
20. Activating Alerts for an Application
* WOW: Application Email Alerts
- Configuring an Application to Send Email Alerts
- Configuring an Email Sever
21. Collapsible Items
- Collapsible Field Sets & Creating Collapsible Field Sets
- Collapsible Operations
- Field Sets
- Result Tables
- Row Details
22. Sorting
- Controlling the Sorting Behavior
23. Associations: 1-1 and 1-Many
- HTML: Code Assoc. , Reference Assoc., & Assoc. Java Ops.
24. Creating Associations
- HTML Code Association Example
- HTML Reference Association Example
25. Associated Inserts
- Associated Updates and Deletes
- Join Associations
26. Possible Values
* WOW Multiple Dependent Fields Possible Values
- Multiple Fields in Possible Values Drop Down
- Possible Value Keys and Selector
- Possible Values and the – All – Value
- Possible Values Keys Wizard
- Access PV Keys: List & Wizard
- Possible Values Paging and Grouping
- Possible Values Search (PV)
- Removing - Next / Previous from PV List
Deferred Possible Values
On Demand Possible Values
27. Auto Population of Fields
28. Execution Groups
Sharing Parameters
29. WOW Environment Modes (Development versus Production)
- How WOW picks the connection to use
- Introduction & WOW Environments
- Setting the environment as a servlet context parameter (Eclipse IDE)
- Setting the environment in the Java system properties
- Setting WOW's Environment: WEB.XML & Servlet Context Parameter
- Setting a field descriptor’s environment
- Setting a project schema’s environment & Other environment configurations
- Viewing WOW’s environment & Setting a connection's environment
30. MetaData Application Libraries
* Installing Tomcat and WOW on IBM i5 (AS/400)
- Creating Application Libraries
- Making a Copy of MYSQL Metadata Library
- Using Application Libraries
- Using the CPYWOWENV Command (AS400/iSeries/IBM i Only)
- WOW Metadata
- Manage Project Schema
- Metadata Compatibility
- Metadata Updates
31. WOW User Defined Display Components
- Currency Formatters
- HTML5 Gauge Example
- HTML5 Gauge Test Example
- HTML5 Meter Example
- HTML5 Progress Bar Example
- QR Code
32. WOW Advanced UI Components
- Accordion
- Portal
- Tab
33. WOW Drag and Drop
* WOW Sortable Rows
- Property Group
- Sortable HTML Table
- Sortable HTML Table w/Prompt
34. File Upload and Download
- Set Up File Download
- Set Up File Upload
35. Work Flow
36. Context Menu
- Controlling the Context Menu Appearance
37. Auto Complete
- Auto Complete Properties
- Configuring Auto Complete Fields
- SQL-based Auto Complete
38. Replacement Libraries
39. Replacement Library Implementation Precedence
40. Tabs
- Further Tab Customization
- Tab: Auto, Allow, Empty, Change, & Hide
- Using Tabs and Configurations
41. Stored Procedures
42. Running Your Applications
43. WOW Security Protocols
* WOW Business Rules: Website Blocker Example
- Field Level Authorization Settings
- Implementing Single Sign On
- LDAP Property Group
- LDAP: Enabling, Restricting, Configuring, & Adding Groups
- LDAP; Configure Authentication
- Securing Fields and Operations using "WOW_TRUE" and User Authorization Operations
- Securing Fields and Operations with User Authorization Operations
- Securing Operations
- Security Protocols continued...
- Table Authorization
- Unsecured
LDAP Plus Operation
44. WOW Utilities & Users
- Possible Value Keys, Configuration Values, User Messages
- Themes and Custom Themes
46. Utilizing Existing RPG Applications
- Calling an RPG Program That Returns a MODS (Array) in RPG Free
- Calling an RPG Program That Returns a MODS (Array) in RPG IV
- More Than One User Running the Operation at the Same Time
47. Advanced Development Techniques
Virtual Applications [Pro]
48. WOW Performance
- Controlling the Number of Records Returned & Fields Read
- Fragment properties
- Groups with multiple parameter fragments
- Optimizing SQL Performance for AS400 (iSeries)
- SQL Adjustments
- Tomcat Server Performance & SQL Fragments
Cache Control
Example of Setting up Cache Control
49. Actions/Events: Create & Execute
- Action: Location, Messages, Authorization, & Implementation
- Adding Action to Run 2nd Operation That Remembers Rows Selected
- Events: Creating, Entry Info, Event Scope, Triggers, & Execution info
- Example Uses: Adding Actions and Events
50. Troubleshooting and Debugging WOW
- Change User Name and Password of WOW for new metadata system
- Configuring Logging (Log4j)
- Debug & Troubleshoot: SQL w/ period in name, Using Linux or Unix, using Current Date, & Tables / Views
Actions and Events Fix
Increase Size of Operation Code Field
Troubleshooting Email Problems
51. WOW Administration and Support: Backup Metadata & App. Code
- Disaster Recovery: Version Control, Web Resources, Metadata
- Web Application Server Information
WOW Add-On Product Guides
Configuring Log4j2
52. Architecture, Security and Deployment
Log4J Security Issue
Customizing the User Interface
Customize UI with JQUERY
Multilevel Menus
- Reading Excel Files From WOW
- Creating Reports and Graphs with WOW and Excel
- Creating Reports from Data Imported from WOW into Excel & Restrictions
- Integrate & Set WOW with Existing Excel Files
- Setting up a New Web Query in Excel 2000 or earlier
- Setting up a New Web Query in Excel 2002
- Steps to create a Web Query
45. Excel capabilities in WOW
Excel: Syntax of SQL: SELECT & UPDATE statement
Uploading and Serving Images
WOW Dowloads
WOW Future Directions
WOW Builders Guide
On Demand Possible Values
TODO: Chuck: Add details on how what On Demand PVs and how to use.
Report abuse
Page details
Page updated
Report abuse
