Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • 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
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • 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
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
      • Get a Tailored Demo
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +32 2 290 34 90
    • Get a Tailored Demo
  • Pricing
  • Help
  1. APPS
  2. Extra Tools
  3. Execute Query Using AI v 18.0
  4. Sales Conditions FAQ

Execute Query Using AI

by Candidroot Solutions Pvt. Ltd. https://www.candidroot.com/
Odoo

$ 9.99

v 18.0 Third Party
Apps purchases are linked to your Odoo account, please sign in or sign up first.
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 542
Technical Name execute_query_cr
LicenseLGPL-3
Websitehttps://www.candidroot.com/
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 542
Technical Name execute_query_cr
LicenseLGPL-3
Websitehttps://www.candidroot.com/
candidroot-logo
Community Enterprise

Execute Query

You can execute SQL queries for any module using the Execute Query module.

Youtube Video

user-guide Execute Query

01

"Enter your API Key and select an AI Model to generate queries automatically.

Notification of Journal pop-up notification

02

To enable developer mode in Odoo, click on the bug icon (Odoo Debugger) in the top-right corner, or append ?debug=1 to the URL (e.g., https://yourdomain.com/web?debug=1).

Notification of Journal pop-up notification

03

The debugger icon looks like the one shown in the screenshot below

Notification of Journal pop-up notification

04

Click on the debugger icon, then select the Execute Query menu option, as shown in the image below.

Notification of Journal pop-up notification

05

The Execute Query pop-up window will appear, allowing you to enter and run SQL queries.

Notification of Journal pop-up notification

06

Here, we enter a query to fetch all sale orders and click the Execute button. This will display all records from the sale_order table. and also User can generate query using AI.

Notification of Journal pop-up notification

07

As shown in the screenshot below, Change the sale order 'Draft' state in 'Sale' state.

Notification of Journal pop-up notification

Get Help From Us!

Email Need Our Service ? Our Products

Our Services

support
Odoo Implementation
apps
Odoo Customization
support
Odoo Development
apps
Odoo Migration
support
Odoo Integration
apps
Odoo Consulting
support
Odoo Support
apps
Odoo Theme Development
support
Odoo CMS Development
apps
Odoo Ecommerce Development
support
Odoo Mobile App
apps
Odoo Training

Please Follow Us On

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with