| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 375 |
| Technical Name |
query_deluxe |
| License | AGPL-3 |
| Website | https://github.com/YvanDotet/query_deluxe/ |
| Versions | 14.0 13.0 12.0 15.0 17.0 16.0 11.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.
Find examples
Remember useful queries
Get a description of what the query does.
Memorize your own example
Save repetitive query
You can store your own query to re-use it quickly.
Print your result
PDF format
Print your table's result in a PDF format, landscape or portrait orientation.
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.
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 14
Credits
Authors
- Yvan Dotet
Maintainers
- This module is maintained by Yvan Dotet.
Contact
- Mail address of Yvan Dotet : Yvandotet@yahoo.fr
- website :
- https://github.com/YvanDotet/query_deluxe
- https://be.linkedin.com/in/yvan-dotet-19ba67135
Please log in to comment on this module
Report comment
Any abuse of this reporting system will be penalizedGreat App
Great application, just a note that horizontal overflow is still a issue. But the biggest issue is Odoo bugging out whenever you query the following:
SELECT * from ir_ui_view
Re: Great App
Horizontal overflow visible fix
Thank you for your return.
I have tried to reproduce the problem but it seems it is a particular situation (perhaps you work on MacOS).
I have re-published the app in all version where this time I tried to fully overflow visible the table.
Also don't hesitate to click with your mouse on the table, such a way a horizontal scrollbar will be displayed, and show the rest of the table.
Thank you.
Sincerely.
Dotet Yvan.
Resulting Table view doesn't fit into the screen
Hello,
There's a bug in your app. When I am executing the query in your app the resulting table view doesn't fit in the screen as the table contains large number of columns and there's no option for horizontal scrolling to view the columns.
Re: Resulting Table view doesn't fit into the screen
Dear Mr Sedani,
Can you give me the name of the browse you use to work with this module ?
It's work well for chrome and firefox with windows and ubuntu.
Sincerely,
Dotet Yvan.
yvandotet@yahoo.fr
Dear Mr Reinert,
The command
"SELECT * from ir_ui_view"
load a lots of record (2579 rows on my exemple) with many colums (more than 29 columns) and it can take time.
You can load less lines with a limit argument "limit=100" or to select particular fields in the select.
Sincerely,
Dotet Yvan.
yvandotet@yahoo.fr
So good！
Re: So good！
Dear AYSP,
Thanks for your return.
If you have any ideas to improve this app, don't hesitate to ask.
Sincerely,
Dotet Yvan.
Reply to previous comment
US
Re: Reply to previous comment
Dear Mr Sedani,
Yes I will be great if you email me the bug.
Thanks to send the bug at " yvandotet@yahoo.fr ".
I have check that the table in Safari (ios apple) don't show a scrollable bar if the overflow is too big. It only display if the mouse is on over the table.
Thank you.
Sincerely,
Dotet Yvan.
Perfect app for querying a Postgresql database.
Please leave a comment, thank you.
Perfect app for querying an Postgresql database
Perfect app for querying an Postgresql database