View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000855 | NOALYSS | Bug | public | 2013-06-07 00:36 | 2013-11-10 22:56 |
| Reporter | danydb | Assigned To | danydb | ||
| Priority | normale | Severity | mineur | Reproducibility | toujours |
| Status | fermé | Resolution | corrigé | ||
| Product Version | 6.6 | ||||
| Target Version | 6.6 | Fixed in Version | 6.6 | ||
| Summary | 0000855: Ordre des pièces justificatives | ||||
| Description | Le tri dans l'historique grâce à l'ordre des pièces justificatives est correct avec postgresql dans la version 8.4 & 9.0 mais pas dans la version 9.1 | ||||
| Steps To Reproduce | Tester si en remplaçant \\\\d par substring(jr_pj_number,'[0-9]+$') convient à toutes les versions de postgresql select substring(jr_pj_number,'[0-9]+$') from jrn as X left join jrn_note using(jr_id) join jrn_def on jrn_def_id=jr_def_id join parm_periode on p_id=jr_tech_per where jrn_def_id in (3) and jr_date >= to_date('01.01.2012','DD.MM.YYYY') and jr_date <= to_date('31.12.2012','DD.MM.YYYY') order by substring(jr_pj_number,'[0-9]+$')::numeric asc | ||||
| Tags | No tags attached. | ||||
| Extension Noalyss | |||||
|
|
Fichiers à changer ====================== class_acc_account_ledger.php class_acc_ledger.php class_fiche.php export_histo_csv.php ext/tools/include/tool_function.php ext/tools/include/operation.inc.php |
|
|
publié 9/6/13 |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2013-06-07 00:36 | danydb | New Issue | |
| 2013-06-07 00:38 | danydb | Note Added: 0001919 | |
| 2013-06-09 19:47 | danydb | Source_changeset_attached | => PhpCompta Plugin WebSVN rel660 r515 |
| 2013-06-09 19:48 | danydb | Source_changeset_attached | => PhpCompta WebSVN phpcompta r5321 |
| 2013-06-09 19:49 | danydb | Status | new => resolved |
| 2013-06-09 19:49 | danydb | Fixed in Version | => 6.6 |
| 2013-06-09 19:49 | danydb | Resolution | open => fixed |
| 2013-06-09 19:49 | danydb | Assigned To | => danydb |
| 2013-06-09 19:53 | danydb | Note Added: 0001921 | |
| 2013-06-09 19:53 | danydb | Status | resolved => closed |
| 2013-06-10 20:02 | danydb | Source_changeset_attached | => PhpCompta WebSVN phpcompta r5323 |
| 2013-10-29 14:19 | danydb | Source_changeset_attached | => PhpCompta Plugin WebSVN /trunk r524 |
| 2013-11-10 22:56 | danydb | Source_changeset_attached | => PhpCompta WebSVN phpcompta r5321 |
| 2013-11-10 22:56 | danydb | Source_changeset_attached | => PhpCompta WebSVN phpcompta r5323 |
