Skip to Content

PostgreSQL Query Deluxe

by
Odoo
v 17.0 Third Party 8763
Download for v 17.0 Deploy on Odoo.sh
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Lines of code 371
Technical Name query_deluxe
LicenseAGPL-3
Websitehttps://github.com/YvanDotet/query_deluxe/
Versions 11.0 12.0 13.0 14.0 15.0 16.0 17.0 18.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Lines of code 371
Technical Name query_deluxe
LicenseAGPL-3
Websitehttps://github.com/YvanDotet/query_deluxe/
Versions 11.0 12.0 13.0 14.0 15.0 16.0 17.0 18.0

The complete app for making easy queries in PostgreSQL

Explore your PostgreSQL database with query into an Odoo interface
You can use SELECT, UPDATE, DELETE, CREATE, INSERT, ALTER and DROP statements.

Note to remember what the query does

What it does, why doing this, the dangers, etc...

Print your result

PDF format

Print your table's result in a PDF format, landscape or portrait orientation.

Many examples

The module is pre-filled by useful queries.

You can modify them and used them for inspiration.

History

History of your previous queries

You can retrieve the last queries you have typed.

query_deluxe

This module is usefull to make postgreSQL's queries directly from an Odoo interface.

You can type queries involving SELECT statement and many clauses like WHERE, AND, etc ...

The result is correctly presented in a table form and you can print your table's result in a PDF format.

You can also make UPDATE, DELETE, CREATE, INSERT, ALTER and DROP statements.

Usage

Go to "Apps" menu and type "query_deluxe" into the search box.

Odoo version 17

Credits

Authors

  • Yvan Dotet

Maintainers

  • This module is maintained by Yvan Dotet.

Contact

  • Mail address of Yvan Dotet : Yvandotet@yahoo.fr
  • website :
    1. https://github.com/YvanDotet/query_deluxe
    2. https://be.linkedin.com/in/yvan-dotet-19ba67135

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, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.
Highly useful tool
by
Robson Netto
on 5/23/25, 9:49 AM

Hi Yvan,

Besides the pdf print feature, are there any planning to include an .csv export feature for the 17 version?


Thanks!

by
Robson Netto
on 3/26/25, 4:17 PM

Hi Yvan. Good job with this app. After installed and available for all odoo employees, users with any permission level can access Query Deluxe and perform transactional operations, including UPDATE and DELETE?

Re:
by
Yvan Dotet
on 3/30/25, 5:09 PM Author

Dear Robson Netto ,


when the app is installed only the users on the admin's group (group_system) and the manager erp's group (group_erp_manager) can access to the application to perform SQL statements.


On the other hand if you decide to manually add odoo's employees inside that groups later they will also be able to see the application.


Thank you for your comment.

Don't hesitate to ask any more questions.


Sincerely,

Yvan.

Link not found
by
Peter Yulius
on 11/18/23, 9:59 AM

link  https://apps.odoo.com/apps/modules/17.0/report_xlsx is not found.

Re: Link not found
by
Yvan Dotet
on 11/26/23, 4:53 PM Author

Dear Mr Peter Yulius, 

The printing in xlsx file will be fixed soon.

Thank you.

Sincerely.

Yvan.