Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0029237 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| defect | [Openbravo ERP] 07. Sales management | minor | have not tried | 2015-03-11 10:45 | 2017-05-29 13:45 | |||||||
| Reporter | AugustoMauch | View Status | public | |||||||||
| Assigned To | Triage Omni OMS | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| Review Assigned To | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0029237: Can't filter by Affinity or Matched Document on Match Statement P&E Window | |||||||||||
| Description | The following error is shown when the user tries to filter the Match Statement P&E using the Affinity column: 3227068 [http-8080-1] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: no existe la columna «affinity» Position: 3633 3227068 [http-8080-1] ERROR org.openbravo.service.datasource.DataSourceServlet - could not execute query org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.doList(Loader.java:2536) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) at org.hibernate.loader.Loader.list(Loader.java:2271) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) at org.openbravo.service.datasource.HQLDataSourceService.getData(HQLDataSourceService.java:179) Probably it majes no sense to use that column to filter, it either should be disabled or ignored, but it should not throw an exception. When the user tries to use the Matched Document column to filter the Match Statement P&E no error is shown in the console, but no results are returned | |||||||||||
| Steps To Reproduce | As F&B Admin: - Open Financial Account - Select the Cuenta de Banco account. - Click on the Matched Statement button. If there are no records you might need to reactivate the last transaction - Try to filter using the Affinity or the Matched Document column, it will not work properly | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-03-11 10:45 | AugustoMauch | New Issue | |
| 2015-03-11 10:45 | AugustoMauch | Assigned To | => Sandrahuguet |
| 2015-03-11 10:45 | AugustoMauch | Modules | => Core |
| 2015-03-11 10:45 | AugustoMauch | Triggers an Emergency Pack | => No |
| 2015-03-11 10:48 | AugustoMauch | Relationship added | related to 0029235 |
| 2015-03-11 10:54 | AugustoMauch | Relationship added | related to 0029239 |
| 2017-05-29 13:45 | Sandrahuguet | Assigned To | Sandrahuguet => Triage Finance |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |