SugarClub
Search
User
Site
Search
User
Groups & Discussions
Groups & Discussions
Product Forums
Product-focused Q&A, discussions, best practices, fixes, and help
Product Forums
Sugar Market
Sugar Sell & Enterprise
Sugar Serve
sales-i
User Groups
Professional, Industry, Language
Get Involved
Learn how to become a Raving Fan
Social Club
Live, interactive, virtual meetups with other Sugar customers and Sugar’s Subject Matter experts!
Leadership Lounge
Network with fellow organizational leaders, ask questions, and share insights
Developers
Visit DevClub, the SugarClub group for Sugar Developers
Developers
DevClub
Mobile Developers
Developer Builds
Supplemental access level required. Inquiries: developers@sugarcrm.com
Additional Groups (Access Required)
Groups that require special access will be displayed here. Contact sugarclub@sugarcrm.com for assistance. Click here to see all groups
Additional Groups (Access Required)
SugarCloud Platform
Product Information
Product Information
Release Central
Find release-specific content to prepare for your next Sugar update
Documentation & Resources
Looking to expand your Sugar knowledge? Explore our in-depth documentation and other helpful resources!
Product Update Blogs
Updates about each Sugar product
Customer Stories »
Case Studies by SugarCRM
Training & Certification
Training & Certification
Training & Certification Home
Live & On-Demand classes, Quick Videos, Sugar Certifications, and more!
Quick Videos
Short videos about using Sugar
My SugarU Dashboard »
SugarU News & Updates
Adoption
Adoption
Grow Adoption Framework
Get started on your adoption journey and review the adoption resources from SugarCRM
Calendar
News
News
Sugar News
SugarCRM.com News »
Dev Blog
SugarOutfitters Blog
Help
Help
Welcome to Sugar!
New to Sugar? Get started here!
SugarClub Help & Instructions
Learn more about SugarClub and find answers to questions about this site
New to SugarClub?
Start your community journey here
Technical Support
Sugar's support resources
Technical Support
Case Portal »
Access the SugarCRM Case Portal
Working with Sugar Support »
Find out more about engaging with the SugarCRM Support team
SugarCloud Information
Find information about SugarCloud service updates and site status. Contact sugarclub@sugarcrm.com to request access
More from Sugar
More from Sugar
DevClub
PartnerClub
Support
SugarOutfitters Marketplace
sugarcrm.com
DevClub
PartnerClub
Support
SugarOutfitters Marketplace
sugarcrm.com
DevClub
Dev Answers & Best Practices
Click here to join this group and curate your SugarClub experience.
All tags
database
Logic Hooks
calculated value
Sugar 6.x
How to query db and sum the rows returned
Dan A
Hello, I have a need to query the DB for all products sold to a client then get the total. This then needs to be displayed in a field. I am using SugarCRM CE 6.5.13 I would greatly appreciate any assistance. Thanks.
Answered
over 9 years ago
DevClub
Dev Answers & Best Practices
