[
https://issues.apache.org/jira/browse/OFBIZ-4811?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Le Roux closed OFBIZ-4811.
----------------------------------
Resolution: Abandoned
> 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, Upcoming Branch
> Reporter: FooShyn
> Assignee: Adam Heath
> Priority: Major
>
> 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
(v8.20.10#820010)
