You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "FooShyn (Created) (JIRA)" <ji...@apache.org> on 2012/04/16 15:28:17 UTC
[jira] [Created] (OFBIZ-4811) Improving view-entity creation in
both XML and DynamicViewEntity to exclude fields declared as Alias from the
SQL Select strings
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: ALL APPLICATIONS, ALL COMPONENTS
Affects Versions: Release Branch 11.04
Environment: Windows, Linux
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
[jira] [Commented] (OFBIZ-4811) Improving view-entity creation in
both XML and DynamicViewEntity to exclude fields declared as Alias from the
SQL Select strings
Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-4811?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13277698#comment-13277698 ]
Jacques Le Roux commented on OFBIZ-4811:
----------------------------------------
I put from Available Patch to Provide Patch status: there are no patches here...
> 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
[jira] [Updated] (OFBIZ-4811) Improving view-entity creation in
both XML and DynamicViewEntity to exclude fields declared as Alias from the
SQL Select strings
Posted by "Jacques Le Roux (Updated) (JIRA)" <ji...@apache.org>.
[ 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