Remote Training: Roxie ECL (Part 2) - Complex Query Development
The class will be held remotely via Microsoft Teams. Your instructor will contact you before the class with login information.
NOTE: RELX and LexisNexis employees should register using your work email address and the approved promo code provided by their manager or contact training@hpccsystems.com.
Learn how to optimize and organize your Roxie queries for optimal performance. This class reviews and recommends best practices used in Roxie development, including INTERFACE, Half Keyed JOINS, LIMIT, superkeys, and package maps.
Note: This course is the second in a two-part Roxie series. People who attend the Roxie ECL (Part 1) – Indexes and Queries class should continue with this class. Both classes are presented in the same week.
Course Length: 2 days
Class Prerequisites: Students must have attended the Advanced ECL (Part 2) – Super files, Working with XML, and Free-form Text Parsing, and the Roxie ECL (Part 1) – Indexes and Queries training classes. Students are welcome to bring their own laptops to take away the code and examples from the class.
Topics include:
- • Using INTERFACE structures with Roxie queries
- • Limiting your Roxie results (LIMIT, JOIN, CHOOSEN)
- • Designing queries using multiple datasets
- • Case insensitive searches
- • Use of Superkeys in Roxie queries
- • Use of package maps for Query organization
- • Roxie-specific functions (PRELOAD, ALLNODES, etc.)
- • Roxie Post filtering
Class will begin at 9am and conclude at 4:30pm. Breaks will be provided throughout the day for lunch and lab assignments. Your instructor will provide more information before the class begins.