[
https://issues.apache.org/jira/browse/OFBIZ-10005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16265636#comment-16265636
]
Rohit Rai commented on OFBIZ-10005:
-----------------------------------
Hi,
I found that a similar error is thrown on performing search on many other view
entities as well. For example, CommunicationEventSum,
MarketingCampaignAndOrderHeader, TrackingCodeAndOrderHeader and many more.
A similar pattern is followed while creating these views, we have used
group-by="true" for one of the columns of the view entity and group-by="false"
for one other column. For instance, marketingCampaignId is used to group by the
results while fromDate is not included in the group by.
<alias entity-alias="TC" name="marketingCampaignId" group-by="true"/>
<alias entity-alias="TCV" name="fromDate" group-by="false"/>
We can't have items in the select that are not in the group by unless we are
going to use a summary function on them. If we group by id we are collapsing
all rows with the same id into one row, if we want other columns to be
presented we must perform an aggregate function on them or we can group by with
more than one column.
For the view definition, modifying the value of group-by="true" for the from
date will fix the issue.
<alias entity-alias="TCV" name="fromDate" group-by="true"/>
But, I am not sure why we used group-by="false" with the date in the first
place, I am looking into it.
> Broken screen while performing find operation on 'MarketingCampaignAndVisit'
> entity from webtools
> -------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-10005
> URL: https://issues.apache.org/jira/browse/OFBIZ-10005
> Project: OFBiz
> Issue Type: Bug
> Components: framework/webtools
> Reporter: Pradeep Choudhary
> Assignee: Rohit Rai
> Priority: Blocker
> Fix For: Trunk
>
> Attachments: EnityFindOperatioError.png
>
>
> Steps to regenerate:
> 1. Ope URL
> [https://demo-trunk.ofbiz.apache.org/webtools/control/FindGeneric?entityName=MarketingCampaignAndVisit]
> 2. Perform find operation on given entity with empty fields.
> 3. Broken Screen appears. (Please find the attached screenshot)
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
