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

View Revisions: Issue #30800 All Revisions ] Back to Issue ]
Summary 0030800: Filter on Property field in a table reference column doesn't work
Revision 2015-10-26 15:30 by alostale
Steps To Reproduce 1. Setup steps
1.1 As system admin
1.2 Open Window, Tabs and Fields
1.3 Open Sales Order, Header tab
1.4 Add a new Field:
  * Name: sales rep
  * Property: salesRepresentative.email
  * Show in Grid View: true

2. Reproduce steps
2.1 Login to ERP
2.2 Open Sales Order
2.3 Create 2 orders with different sales representatives
2.4 In grid view, clear filters (to ensure following filtering will be done in backend)
2.5 Filter by the email of one of these sales representatives
  -> * Grid shows no data
     * Debugging the query to get data it is:
       Order ... left join e.salesRepresentative as join_3 where (( upper(e.salesRepresentative.name) like upper(:alias_0) escape '|'))

Note it is trying to filter by e.salesRepresentative.name instead of e.salesRepresentative.email

Note client (adaptive) filtering is working fine for this case
Revision 2015-10-26 15:23 by alostale
Steps To Reproduce 1. Setup steps
1.1 As system admin
1.2 Open Window, Tabs and Fields
1.3 Open Sales Order, Header tab
1.4 Add a new Field:
  * Name: sales rep
  * Property: salesRepresentative.email
  * Show in Grid View: true

2. Reproduce steps
2.1 Login to ERP
2.2 Open Sales Order
2.3 Create 2 orders with different sales representatives
2.4 In grid view, clear filters (to ensure following filtering will be done in backend)
2.5 Filter by the email of one of these sales representatives
  -> * Grid shows no data
     * Debugging the query to get data it is:
       Order ... left join e.salesRepresentative as join_3 where (( upper(e.salesRepresentative.name) like upper(:alias_0) escape '|'))

Note it is trying to filter by e.salesRepresentative.name instead of e.salesRepresentative.email
Revision 2015-10-20 12:20 by yogaskarnik
Steps To Reproduce Setup steps:
1.Install the module (provided to the Product team)

Reproduce steps:
1.Login to ERP
2.Open Sales Order
3.Enter a filter on WO Status field in Sales Order window
4.Observe that the filter does not work
Revision 2015-10-20 11:11 by yogaskarnik
Steps To Reproduce Setup steps:
1.Install the module (provided to the Product team)

Reproduce steps:
1.Login to ERP
2.Open Sales Order
3.Enter a filter on Property field
4.Observe that the filter does not work
Revision 2015-10-08 06:18 by yogaskarnik
Steps To Reproduce 1. Create a foreign key field in Sales Order with a List reference.
2. Open Sales Order and filter the field
3. Notice that the filter does not work


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker