Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033112Openbravo ERPA. Platformpublic2016-06-02 13:212016-08-01 18:06
ReporterJONHM 
Assigned Tocaristu 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket42234
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0033112: 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00334763.0PR16Q4 closed caristu Issue with saved view filtered by created by 
Attached Files? FiltersNotApplied.mp4 (1,998,236) 2016-06-02 13:21
https://issues.openbravo.com/file_download.php?file_id=9472&type=bug
txt errorTrace.txt (6,376) 2016-08-01 14:21
https://issues.openbravo.com/file_download.php?file_id=9663&type=bug
Issue History
Date ModifiedUsernameFieldChange
2016-06-02 13:21JONHMNew Issue
2016-06-02 13:21JONHMAssigned To => platform
2016-06-02 13:21JONHMFile Added: FiltersNotApplied.mp4
2016-06-02 13:21JONHMOBNetwork customer => Yes
2016-06-02 13:21JONHMModules => Core
2016-06-02 13:21JONHMSupport ticket => 42234
2016-06-02 13:21JONHMTriggers an Emergency Pack => No
2016-07-15 08:41alostaleRelationship addedrelated to 0033476
2016-07-15 08:41alostaleStatusnew => acknowledged
2016-08-01 12:32caristuAssigned Toplatform => caristu
2016-08-01 12:32caristuStatusacknowledged => scheduled
2016-08-01 14:21JONHMFile Added: errorTrace.txt
2016-08-01 18:06caristuReview Assigned To => caristu
2016-08-01 18:06caristuNote Added: 0088709
2016-08-01 18:06caristuStatusscheduled => closed
2016-08-01 18:06caristuResolutionopen => no change required
2016-08-01 18:07caristuNote Edited: 0088709bug_revision_view_page.php?bugnote_id=0088709#r12760

Notes
(0088709)
caristu   
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 [^]