COST: There is an additional $275 fee to attend this session.
The Advanced Queries class covers functionality a step above the basics of building a simple queries in Epicor. Topics included are the Intercept and Except queries that can be used to determine differences between 2 sets of data. The class also goes beyond using subqueries for aggregation and shows how to use subqueries for record selection. Aggregating data into row and column matrices is explored using the PIVOT functionality in BAQs. Using queries to display hierarchical data is covered using the Common Table Expression (CTE) and recursion. Finally functionality that allows looking at data in databases outside Epicor while within Epicor is explored in an External Business Activity Query section. The course is designed for those with some Epicor BAQ familiarity that want to take that knowledge to the next level.
OBJECTIVES: Upon successful completion of this session, you will be able to:
Create an except business activity query
Create an intercept business activity query
Create subqueries for selecting records
Understand how to use PIVOT table functionality in BAQs
Use the Common Table Expression to display hierarchal data
Use Table Valued Functions
Create an external business activity query to reference non Epicor data
AUDIENCE: This session will appeal to the following audience:
PREREQUISITES: Required Courses: Navigation, Business Activity Queries (BAQs)
APPLICABLE PRODUCTS: This session will be of benefit to customers running Epicor 10.x
PROGRAM LEVEL: Intermediate
FIELD OF STUDY: Computer Science
CPE CREDITS: 4.0