PostgreSQL Query Deluxe

by
Odoo
v 14.0 Third Party 474
Download for v 14.0 Deploy on Odoo.sh
Lines of code 371
Technical Name query_deluxe
LicenseAGPL-3
Websitehttps://github.com/YvanDotet/
Also available in version v 12.0 v 11.0 v 13.0
You bought this module and need support? Click here!
Lines of code 371
Technical Name query_deluxe
LicenseAGPL-3
Websitehttps://github.com/YvanDotet/
Also available in version v 12.0 v 11.0 v 13.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 :
    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.
Horizontal overflow visible fix
by
Yvan Dotet
on 11/28/20, 6:08 PM Author

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
by
Utsav Sedani
on 11/19/20, 12:16 AM

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
by
Yvan Dotet
on 11/19/20, 12:51 PM Author

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


So good!
by
AYSP
on 12/11/20, 5:17 AM


Re: So good!
by
Yvan Dotet
on 12/11/20, 3:18 PM Author

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
by
Utsav Sedani
on 11/19/20, 11:31 PM

Dear Yvan,

I have tested in chrome browser as well as Firefox, I can share the screenshot in your mail if you want.

Otherwise the module is perfect.

Thanks and Regards, 

US

Re: Reply to previous comment
by
Yvan Dotet
on 11/20/20, 4:06 PM Author

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.
by
Yvan Dotet
on 11/17/20, 7:04 PM Author

Please leave a comment, thank you.


Perfect app for querying an Postgresql database
by
Yvan Dotet
on 11/17/20, 7:01 PM Author

Perfect app for querying an Postgresql database