[jira] [Commented] (OFBIZ-10005) Broken screen while performing find operation on 'MarketingCampaignAndVisit' entity from webtools

["Rohit Rai (JIRA)" <ji...@apache.org>]

    [ 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)