SQL queries in odoo email template | Odoo

Apps
Finance

Accounting

Invoicing

Expenses

Spreadsheet (BI)

Documents

Sign
Sales

CRM

Sales

POS Shop

POS Restaurant

Subscriptions

Rental
Websites

Website Builder

eCommerce

Blog

Forum

Live Chat

eLearning
Supply Chain

Inventory

Manufacturing

PLM

Purchase

Maintenance

Quality
Human Resources

Employees

Recruitment

Time Off

Appraisals

Referrals

Fleet
Marketing

Social Marketing

Email Marketing

SMS Marketing

Events

Marketing Automation

Surveys
Services

Project

Timesheets

Field Service

Helpdesk

Planning

Appointments
Productivity

Discuss

Approvals

IoT

VoIP

Knowledge

WhatsApp
Third party apps Odoo Studio Odoo Cloud Platform
Industries
Services

Audit & Certification

Bike Leasing

Billboard Rental

Cleaning Services

Environmental Agency

Estate Management

Hair Salon

Handyman

IT Hardware and Support

Law firm

Marketing Agency

Odoo Partner

Photography

Property Owner Association

Shoe Maker

Software Reseller

Talent Acquisition

Retail

Agriculture Store

Arts & Crafts

Bakery

Book Store

Cake Store

Clothing Store

Electronics Store

Furniture Store

Grocery Store

Hardware Store

Toy Store
Construction

Architecture Firm

Construction

Gardening

Solar Energy

Supply Chain

Beverage Distributor

Corporate Gifts

Custom Furniture Production

Fossil Fuel Trading

Micro Brewery

Health & Fitness

Eyewear Store

Fitness Center

Pharmacy

Sports Club

Wellness Practitioners

Hospitality

Bar and Pub

Fast Food

Fine Dining Restaurant
...and many more!
Browse all Industries
Community
Learn

Tutorials

Documentation

Certifications

Training

Podcast

Empower Education

Education Program

Scale Up! Business Game

Visit Odoo
Get the Software

Download

Compare Editions

Releases
Collaborate

Github

Forum

Events

Translations

Become a Partner

Register your Accounting Firm
Get Services

Find a Partner

Find an Accountant

Meet an advisor

Customer References

Implementation Services

Development Services

Support

Upgrades
Github Youtube Twitter Linkedin Instagram Facebook Spotify

+1 (650) 691-3277
Get a demo
Pricing
Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Accounting
Inventory
PoS
Project
MRP

All apps

All Posts People Badges

Tags (View all)

odoo accounting v14 pos v15

About this forum

SQL queries in odoo email template

qweb email template sql jinja2

3263 Views

Can we write a sql statements using jinja2 or qweb inside the body of email template. In other words my clients need to receive a reguler mails from odoo summrize them business is doning well or not like an weekly email explain the number of sales, topten selling products, ...etc

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up

Related Posts		Replies	Views	Activity
Escape object.values in html of an email in the editor QWeb Template Odoo V16 qweb email template phone odoo16features		0 Apr 23	1700
Add company logo to template email, odoo 15 email template		2 Jan 24	4242
Problem with email template (SOLVED) Solved email template		2 Jan 24	9914
How to use IF ELSE (conditional clause) in email template email template		1 Mar 21	9468
Permissions for using Email Template to send quotation email template		0 Jan 19	7061