ClassRoom
Help for Query Builder

The USER DEFINED QUERY is a powerful yet easy to use tool which helps the user retrieve information from the entire database in any desired format or manner. The user can create specific templates for analysis or reports and save them in an easy to understand manner. Once saved, these reports can be generated on any company, business group, industry, product, raw material or user sets as and when required. This HELP ON QUERY would explain the procedure for creating queries by defining columns and setting conditions.
 
INTRODUCTION
BUILDING SIMPLE QUERY
CREATING REPORTS BASED ON CONDITIONS
CREATING CUSTOM MADE FIELDS
APPLYING SORT CONDITION
APPLYING AGGREGATE FUNCTION
TERMINOLOGY