[jira] [Assigned] (OFBIZ-4811) Improving view-entity creation in both XML and DynamicViewEntity to exclude fields declared as Alias from the SQL Select strings

["Adam Heath (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OFBIZ-4811?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Adam Heath reassigned OFBIZ-4811:
---------------------------------

    Assignee: Adam Heath

> 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
>            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.2#6252)