• Home
  • Home
home/Knowledge Base/QC User Manual/Add New Query
Popular Search:Getting Started

Add New Query

2 views 0 June 27, 2021 kbadmin

The Add New Query option enables you to create new Query Designer records in the database. Perform the following procedure to create a new Query record:

  1. Click button.

The Query Designer – Add page is displayed.

  1. Enter the name of the query in the Query Name
  2. Enter the description in the Query Description
  3. Click the required object in the Select an object field. The fields are refreshed according to the selected Object.
  4. Select the check box adjacent to the required fields under the Select the fields The Query Expression section is displayed.
  5. Populate the Output, Field, Alias, Sort Type, Expression, Criteria, ., Or.., and Or.. condition fields.

The Query field is auto-populated with the conditions that are selected so far. You can also update the query as required.

  1. Enter the parameters.
  2. The Owner field is auto populated with the name of the user who has created this record.
  3. Click button to save the Query information.

The details are saved and the query is displayed in the Query Designer page.

Was this helpful?

Yes  No
Related Articles
  • Payee Other information
  • Access Sales by Customer Job – Transaction Summary
  • Sales by Customer Job – Transaction Summary
  • Access Sales by Customer – Transaction Detail
  • Sales by Customer – Transaction Detail
  • Access Payees Incentive Commissions Report by Manager
Leave A Comment Cancel reply

Cloud Tags
Download Information Master Data Products
QC User Manual
  • Add New Query
  • Payee Other information
  • Access Sales by Customer Job – Transaction Summary
  • Sales by Customer Job – Transaction Summary
  • Access Sales by Customer – Transaction Detail
  • Sales by Customer – Transaction Detail
View All 864  
Popular Articles
  • post – with header image
  • Where do i post support query?
  • post – article feedback
  • post – related articles
  • Introduction
KB Categories
  • Billing
  • General Theme Questions
  • QC User Manual
About QCommission

QCommission is a powerful, flexible sales commission software. It calculates your sales people’s compensation accurately and reduces errors.

Support Links
  • FAQ
  • Forums
  • KnowledgeBase
  • Documentation
Useful Help Links
  • Community Home
  • Item support
  • Refunds
  • Market API
Frequent Visit Links
  • Licenses
  • Terms
  • Refunds
  • Privacy Policy
  • Privacy Policy
  • Terms of Use
  • Copyright @ 2021 CellarStone Inc. All Rights Reserved.

Popular Search:Getting Started