Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 25131200D02 for ; Sat, 23 Sep 2017 08:47:04 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 2393C1609B6; Sat, 23 Sep 2017 06:47:04 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 685C61609B5 for ; Sat, 23 Sep 2017 08:47:03 +0200 (CEST) Received: (qmail 6971 invoked by uid 500); 23 Sep 2017 06:47:02 -0000 Mailing-List: contact notifications-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ofbiz.apache.org Delivered-To: mailing list notifications@ofbiz.apache.org Received: (qmail 6961 invoked by uid 99); 23 Sep 2017 06:47:02 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 23 Sep 2017 06:47:02 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 9D00D19111C for ; Sat, 23 Sep 2017 06:47:01 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -99.202 X-Spam-Level: X-Spam-Status: No, score=-99.202 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, RP_MATCHES_RCVD=-0.001, SPF_PASS=-0.001, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id gccATTdxS2ZJ for ; Sat, 23 Sep 2017 06:47:01 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id DCF255FCB9 for ; Sat, 23 Sep 2017 06:47:00 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 649F9E045B for ; Sat, 23 Sep 2017 06:47:00 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 1A3E52420D for ; Sat, 23 Sep 2017 06:47:00 +0000 (UTC) Date: Sat, 23 Sep 2017 06:47:00 +0000 (UTC) From: "Pallavi Goyal (JIRA)" To: notifications@ofbiz.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (OFBIZ-8849) Search operation on 'OrderReportPurchasesGroupByProduct' entity causing exception. MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Sat, 23 Sep 2017 06:47:04 -0000 [ https://issues.apache.org/jira/browse/OFBIZ-8849?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16177598#comment-16177598 ] Pallavi Goyal commented on OFBIZ-8849: -------------------------------------- Hi Deepak, Thank you for the feedback. I checked the code and saw a comment over there "we need to explicitly identify the fields to select, otherwise the query will include fields that can't logically be grouped" which cleared all doubts. Hence, closing the issue. > Search operation on 'OrderReportPurchasesGroupByProduct' entity causing exception. > ---------------------------------------------------------------------------------- > > Key: OFBIZ-8849 > URL: https://issues.apache.org/jira/browse/OFBIZ-8849 > Project: OFBiz > Issue Type: Bug > Components: framework/webtools > Affects Versions: Trunk > Reporter: Pallavi Goyal > Attachments: OFBIZ-8849.patch, OrderReport_Actual.png, OrderReport_Expected.png > > > Steps to regenerate : > 1. Go to Entity Data Maintenance in webtools. > 2. Search entity 'OrderReportPurchasesGroupByProduct'. Click on it and go to the overview page. > 3. Click on the Find button. -- This message was sent by Atlassian JIRA (v6.4.14#64029)