[
https://issues.apache.org/jira/browse/OFBIZ-4811?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sharan Foga updated OFBIZ-4811:
-------------------------------
Sprint: Bug Crush Event - 21/2/2015
> Improving view-entity creation in both XML and DynamicViewEntity to exclude
> fields declared as Alias from the SQL Select strings
> --------------------------------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-4811
> URL: https://issues.apache.org/jira/browse/OFBIZ-4811
> Project: OFBiz
> Issue Type: Improvement
> Components: framework
> Affects Versions: Trunk
> Reporter: FooShyn
> Assignee: Adam Heath
>
> To have additional feature for view-entity creation so that
> - Alias can be excluded from the SQL Select strings. This feature is
> particularly useful when working on reports that need aggregation on the data
> with fields that need to be use as filter. E.g.: select a.salesman_id,
> sum(b.sales) as total_sales from salesman a, daily_sales b where
> a.salesman_id = b.salesman_id and b.sales_date < '02-02-2012' group by
> a.salesman_id
> - To have constant values that can be use in view-link.
> E.g.
> <view-link rel-entity-alias="ISE" entity-alias="FISIE" rel-optional="true">
> <key-map field-name="importSessionId" rel-field-name="sessionId"/>
> <field-bound rel-field-name="status" rel-field-value="ERROR"/>
> </view-link>
> This produces something like this:
> select * from a left join b on a.importSessionId = b.sessionId and
> status='ERROR'
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
