Interactive Grid API Essentials: The Stuff You'll Really Use

Session Number: 8181
Track: Application Express
Sub-Categorization: APEX Core
Session Type: Best Practices
Primary Presenter: Karen Cannell [Director - TH Technology]
Time: Jun 26, 2019 (11:45 AM - 12:45 PM)
Room: 613/614, Level 6

Speaker Bio: Karen Cannell is president of TH Technology, a consulting firm providing Oracle technology services. A mechanical engineer by degree, she has analyzed, designed, developed, converted, upgraded, enhanced, and otherwise implemented legacy and commercial database applications for over 30 years, concentrating on Oracle technologies. She has worked with Application Express since its beginnings and continues to leverage the Oracle suite of tools to build quality web applications for clients in government, health care, and engineering industries. Karen is an ODTUG Board Member; an Oracle ACE; editor emeritus of the ODTUG Technical Journal; an Oracle Developer's Choice finalist; an ODTUG Volunteer of the Year; and co-author of Expert Oracle Application Express, Agile Oracle Application Express, and Beginning Oracle Application Express 4.2. Karen is an active member of ODTUG, IOUG, RMOUG, and NOUG. She can be contacted at
Technologies or Products Used: APEX, Documented APEX JvaScript APIs

Session Summary for Attendees:  Learn the essentials of the APEX 18 JavaScript APIs for interactive grids. Do you need to add complex validations, dynamic actions, and/or implement interactive grid customizations? The grid and interactive grid APIs are your friends. This session covers the essential elements of the documented APEX JavaScript APIs that most interactive grid developers need to know (make that *should* know) to build effective, customized interactive grids.

We will detail and demonstrate the most commonly used parts of the JS APIs that pertain to interactive grids, with simple examples so attendees can absorb the basics and understand how to adapt to their own requirements. Topics include the grid widget in general, how to access and process data in the model, and how to tie these concepts into dynamic actions, validations, and custom processes. The session will emphasize basics and best practices using the APIs where needed to achieve business requirements. PL/SQL developers looking to become more comfortable with JavaScript grid customizations will feel right at home. Gain the knowledge you need to adapt interactive grids to meet end user specifications.