Openbravo Issue Tracking System - Openbravo ERP
There are many places where we currently miss this call, meaning the affected numeric filters etc. only work on Oracle but not on Postgres
In addition some old to_number calls are in place for ID fields which are now no longer appropriate as the IDs are alphanumeric.
A code inspection is needed and agreed by Paolo Juvara to proactively find and resolve all of these issues:
Go trough all manual code (.xsql files in src-wad, src-trl and src).
For each
- check each parameter whether it its target (column) is numeric and add to_number
- look at existing occurences of to_number - if these point to an id-field remove it
Please trigger the necessary steps (I understand some of this is already ongoing) and derive sub-issues as you see it as appropriate
Attached is a list of excessive to_number occurrences for ID fields kindly provided by Stefan Hühner. He can also be contacted for further questions
| related to | feature request | 0006698 | closed | shuehner | Partial list of broken/not useful xsql methods which are currently not used | |
| related to | defect | 0006630 | closed | shuehner | OrderLine Selector filter fields: business partner & product are broken when selector is opened with salesOrders only filter | |
| related to | defect | 0006631 | closed | shuehner | Invoice selector: Filter field Order does not work with non numeric-only input | |
| related to | defect | 0006634 | closed | shuehner | Financial Management || Receivables & Payables || Analysis Tools || Cash Report || Cash Report > Cashbook filter is broken | |
| related to | defect | 0006643 | closed | shuehner | Create AP Expense Invoices process does not work correctly when run with newly created user (having non-numeric user_id) | |
| related to | defect | 0006644 | closed | shuehner | Remittance cancellation & Remittance return processes do not work | |
| related to | defect | 0006653 | closed | shuehner | Payment Tracker; Filter fiels Amount From & Amount to do not work on postgresql 8.3 | |
| related to | defect | 0006656 | closed | shuehner | Payment Report: Filter fiels Amount From & Amount to do not work on postgresql 8.3 | |
| related to | defect | 0006660 | closed | shuehner | General Ledger Report, Filter field: From Amount does not work on postgresql 8.3 | |
| related to | defect | 0006662 | closed | shuehner | Order Line selector: Field field "Total Amount From" does not work on postgresql 8.3 | |
| related to | defect | 0006664 | closed | shuehner | Order selector: Field field "Total Amount From" does not work on postgresql 8.3 | |
| related to | defect | 0006688 | closed | AinhoaPagola | Shipment in -> Create From Multiple Popup -> OK, error reporting does not work | |
| related to | defect | 0006690 | closed | shuehner | Warehouse Management || Transactions || Incoming Shipment || Shipment in ->Create From Multiple Popup does not work on pgsql 8.3 | |
| related to | defect | 0006693 | closed | rafaroda | CreateFromMultipleShipment_data.xsql - method insert does not work with uuid |
list.txt (1,911) 2008-10-27 12:28https://issues.openbravo.com/file_download.php?file_id=357&type=bug