Presented at RECONNECT 22
Session ID: 100470
If you're a technical or functional user that is looking to learn some tips and tricks of Query Manager, this session is for you. If you are confident in your ability to write queries to retrieve transactional information about student/employee/vendor/supplier; and are looking for ways to be more sophisticated in your data retrieval, then this is the session is also for you!
We will begin with some basic tips and tricks for query writing, and then move to some more complicated topics, like creating smart prompts, or using expressions wisely. Finally, we discuss some advanced topics such as query administration, using query manager on 4-tier vs using query builder tool within Application Designer, look at the new classic-plus view of query manager and some tips/tricks.
Topics Covered will include:
1. Understanding Joins
2. Manipulating Data with Expressions
3. Aggregating Data
4. Sub Queries
5. Tips and Tricks
6. New Query Technology & Features
7. Query Tool within Application Designer (Tools 8.57)
8. Query Administration