Skip to Content

Data Query and Export

by
Odoo
v 16.0 Third Party 129
Download for v 16.0 Deploy on Odoo.sh
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 139
Technical Name data_query_export
LicenseAGPL-3
Websitehttps://github.com/ShahAlamSumon
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 139
Technical Name data_query_export
LicenseAGPL-3
Websitehttps://github.com/ShahAlamSumon

Data Query and Excel Export

Overview

Sometime it's very difficult to access database directly. With this module user can access database directly and run query. After query user can export data in Excel. User need to write appropriate SQL like, select/update/delete method. And this will impact to database directly. If there any error in query then error message show with hint.

Export Menu!

User need to go Settings>Technical menu. Then need to go 'Data Export' menu under 'Database Structure' section. Here User will get new screen of query.

Run SQL and Show Result

User can run query and can see the result with 'Show' button. Here user can run select/delete/update methods. Any aggregate function can run from here. Also any SQL functionality can run from here.

Excel Export!

User can generate data in excel file with 'Export' button. Then need to click on export file to download the file.

Here is the example of the Excel. This excel file format is .xls. This can be access able from Widows, Ubuntu or Mac.

Error Message With Hint!

If there any error in the query then there error message will show with hint.

Reload!

User can refresh the page with 'Reload' button. After reload this user can write new query and get new result.

Contact us

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.
Helpful for finding data
by
Niazi Mahrab
on 8/29/23, 4:20 AM

Thanks Shah Alam Sumon. Nice work

There are no comments yet!