Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Note that the feature described in this lesson is current work in progress. Details regarding the future release of this feature will be made public by means of the official Helium Release Notes
As a System Admin I would like to resolve all current service tickets or mark or current service tickets as spam
| Table of Contents |
|---|
Lesson Outcomes
By the end of this lesson you should know how to make use of the sql->execute built-in function to execute non-select queries.
App Use Case Scenario
The support ticket menu item for the System Admin user presents a dat wall of service tickets. Each ticket can be individually resolved or marked as spam. The feature described in this lesson allows the user to resolve all current service tickets or mark all current service tickets as spam. A typical way to achieve this in a DSL presenter is to query the database for service tickets that can be updates and then looping through service ticket one by one to resolve or mark as spam. A much simpler implementation is to make use of a single update query. This is demonstrated in the remainder of this lesson.
New & Modified App Files
Query Execution