View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

DRBP Advices

Pieces of Advice and Tips

First and foremost, the most important advice is to read the Documentation. It is really helpful for solving initial doubts before starting the development, and specific ones while developing some new functionality.

It is also important to check the Release Notes in order to keep updated with the new developments at Openbravo. It is the only way to know which new technologies have been implemented and take advantage of them.

The Documentation in Openbravo is quite extense, so here are some helpful links:

Development Tips

For example, this query:

SELECT COALESCE(Sum(quantity), 0) 
INTO   vresqty 
FROM   m_reservation_stock 
WHERE  releasedqty = 0 
       AND m_reservation_id IN (SELECT m_reservation_id 
                                FROM   m_reservation 
                                WHERE  m_product_id = vmproductid 
                                       AND isactive = 'Y') 
       AND m_locator_id = v_locatorid 
       AND m_attributesetinstance_id = vattributsetinstanceid

Should be like this:

SELECT COALESCE(Sum(quantity), 0) 
INTO   vresqty 
FROM   m_reservation_stock rs
WHERE  releasedqty = 0 
       AND EXISTS (SELECT m_reservation_id 
                   FROM   m_reservation 
                   WHERE  m_reservation_id=rs.m_reservation_id 
                          AND isactive = 'Y'
                          AND m_product_id = vmproductid) 
       AND m_locator_id = v_locatorid 
       AND m_attributesetinstance_id = vattributsetinstanceid

By doing it, performance improves greatly.

VclientID VARCHAR(32):='187D8FC945A5481CB41B3EE767F80DBB'
 
ad_org_id=Vorgid AND name LIKE 'Saleable%'

Retrieved from "http://wiki.openbravo.com/wiki/DRBP_Advices"

This page has been accessed 317 times. This page was last modified on 7 May 2014, at 11:40. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.