[ https://issues.apache.org/jira/browse/OFBIZ-566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14966774#comment-14966774 ]
Jacques Le Roux commented on OFBIZ-566: --------------------------------------- Both ecommerce and ercomseo return 3 values (I did not check it's all but I guess it's OK) > 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 > Assignee: Jacques Le Roux > 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)