Dolibarr ERP & CRM » Bugs » bug #1687 The ref filter searches on ref and rowid in supplier invoices listLatest modifications
Answer now
Snapshot| Details |
| Submitted by: | Raphaël Doursenaud (rdoursenaud) | | Submitted on: | 2014-11-17 20:27 |
| Last Modified On: | 2014-11-24 11:30 | |
| Summary: | The ref filter searches on ref and rowid in supplier invoices list |
| Description: | http://***/fourn/facture/list.php
This can be potentially confusing for the user. The filter should only apply to the reference value. |
| Step to reproduce bug: | |
| Detected in version: | 3.7.0 | | Category: | Module: Supplier Invoice |
| Severity: | 5 - Major | | OS Type/Version: | |
| PHP version: | | | Database type and version: | |
| Status |
| Status: | Closed | | Assigned to: | Laurent Destailleur (eldy) |
| Resolution: | Fixed | |
Comments- Laurent Destailleur 2014-12-23 13:22
- In previous version, ref for supplier did not exists. It was the id.
So when searching onto a ref, we add to search into id.
This is kept because user may have very old record with no ref filled.
I introduced this into migration script so i was able to remove the backward compatibility hack.
UPDATE llx_facture_fourn SET ref = rowid WHERE ref IS NULL or ref = '';
- Marcos García 2014-11-23 13:34
- In the code there is a comment:
// For backward compatibility
I think Laurent should clarify this.
|
|
So when searching onto a ref, we add to search into id.
This is kept because user may have very old record with no ref filled.
I introduced this into migration script so i was able to remove the backward compatibility hack.
UPDATE llx_facture_fourn SET ref = rowid WHERE ref IS NULL or ref = '';
develop→ 3.7.0Open→ ClosedNone→ Laurent Destailleur (eldy)None→ Fixed