[
https://issues.apache.org/jira/browse/OFBIZ-4811?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Le Roux updated OFBIZ-4811:
-----------------------------------
Component/s: (was: ALL APPLICATIONS)
(was: ALL COMPONENTS)
framework
Environment: (was: Windows, Linux)
Affects Version/s: (was: Release Branch 11.04)
SVN trunk
> 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: SVN trunk
> Reporter: FooShyn
>
> 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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
