Search this site
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
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
404
The page you have entered does not exist
Go to site home
Report abuse
Page details
Page updated
Report abuse