-
DSP App Dev Overview
- Add a Check Box
- Add a Control Type to a Column
- Add a Filtered Combo Box
- Add a Label
- Add a Link to the Site Menu
- Add a List Selection Field
- Add a Menu to the Navigation Pane
- Add a Tab
- Add a Tooltip
- Add a Watermark
- Add an HTML Area to a Column
- Add Binding Criteria when Linking to a Page
- Add Column Help Text
- Add Columns to a Report for a Report Group
- Add Dynamic Help to a Page
- Add Layouts
- Add List Boxes and Combo Boxes
- Add Pages to the *Navigation* Pane
- Add Reserved Columns to Tables
- Append BOA Reserved Columns to Tables
- Assign Column Properties
- Assign Page Properties to a Dynamic Page
- Business Rule Guidelines
- Business Rules
- Column Encryption
- Configure boaReport Reserved Column
- Configure Report Generation for Linked Pages
- Configure the Navigation Pane, Submenus and Links to Pages
- Consolidation
- Control Status Fields
- Control Status Manipulation Overhead Minimization
- Control Views
- Copy a Layout
- Copy a Page in a WebApp
- Create a Chart Page
- Create a Combination Chart
- Create a Dashboard Page
- Create a Dynamic Page
- Create a Header Detail Page
- Create a Service Page
- Create a Static Page
- Create a Stored Procedure Business Rule
- Create a WebApp
- Create a WebApp Event (Private) Business Rule
- Create a WebApp Event Business Rule
- Create a WebApp in DSP®
- Create a Workflow
- Create an External Page Business Rule
- Create Chart Drill Down
- Create Dashboards and Charts
- Create Events
- Create Report Groups
- Create Report Pages
- Create Report Views
- Create Reports
- Create Tables in SQL
- Create Views in SQL
- Creating a Security View Guidelines
- Customize Dashboard Pages
- Data Control Views
- Database Design
- Decrypt Data
- Drop Audit Tables
- Dynamic Views for Multiple Control Fields
- Effectively Implementing Security Definitions (Role Security)
- Enable Audit Trail and Electronic Signature
- Enable Audit Trail on a Page
- Enable Dynamic Image
- Enable Dynamic Page Reporting
- Enable Electronic Signature
- Enable File Upload and Download
- Enable List Allow Insert
- Enable List Unique
- Enable List Where Clause
- Enable Show in Navigation
- Encrypt a Column
- Event Design Process
- Execute a Boomi Process From a Custom Page
- Guidelines for Horizontal Page Views
- Guidelines for the Navigation Pane
- Guidelines for Vertical Page Views
- Hide a Column from Download
- Hide a Page Column on a Report
- Horizontal vs. Vertical Views
- Improve Page Load Performance Related to List Boxes
- Include all Page Details in Reports
- Link to a Page Using Buttons and Images
- Link to a Report from a Page
- Link to Report Pages
- Modify a Chart
- Modify Chart Properties
- Naming Conventions and the Enforce Strict Naming Feature
- OnLoad Events
- OnValidate Events
- Page Control View
- Page Design Guidelines
- Page Design Overview
- Partition Logic Semantically
- Precedence
- Register the Database for a Custom WebApp
- Review Dashboard Customization Settings For a User
- Set a Column's Format
- Set a Dynamic List Box
- Set a Parameter Value for Business Rule Parameters for a Public WebApp Event
- Set Column Control Status
- Set Default Field Value for a Column
- Set Parameters for a Public WebApp Event
- Set Required Fields
- Set Security for a Custom WebApp
- Set Spanning Properties
- Set the List Order By
- Set the X-axis of a Chart with the Category Column Property
- Set the Y-axis of a Chart with the Value Column Property
- Simplification
- SQL View/Function/Procedure Design
- Table Naming Conventions
- Troubleshoot Report Issues
- Use boaStatus to Set a Toolbar Button's Control Status
- Use View Types with Column Properties
- User Control Views
- Validation Rules
- View and Stored Procedure Naming Conventions
- View Controls and Control Formats
- View Dynamic Page Reports
- View Report Pages
- View the Controls Available For A Page Type
- WebApp Group Design
- WebApp Layout
- When to use Value Columns Instead of a Secondary Column
- Solutions
- Platform
- WebApp_Dev
- SQL View/Function/Procedure Design
SQL View/Function/Procedure Design
Non-schema object design is the next most important thing above table design when creating a WebApp. When lightweight and efficient, even complex functions, views, and procedures can be implemented with little overhead.
NOTE: Avoid Global Operators. Any SQL procedures or functions that have to enumerate or parse full sets of table data are dangerous due to their inability to scale efficiently.
This section contains these topics:
Was this article helpful?
Sorry about that.
Why wasn't this helpful? (check all that apply)
Thanks for your feedback.
Want to tell us more?
Send an email to our authors to leave your feedback.
Great!
Thanks for your feedback.