Return-Path: X-Original-To: apmail-ofbiz-dev-archive@www.apache.org Delivered-To: apmail-ofbiz-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id F31BC174F8 for ; Sat, 21 Feb 2015 07:38:49 +0000 (UTC) Received: (qmail 72869 invoked by uid 500); 21 Feb 2015 07:38:33 -0000 Delivered-To: apmail-ofbiz-dev-archive@ofbiz.apache.org Received: (qmail 72836 invoked by uid 500); 21 Feb 2015 07:38:32 -0000 Mailing-List: contact dev-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 dev@ofbiz.apache.org Received: (qmail 72754 invoked by uid 99); 21 Feb 2015 07:38:32 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 21 Feb 2015 07:38:32 +0000 Date: Sat, 21 Feb 2015 07:38:32 +0000 (UTC) From: "Sharan Foga (JIRA)" To: dev@ofbiz.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (OFBIZ-566) Searching on 'widgets' in the demo shouldn't tell you that the category is empty MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/OFBIZ-566?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sharan Foga updated OFBIZ-566: ------------------------------ Sprint: Bug Crush Event - 21/2/2015 > Searching on 'widgets' in the demo shouldn't tell you that the category is empty > -------------------------------------------------------------------------------- > > Key: OFBIZ-566 > URL: https://issues.apache.org/jira/browse/OFBIZ-566 > Project: OFBiz > Issue Type: Improvement > Components: specialpurpose/ecommerce > Affects Versions: Trunk > Reporter: David N. Welton > Priority: Trivial > > Hi, > I was perusing OFBiz again to gain some insights, and one thing jumped out at me as a minor annoyance that ought to be fixed, so I'm reporting it. > The problem is that when you click on 'widgets' in the demo', you get a screen saying that "There are no products in this category", as well as getting the two subcategories expanded on the left bar. > If I am trying to sell stuff, I think I would prefer to have products in this category's subcategories come up, if there is nothing in the category itself, as well as a list of the subcategories that could be selected. I know that things are meant to be customized, but the better the defaults are, the easier it is for people to see how cool OFBiz is, and start using it with less modification required. > Unfortunately, I don't have the time or incentives to take care of this... the query I'd be after is something like this: > select * from product_category_member where product_category_id in (select product_category_id from product_category where primary_parent_category_id = '200' or product_category_id = '200') limit N; (200 is 'widgets') > But I don't know how to implement that... > Thanks, > Dave -- This message was sent by Atlassian JIRA (v6.3.4#6332)