Project:
| 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 |
 |