View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000272 | NOALYSS | Bug | public | 2011-05-26 23:47 | 2011-05-27 22:29 |
| Reporter | danydb | Assigned To | danydb | ||
| Priority | élevée | Severity | mineur | Reproducibility | toujours |
| Status | fermé | Resolution | corrigé | ||
| Product Version | 5.6 | ||||
| Target Version | 5.6 | Fixed in Version | 5.6 | ||
| Summary | 0000272: Historique : tri des dates | ||||
| Description | Dans les historiques, quand on essaie de trier par date, plus rien ne s'affiche | ||||
| Tags | No tags attached. | ||||
| Extension Noalyss | |||||
|
|
Exception: SQL ERROR select jr_id , jr_montant, substr(jr_comment,1,60) as jr_comment, to_char(jr_ech,'DD.MM.YYYY') as jr_ech, to_char(jr_date,'DD.MM.YYYY') as jr_date, jr_date as jr_date_order, jr_grpt_id, jr_rapt, jr_internal, jrn_def_id, jrn_def_name, jrn_def_ech, jrn_def_type, jr_valid, jr_tech_per, jr_pj_name, p_closed, jr_pj_number, n_text from jrn 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 (1,2,3,4,5,8,9,11,12,13,14,-1) and jr_date >= to_date('01.01.2011','DD.MM.YYYY') and jr_date <= to_date('31.01.2011','DD.MM.YYYY') order by jr_date_order desc,substring(jr_pj_number,\'\\d+$\')::numeric desc LIMIT 50 OFFSET 0 in /home/dany/phpcompta/rel560/include/class_database.php on line 138 |
|
|
Bug dernière minute |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2011-05-26 23:47 | danydb | New Issue | |
| 2011-05-27 19:01 | danydb | Note Added: 0000461 | |
| 2011-05-27 22:08 | danydb | Status | new => resolved |
| 2011-05-27 22:08 | danydb | Fixed in Version | => 5.6 |
| 2011-05-27 22:08 | danydb | Resolution | open => fixed |
| 2011-05-27 22:08 | danydb | Assigned To | => danydb |
| 2011-05-27 22:29 | danydb | Note Added: 0000462 | |
| 2011-05-27 22:29 | danydb | Status | resolved => closed |
