ofbiz-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rohit Rai (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OFBIZ-10005) Broken screen while performing find operation on 'MarketingCampaignAndVisit' entity from webtools
Date Sat, 25 Nov 2017 09:00:00 GMT

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

Mime
View raw message