JasperSoft Studio 6.0.1 Parameters SQL syntax
To add string parameter in our report : String Parameter $P{P1} To add list parameter : $X{IN,sql_column_name,P1}
Edit PDF header – Odoo 11
Edit the format of the address By default with the localization i set for my company, addresses are displayed like this picture bellow: First, you need to enable developper mode through settings, and go to the menu contact -> Configuration -> localization -> countries. Select the country you set on your company settings and click edit. Edit and change the format as your convenience. And here the result. Edit the format of header/footer Settings are available through the menu: Settings -> General settings -> Document template section: You will be able to customize logo, text position here, click edit …
Odoo dashboard mobile
Odoo dashboard is a simple app that displays predefined widgets set on Odoo server, this app requires an additional module available on Odoo store. – Create, rename, delete, reorder and reload dashboards.– Add, remove, reorder and reload widgets from dashboard.– Fast loading, data is retrieved by the server and cached. Odoo Dashboard Widgets – WidgetXVsY: displays 2 numbers, difference and variation is calculated.– WidgetLastX: it could be used to displays x last months orders / invoices, etc…– WidgetSingleX: displays a relevant numbers Odoo server module Odoo dashboard Remote database access Connect to remote databases (MSSQL, local postgreSQL, MySQL not implemented yet) …
Odoo – Redirect user to a page in python
This code bellow will redirect the user to customer invoice page, you will be able to set the model you would like to use with res_model and the id of the record in res_id, the view template in views, target can have new or self value. new value will open a popup and display the requested page, self will load the page in the current window.
How to protect Odoo against brute force attack behind Nginx or Caddy
Odoo community is not protected against brute force attack by default, the system is vulnerable over internet, however Odoo store provides auth_brute_force App which can handle this task, it’s available through this link. But it doesn’t work correctly behind a reverse proxy such as Caddy or Nginx. In the second part of this post, i’ll explain the little tip to make it work. Download and install the module Download the file corresponding to your version of Odoo. Unzip the file “auth_brute_force-9.0.1.1.0.zip”. Move the folder “auth_brute_force” to your module folder: “/usr/lib/python2.7/dist-packages/openerp/addons/“. Enable the developper mode through “About” popup. Then go to …
