O4W 2.0 Reference Guide [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== O4W 2.0 Reference Guide ======

OpenInsight 10.0

O4W 2.0 Reference Guide


{{guides:o4w:oi10:reference_guide:image002.png?230x64}}


{{guides:o4w:oi10:reference_guide:image004.png?236x55}}

**A Division of Revelation Technologies, Inc.**



==== Introduction ====

OpenInsight for Web (O4W) is a flexible and powerful web development toolkit for OpenInsight.

Don’t limit your application to the desktop! OpenInsight for Web (O4W) is a rapid application development tool that lets you generate responsive forms, reports, and dashboards. Use our GUI drag-and-drop to lay out your forms and then test in both desktop and mobile browser mode. Or use our full-function API to create the most sophisticated web pages.

The O4W Development Toolkit makes it possible for multivalue developers with limited or no HTML/XML/JavaScript experience to develop feature rich web pages. O4W is designed to work the way multivalue developers think, taking advantage of the skills and knowledge they already have. While users with more web development experience can use O4W's advanced features, all developers can create modern web applications (using JavaScript, XHTML, and AJAX) through O4W's APIs and integrated wizards.

This Reference Guide is designed to provide a detailed look into the properties of each of the O4W components:

 



 * O4W Menu

 * O4W Form

 * O4W WYSIWYG

 * O4W Reporter

 * O4W Procedures

 * O4W Dashboard

 * DB Management

 * OI Maintenance

 * O4W Maintenance

 * Deployment Tools

 * O4W Commuter Module

 * O4W Templates

 * O4W Application Program Interface (API)



==== Browser compatibility ====

 

O4W uses advanced web technologies to deliver an interactive and dynamic web experience.  For the best results, users and developers should use the most current versions of their web browser.  As of early 2018, these versions are currently:


Chrome 64+, Firefox 58+, Edge 41+, Opera 51+, Safari 5+ (Windows), Safari 11+ (mac)


The minimal suggested versions for full functionality are:


Chrome 63, Firefox 57, Edge 40, IE 11, Opera 51+, Safari 4 (Windows), Safari 10 (mac)

 

Developers and users may choose to use older versions of their web browser, at the risk of reduced functionality, by changing the version of jQuery that O4W uses.  Changing to jQuery 1.12 (or earlier)  allows developers and users to support older browsers including:

IE 6-8, Opera 12.1x, Safari 5.1+


Developers who choose to support these older browsers should carefully test any plugins and functionality that their web sites may rely upon.

For Mobile development, the minimal recommended browsers are the stock browser on Android 4.0+ and Safari on iOS7+. For a complete list of supported mobile browsers, please see:

https://jquerymobile.com/browser-support/1.4/

**Note:** O4W displays a warning message on any browser that does not meet the suggested version and release requirements.  The javascript to create and display this message is stored in the O4W configuration record, and this functionality will be updatable via DB Management,O4W Maintenance, Configuration Records, Browsers Tab.

==== Topics ====

[[guides:o4w:oi10:reference_guide:o4w_users|Creating O4W Users]]

[[guides:o4w:oi10:reference_guide:o4w_users#The_O4W_user_and_password|The O4W user and password]]

[[guides:o4w:oi10:reference_guide:o4w_users#O4W_Login|I.       O4W Login]]

[[guides:o4w:oi10:reference_guide:o4w_users#O4W_Logout|II.     O4W Logout]]

[[guides:o4w:oi10:reference_guide:o4w_users#O4W_Start_Page|III.         O4W Start Page]]

[[guides:o4w:oi10:reference_guide:o4w_menu|O4W Menu]]

[[guides:o4w:oi10:reference_guide:o4w_menu#Create_Modify|I.       Create/Modify]]

[[guides:o4w:oi10:reference_guide:o4w_menu#Copy_Delete|II.     Copy/Delete]]

[[guides:o4w:oi10:reference_guide:o4w_menu#Run|III.         Run]]

[[guides:o4w:oi10:reference_guide:o4w_form|O4W Form]]

[[guides:o4w:oi10:reference_guide:o4w_form#Create_Modify|I.       Create/Modify]]

[[guides:o4w:oi10:reference_guide:o4w_form#O4W_Form_Commuter|II.     O4W Form Commuter Module]]

[[guides:o4w:oi10:reference_guide:o4w_form#Copy_Delete|III.         Copy/Delete]]

[[guides:o4w:oi10:reference_guide:o4w_form#Run|IV.         Run]]

[[guides:o4w:oi10:reference_guide:o4w_WYSIWYG|O4W WYSIWYG]]

[[guides:o4w:oi10:reference_guide:o4w_WYSIWYG#create_Modify|I.       Create/Modify]]

[[guides:o4w:oi10:reference_guide:o4w_WYSIWYG#O4W_WYSIWYG_Commuter|II.     O4W WYSIWYG Commuter Module]]

[[guides:o4w:oi10:reference_guide:o4w_WYSIWYG#Copy_Delete|III.         Copy/Delete]]

[[guides:o4w:oi10:reference_guide:o4w_WYSIWYG#Run|IV.         Run]]

[[guides:o4w:oi10:reference_guide:o4w_WYSIWYG#Reset_Defaults|V.     Reset Defaults]]

[[guides:o4w:oi10:reference_guide:o4w_Reporter|O4W Reporter]]

[[guides:o4w:oi10:reference_guide:o4w_Reporter#Create_Modify|I.       Create/Modify]]

[[guides:o4w:oi10:reference_guide:o4w_Reporter#O4W_Reporter_Commuter|II.     O4W Reporter Commuter Module]]

[[guides:o4w:oi10:reference_guide:o4w_Reporter#Register_BRW|III.         Register BRW]]

[[guides:o4w:oi10:reference_guide:o4w_Reporter#Copy_Delete|IV.         Copy/Delete]]

[[guides:o4w:oi10:reference_guide:o4w_Reporter#Copy_Delete_AdHoc|V.     Copy/Delete AdHoc]]

[[guides:o4w:oi10:reference_guide:o4w_Reporter#Run|VI.         Run]]

[[guides:o4w:oi10:reference_guide:o4w_Reporter#Run_AdHoc|VII.       Run AdHoc]]

[[guides:o4w:oi10:reference_guide:O4W_Procedures|O4W Procedures]]

[[guides:o4w:oi10:reference_guide:O4W_Procedures#Create_Modify|I.       Create/Modify]]

[[guides:o4w:oi10:reference_guide:O4W_Procedures#Register|II.     Register]]

[[guides:o4w:oi10:reference_guide:O4W_Procedures#Copy_Delete|III.         Copy/Delete]]

[[guides:o4w:oi10:reference_guide:O4W_Procedures#Run|IV.         Run]]

[[guides:o4w:oi10:reference_guide:O4W_Procedures#Help|V.     Help]]

[[guides:o4w:oi10:reference_guide:O4W_Dashboard|O4W Dashboard]]

[[guides:o4w:oi10:reference_guide:O4W_Dashboard#Create_Modify|I.       Create/Modify]]

[[guides:o4w:oi10:reference_guide:O4W_Dashboard#Copy_Delete|II.     Copy/Delete]]

[[guides:o4w:oi10:reference_guide:O4W_Dashboard#Run|III.         Run]]

[[guides:o4w:oi10:reference_guide:O4W_Dashboard#How_to_Create_a_geochart_with_openinsight_for_we|IV.         How to Create a GeoChart with OpenInsight for Web]]

[[guides:o4w:oi10:reference_guide:db_management#DB_Management_–_OI_maintenance|DB Management – OI Maintenance]]

[[guides:o4w:oi10:reference_guide:db_management#Applications|I.       Applications]]

[[guides:o4w:oi10:reference_guide:db_management#Tables|II.     Tables]]

[[guides:o4w:oi10:reference_guide:db_management#Procedures|III.         Procedures]]

[[guides:o4w:oi10:reference_guide:db_management#DB_Management_–_O4W_maintenance|DB Management – O4W Maintenance]]

[[guides:o4w:oi10:reference_guide:db_management#permissions|I.       Permissions]]

[[guides:o4w:oi10:reference_guide:db_management#Messages|II.     Messages]]

[[guides:o4w:oi10:reference_guide:db_management#RSS_Feeds|III.         RSS Feeds]]

[[guides:o4w:oi10:reference_guide:db_management#Configuration_Records|IV.         Configuration Records]]

[[guides:o4w:oi10:reference_guide:db_management#About|V.     About]]

[[guides:o4w:oi10:reference_guide:db_management#DB_Management_–deployment_tools|DB Management – Deployment Tools]]

[[guides:o4w:oi10:reference_guide:db_management#Deployment_Management|I.       Deployment Management]]

[[guides:o4w:oi10:reference_guide:O4W_Form_Commuter_Module|O4W Form Commuter Module]]

[[guides:o4w:oi10:reference_guide:O4W_Form_Commuter_Module#The_O4W_Form_Commuter_module|I.       The O4W Form Commuter Module]]

[[guides:o4w:oi10:reference_guide:O4W_Form_Commuter_Module#The_O4W_Form_Event_model|II.     The O4W Form Event Model]]

[[guides:o4w:oi10:reference_guide:O4W_Form_Commuter_Module#The_O4W_Form_Events|III.         The O4W Form Events]]

[[guides:o4w:oi10:reference_guide:O4W_Form_Commuter_Module#OpenInsight_Field_names_and_web_form_input_controls|IV.         OpenInsight Field Names and Web Form Input Controls]]

[[guides:o4w:oi10:reference_guide:O4W_Form_Commuter_Module#Example_Code|V.     Example Code]]

[[guides:o4w:oi10:reference_guide:O4W_Form_Commuter_Module#O4W_Form_Commuter_module_events|VI.         O4W Form: Commuter Module Events]]

[[guides:o4w:oi10:reference_guide:O4W_Form_Commuter_Module#O4WCommuterUtility_section_identification|VII.       O4WCommuterUtility Section Identification]]

[[guides:o4w:oi10:reference_guide:O4W_Form_Commuter_Module#Disabling_one_or_more_tabs_on_a_multi-tab_o4w_form-wizard_designed_form|VIII.          Disabling one or more tabs on a multi-tab O4W Form-wizard designed form]]

[[guides:o4w:oi10:reference_guide:O4W_Form_Commuter_Module#Show_or_hide_one_or_more_groups_on_a_o4w_form-wizard_designed_form|IX.         Show or hide one or more “groups” on a O4W Form-wizard designed form]]

[[guides:o4w:oi10:reference_guide:O4W_Form_Commuter_Module#O4W_Report_Commuter_module_events|X.     O4W Report: Commuter Module Events]]

[[guides:o4w:oi10:reference_guide:O4W_Form_Commuter_Module#O4W_WYSIWYG_Commuter_module|O4W WYSIWYG Commuter Module]]

[[guides:o4w:oi10:reference_guide:O4W_Form_Commuter_Module#The_O4W_WYSIWYG_commuter_module|XI.         The O4W WYSIWYG Commuter Module]]

[[guides:o4w:oi10:reference_guide:O4W_Form_Commuter_Module#The_O4W_WYSIWYG_event_model|XII.       The O4W WYSIWYG Event Model]]

[[guides:o4w:oi10:reference_guide:O4W_Form_Commuter_Module#The_O4W_WYSIWYG_events|XIII.          The O4W WYSIWYG Events]]

[[guides:o4w:oi10:reference_guide:O4W_Form_Commuter_Module#OpenInsight_Field_names_and_web_form_input_controls|XIV.          OpenInsight Field Names and Web Form Input Controls]]

[[guides:o4w:oi10:reference_guide:O4W_Form_Commuter_Module#Example_Code|XV.       Example Code]]

[[guides:o4w:oi10:reference_guide:O4W_Form_Commuter_Module#O4W_WYSIWYG_Commuter_module_events|XVI.          O4W WYSIWYG: Commuter Module Events]]

[[guides:o4w:oi10:reference_guide:O4W_Form_Commuter_Module#O4WCommuterUtility_section_identification|XVII.        O4WCommuterUtility Section Identification]]

[[guides:o4w:oi10:reference_guide:O4W_Form_Commuter_Module#Disabling_one_or_more_tabs_on_a_multi-tab_o4w_wysiwyg_form|XVIII.      Disabling one or more tabs on a multi-tab O4W WYSIWYG form]]

[[guides:o4w:oi10:reference_guide:O4W_Form_Commuter_Module#Show_or_hide_one_or_more_groups_on_a_o4w_wysiwyg_form|XIX.          Show or hide one or more “groups” on a O4W WYSIWYG form]]

[[guides:o4w:oi10:reference_guide:O4W_Templates|O4W Templates]]

[[guides:o4w:oi10:reference_guide:O4W_Templates#O4W_Templates|I.       O4W Templates]]

[[guides:o4w:oi10:reference_guide:O4W_Templates#O4W_Tags|II.     O4W Tags]]

[[guides:o4w:oi10:reference_guide:O4W_Templates#O4W_Template_Settings|III.         O4W Template Settings]]

[[guides:o4w:oi10:reference_guide:O4W_Templates#Additional_Templates|IV.         Additional Templates]]

[[guides:o4w:oi10:reference_guide:O4W_Templates#Example|V.     Example]]

[[guides:o4w:oi10:reference_guide:O4W_api|O4W Application Program Interface (API)]]

[[guides:o4w:oi10:reference_guide:O4W_api#Design_Flow|I.       Design Flow]]

[[guides:o4w:oi10:reference_guide:O4W_api#O4W_Toolkit_Style_and_option_functions|II.     O4W Toolkit Style and Option functions]]

[[guides:o4w:oi10:reference_guide:O4W_api#O4W_Toolkit_Display_element_functions|III.         O4W Toolkit Display Element functions]]

[[guides:o4w:oi10:reference_guide:O4W_api#O4W_Toolkit_Input_control_functions|IV.         O4W Toolkit Input Control functions]]

[[guides:o4w:oi10:reference_guide:O4W_api#O4W_Toolkit_Action_functions|V.     O4W Toolkit Action functions]]

[[guides:o4w:oi10:reference_guide:O4W_api#Click_Change_Events|Click/Change Events]]

[[guides:o4w:oi10:reference_guide:O4W_api#Client_side_UI_Animation_events|Client-side UI/Animation Events]]

[[guides:o4w:oi10:reference_guide:O4W_api#Other_Client-side_control_events|Other Client-Side Control Events]]

[[guides:o4w:oi10:reference_guide:O4W_api#Focus_Events|Focus Events]]

[[guides:o4w:oi10:reference_guide:O4W_api#Validation_Events|Validation Events]]

[[guides:o4w:oi10:reference_guide:O4W_api#Table_Management_Events|Table Management Events]]

[[guides:o4w:oi10:reference_guide:O4W_api#Miscellaneous_Events|Miscellaneous Events]]

[[guides:o4w:oi10:reference_guide:O4W_api#O4W_Toolkit_Utility_functions|VI.         O4W Toolkit Utility functions]]

[[guides:o4w:oi10:reference_guide:O4W_Mobile|O4W Mobile]]

[[guides:o4w:oi10:reference_guide:O4W_Mobile#Mobile_Page_Design|Mobile Page Design]]

[[guides:o4w:oi10:reference_guide:O4W_Mobile#Mobile_Application_Design|Mobile Application Design]]

[[guides:o4w:oi10:reference_guide:O4W_Mobile#O4W_Mobile_APIs|O4W Mobile APIs]]

[[guides:o4w:oi10:reference_guide:O4W_Mobile#Mobile_Device_Orientation|Mobile Device Orientation]]

[[guides:o4w:oi10:reference_guide:O4W_Mobile#Enhancing_User_Interface_elements|Enhancing User Interface Elements]]

[[guides:o4w:oi10:reference_guide:O4W_Mobile#Grouping_Elements_together|Grouping Elements Together]]

[[guides:o4w:oi10:reference_guide:O4W_Mobile#Accessibility_Enhancement|Accessibility Enhancement]]

[[guides:o4w:oi10:reference_guide:O4W_Mobile#Special_Textbox_Types|Special Textbox Types]]

[[guides:o4w:oi10:reference_guide:O4W_Mobile#Enhanced_Listboxes|Enhanced Listboxes]]

[[guides:o4w:oi10:reference_guide:O4W_Mobile#Enhanced_Lists|Enhanced Lists]]

[[guides:o4w:oi10:reference_guide:O4W_Mobile#Mobile_Pizza_Ordering_application|Mobile Pizza Ordering Application]]

[[guides:o4w:oi10:reference_guide:O4W_Mobile#Building_Paginated_tables|Building Paginated tables]]

[[guides:o4w:oi10:reference_guide:O4W_Sample_Stored_procedures|O4W Sample Stored Procedures..]]

[[guides:o4w:oi10:reference_guide:O4W_Sample_Stored_procedures#O4W_EXAMPLE0|I.       O4W_EXAMPLE0]]

[[guides:o4w:oi10:reference_guide:O4W_Sample_Stored_procedures#O4W_EXAMPLE1|II.     O4W_EXAMPLE1]]

[[guides:o4w:oi10:reference_guide:O4W_Sample_Stored_procedures#O4W_EXAMPLE2|III.         O4W_EXAMPLE2]]

[[guides:o4w:oi10:reference_guide:O4W_Sample_Stored_procedures#O4W_EXAMPLE3|IV.         O4W_EXAMPLE3]]

[[guides:o4w:oi10:reference_guide:O4W_Sample_Stored_procedures#O4W_REVSHOW|V.     O4W_REVSHOW]]

[[guides:o4w:oi10:reference_guide:O4W_Sample_Stored_procedures#Login_Screen|VI.         Login Screen]]

[[guides:o4w:oi10:reference_guide:O4W_Sample_Stored_procedures#Invoice_Form|VII.       Invoice Form]]

[[guides:o4w:oi10:reference_guide:O4W_Sample_Stored_procedures#Order_Entry|VIII.          Order Entry]]

[[guides:o4w:oi10:reference_guide:O4W_Sample_Stored_procedures#Generic_Edit_Record_routine|IX.         Generic Edit Record Routine]]

[[guides:o4w:oi10:reference_guide:O4W_Sample_Stored_procedures#Creating_a_subroutine_to_populate_an_o4w_listbox|X.     Creating a subroutine to populate an O4W Listbox]]

[[guides:o4w:oi10:reference_guide:O4W_Sample_Stored_procedures#Creating_a_subroutine_to_populate_an_o4w_type_ahead_listbox|XI.         Creating a subroutine to populate an O4W Type ahead Listbox]]

[[guides:o4w:oi10:reference_guide:Calling_Forms_Reports_dashboards_and_procedures|Calling Forms, Reports, Dashboards and Procedures]]

[[guides:o4w:oi10:reference_guide:Calling_Forms_Reports_dashboards_and_procedures#Calling_an_O4W_Form|I.       Calling an O4W Form]]

[[guides:o4w:oi10:reference_guide:Calling_Forms_Reports_dashboards_and_procedures#Calling_an_O4W_Report|II.     Calling an O4W Report]]

[[guides:o4w:oi10:reference_guide:Calling_Forms_Reports_dashboards_and_procedures#Calling_an_O4W_dashboard|III.         Calling an O4W Dashboard]]

[[guides:o4w:oi10:reference_guide:Calling_Forms_Reports_dashboards_and_procedures#Calling_an_O4W_procedure|IV.         Calling an O4W Procedure]]

[[guides:o4w:oi10:reference_guide:Building_a_dynamic_table|Building a dynamic table for multivalue handling in an O4W Form]]

[[guides:o4w:oi10:reference_guide:O4W_PayPal_Integration|O4W PayPal Integration..]]

[[guides:o4w:oi10:reference_guide:O4W_PayPal_Integration#Using_PayPal_Buy_Now|I.       Using PayPal “Buy Now”]]

[[guides:o4w:oi10:reference_guide:O4W_PayPal_Integration#Using_PayPal_Add_to_cart|II.     Using PayPal “Add to Cart”]]

[[guides:o4w:oi10:reference_guide:O4W_PayPal_Integration#Using_PayPal_View_cart|III.         Using PayPal “View Cart”]]

[[guides:o4w:oi10:reference_guide:O4W_and_RSS|O4W and RSS]]

[[guides:o4w:oi10:reference_guide:O4W_Password_Encryption|O4W Password Encryption]]

[[guides:o4w:oi10:reference_guide:O4W_Child_Form|O4W Child Form]]

[[guides:o4w:oi10:reference_guide:Browser_Control_for_openinsight|Browser Control for OpenInsight]]

[[guides:o4w:oi10:reference_guide:Configuring_O4W_debug_mode|Configuring O4W to run in debug mode]]

[[guides:o4w:oi10:reference_guide:Configuring_O4W_debug_mode#Setting_up_the_registry|I.       Setting up the registry]]

[[guides:o4w:oi10:reference_guide:Configuring_O4W_debug_mode#Running_the_engineserver_in_manual_debug_mode|II.     Running the engineserver in manual debug mode.]]

[[guides:o4w:oi10:reference_guide:O4W_Configuration|O4W Configuration]]

[[guides:o4w:oi10:reference_guide:O4W_Configuration#SYSENV_Configuration|I.       SYSENV Configuration]]

[[guides:o4w:oi10:reference_guide:O4W_Configuration#O4WCONFIG_configuration|II.     O4WCONFIG Configuration]]

[[guides:o4w:oi10:reference_guide:O4W_Configuration#O4W_and_https|III.         O4W and https]]

[[guides:o4w:oi10:reference_guide:The_Background_Processor|The Background Processor]]

[[guides:o4w:oi10:reference_guide:The_Background_Processor#The_Background_processor|I.       The Background Processor]]

[[guides:o4w:oi10:reference_guide:The_Background_Processor#Configuring_the_background_processor|II.     Configuring the Background Processor]]

[[guides:o4w:oi10:reference_guide:The_Background_Processor#Invoking_the_background_processor_on_an_ad-hoc_basis|III.         Invoking the Background Processor On An Ad-Hoc Basis]]

[[guides:o4w:oi10:reference_guide:The_Background_Processor#Invoking_the_background_processor_via_a_queue_manager|IV.         Invoking the Background Processor Via A Queue Manager]]

[[guides:o4w:oi10:reference_guide:Resetting_Engines|Resetting Engines from the Browser]]

[[guides:o4w:oi10:reference_guide:OECGI4P_PHP|I.       OECGI4P.PHP]]

[[guides:o4w:oi10:reference_guide:http_conf|Apache configuration file (http.conf)]]


{{guides:o4w:oi10:reference_guide:image736.png?325x67}}

 

 

**Revelation Software, Inc**

99 Kinderkamack Road, First Floor

Westwood, NJ 07675

U.S.A

Toll Free: 800-262-4747

Phone: 201-594-1422

Fax: 201-722-9815

www.revelation.com

**Revelation Software Ltd.**

Boundary House

Boston Road

London, W7 2QE

U.K.

Phone: +44 0 208 912 1000

Fax: +44 0 208 912 1001

[[http://www.revsoft.co.uk|www.revsoft.co.uk]]

**BrightIdeas New Zealand**

44 Cockle Bay Road

Howick

Auckland, 2014

New Zealand

Phone: +64 9 534 9134

 

www.revelationsoftware.asia


 
Revelation Software is a division of Revelation Technologies, Inc.

Part No 218-987