View More
View Less
System Message
An unknown error has occurred and your request could not be completed. Please contact support.
Wait Listed
Personal Calendar
Conference Event
There aren't any available sessions at this time.
Conflict Found
This session is already scheduled at another time. Would you like to...
Please enter a maximum of {0} characters.
{0} remaining of {1} character maximum.
Please enter a maximum of {0} words.
{0} remaining of {1} word maximum.
must be 50 characters or less.
must be 40 characters or less.
Session Summary
We were unable to load the map image.
This has not yet been assigned to a map.
Search Catalog
Replies ()
New Post
Microblog Thread
Post Reply
Your session timed out.
This web page is not optimized for viewing on a mobile device. Visit this site in a desktop browser to access the full set of features.
Insights 2019

302889 - EECX36: Epicor ERP Advanced Business Queries (Session Also Held on Monday at 8:00 am)

Session Description

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:

  • System Administrator
  • IT/Technical Staff

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


Additional Information
Extended Education
4 Hours
Session Schedule