Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0033112
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminoralways2016-06-02 13:212016-08-01 18:06
ReporterJONHMView Statuspublic 
Assigned Tocaristu 
PrioritynormalResolutionno change requiredFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tocaristu
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0033112: Filters not shown on a Query Only window when setting an HQL filter clause

DescriptionHaving a Query Only window based on AD_Audit_Trail_V table, the filters are not applied if is set an HQL filter clause, however, if we clear filters (by clicking the funnel icon), everything works correctly
Steps To Reproduce*** Setting the environment
1) First of all, as System Administrator, set the C_Order table as "Fully Audited"
2) Run the Update Audit Trail infrastructure process (Application Dictionary/Update Audit Trail infrastructure)
3) Create new records on "Sales Order" or delete them with the intention of inserting values in "Audit Trail" window. Once you have enough files, update the "event_time" column of some files in ad_audit_trail table using pgadmin. Set this records 30 days earlier.
4) Create a "Query Only" window based on AD_Audit_Trail_V table, and set the HQL filter clause like "eventTime >= now() - 20" (20 days) and the HQL Order By clause like "-eventTime". Add this window to the menu.

*** Testing
Go to new window and try to filter by some column, it shows message "No items to show". However, if we clear filters (by clicking the funnel icon), everything works correctly.
TagsNo tags attached.
Attached Files? file icon FiltersNotApplied.mp4 [^] (1,998,236 bytes) 2016-06-02 13:21
txt file icon errorTrace.txt [^] (6,376 bytes) 2016-08-01 14:21 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00334763.0PR16Q4 closedcaristu Issue with saved view filtered by created by 

-  Notes
(0088709)
caristu (developer)
2016-08-01 18:06
edited on: 2016-08-01 18:07

 This is not an issue, in the HQL filter clause, when referring to properties of the entity shown in the tab then the alias e must be used. In this case, the where clause would be as follows:

  e.eventTime >= now() - 20

The following link[1] has been updated to remark the usage of this alias.

[1] http://wiki.openbravo.com/wiki/How_to_Create_a_Window [^]

- Issue History
Date Modified Username Field Change
2016-06-02 13:21 JONHM New Issue
2016-06-02 13:21 JONHM Assigned To => platform
2016-06-02 13:21 JONHM File Added: FiltersNotApplied.mp4
2016-06-02 13:21 JONHM Modules => Core
2016-06-02 13:21 JONHM Triggers an Emergency Pack => No
2016-07-15 08:41 alostale Relationship added related to 0033476
2016-07-15 08:41 alostale Status new => acknowledged
2016-08-01 12:32 caristu Assigned To platform => caristu
2016-08-01 12:32 caristu Status acknowledged => scheduled
2016-08-01 14:21 JONHM File Added: errorTrace.txt
2016-08-01 18:06 caristu Review Assigned To => caristu
2016-08-01 18:06 caristu Note Added: 0088709
2016-08-01 18:06 caristu Status scheduled => closed
2016-08-01 18:06 caristu Resolution open => no change required
2016-08-01 18:07 caristu Note Edited: 0088709 View Revisions

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker