OFBiz › OFBiz - User

Catalog Categories Rollup Question

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

12 messages Options

Alex Melnik

Catalog Categories Rollup Question

Hello,

I apologies if this question has been addressed before, but I wasn't able to find info on this. The questions is as follows:

When I add a category and a subcategory to the catalog, both category and subcategory shows up at the same level (1st level in catalog). How can I turn it off?

Thanks for the help,
Alex

Jacek Wagner

Re: Catalog Categories Rollup Question

Alex Melnik wrote:

> Hello,
>
> I apologies if this question has been addressed before, but I wasn't able to find info on this. The questions is as follows:
>
> When I add a category and a subcategory to the catalog, both category and subcategory shows up at the same level (1st level in catalog). How can I turn it off?
>
> Thanks for the help,
> Alex
>
>

Alex,

I had the same problem. Please follow email exchange below, it worked
for me:

Hi Jacek

You must assign the parent category using the category rollup screen,
it is not enough to just assign the primaryParentCategoryId.

Regards
Scott

2008/8/23 Jacek Wagner <[hidden email]>:

> > Jacques Le Roux wrote:
>
>> >>
>> >> What makes you believe that ? Did you see any issues in result ?
>> >>
>> >> Jacques
>> >>
>> >> From: "Jacek Wagner" <[hidden email]>
>>
>>> >>>
>>> >>> I have noticed while working with Catalog-Categories that the list of top
>>> >>> categories (parent category is null) is incorrect.
>>> >>>
>>> >>> I believe that CategoryWorker.java (producing the list of top categories)
>>> >>> has an error;
>>> >>>
>>> >>> in line 105 "CurrentProductCategoryRollup" should be replaced with
>>> >>> "PrimaryParentCategoryId"
>>> >>>
>>> >>> Jacek
>>> >>>
>>>
> > I created a top category using UI, I checked db and found in the
> > ProductCategory table my newly created category with PrimaryParentCategoryId
> > = null as expected.
> > Then I created a sub-category using UI and checked db again and found in the
> > ProductCategory table my sub-category with PrimaryParentCategoryId pointing
> > to top category as expected.
> > After that selecting Choose Top Categories from the UI (webtools/menu
> > catalog/Browse Categories) I would expect to see my top category only, but I
> > have seen top category along with sub-category instead).
> >
> > Jacek
> >
>

Alex Melnik

Re: Catalog Categories Rollup Question

Jacek, thanks for the help. I tried changes the CategoryWorker but that doesn't seem to help. I am using the rollup. I'm doing an ETL into the schema though. I'm thinking that maybe I'm not setting some field properly, so my categories and subcategories get flattened up in addition to being hirarchical.

Any ideas?

Thanks,
Alex
>>> Jacek Wagner <[hidden email]> 8/25/2008 11:09 AM >>>

Alex Melnik wrote:

BJ Freeman

Re: Catalog Categories Rollup Question

to get an idea of what you have to do, you can look the mini-language
for dealing with categories. this is all taken care of if you use them.
applications\product\script\org\ofbiz\product\category

Alex Melnik sent the following on 8/25/2008 10:19 AM:

> Jacek, thanks for the help. I tried changes the CategoryWorker but that doesn't seem to help. I am using the rollup. I'm doing an ETL into the schema though. I'm thinking that maybe I'm not setting some field properly, so my categories and subcategories get flattened up in addition to being hirarchical.
>
> Any ideas?
>
> Thanks,
> Alex
>>>> Jacek Wagner <[hidden email]> 8/25/2008 11:09 AM >>>
>
> Alex Melnik wrote:
>> Hello,
>>
>> I apologies if this question has been addressed before, but I wasn't able to find info on this. The questions is as follows:
>>
>> When I add a category and a subcategory to the catalog, both category and subcategory shows up at the same level (1st level in catalog). How can I turn it off?
>>
>> Thanks for the help,
>> Alex
>>
>>
> Alex,
>
> I had the same problem. Please follow email exchange below, it worked
> for me:
>
> Hi Jacek
>
> You must assign the parent category using the category rollup screen,
> it is not enough to just assign the primaryParentCategoryId.
>
> Regards
> Scott
>
> 2008/8/23 Jacek Wagner <[hidden email]>:
>
>>> Jacques Le Roux wrote:
>>
>>>>> What makes you believe that ? Did you see any issues in result ?
>>>>>
>>>>> Jacques
>>>>>
>>>>> From: "Jacek Wagner" <[hidden email]>
>>>
>>>>>>> I have noticed while working with Catalog-Categories that the list of top
>>>>>>> categories (parent category is null) is incorrect.
>>>>>>>
>>>>>>> I believe that CategoryWorker.java (producing the list of top categories)
>>>>>>> has an error;
>>>>>>>
>>>>>>> in line 105 "CurrentProductCategoryRollup" should be replaced with
>>>>>>> "PrimaryParentCategoryId"
>>>>>>>
>>>>>>> Jacek
>>>>>>>
>>>>
>>> I created a top category using UI, I checked db and found in the
>>> ProductCategory table my newly created category with PrimaryParentCategoryId
>>> = null as expected.
>>> Then I created a sub-category using UI and checked db again and found in the
>>> ProductCategory table my sub-category with PrimaryParentCategoryId pointing
>>> to top category as expected.
>>> After that selecting Choose Top Categories from the UI (webtools/menu
>>> catalog/Browse Categories) I would expect to see my top category only, but I
>>> have seen top category along with sub-category instead).
>>>
>>> Jacek
>>>
>>
>
>
>
>
>

Alex Melnik

Re: Catalog Categories Rollup Question

BJ, Thanks for the advice. I took a look at the xml and it seems I'm doing everything as instructed. I also went through a business setup guided an did step-by-step catalog/category setup. I seems that in either case all the subcategories get rolled up to the catalog (or rather browsing root) level. Have you seen anything like that before? I'm setting both parent category id and the rollup to be safe :)..

Thanks,
Alex

>>> BJ Freeman <[hidden email]> 8/25/2008 12:32 PM >>>

to get an idea of what you have to do, you can look the mini-language
for dealing with categories. this is all taken care of if you use them.
applications\product\script\org\ofbiz\product\category

Alex Melnik sent the following on 8/25/2008 10:19 AM:

BJ Freeman

Re: Catalog Categories Rollup Question

what rev of the trunk are you using.
just checking since we have had some problems with recent revs.

Alex Melnik sent the following on 8/25/2008 11:43 AM:

> BJ, Thanks for the advice. I took a look at the xml and it seems I'm doing everything as instructed. I also went through a business setup guided an did step-by-step catalog/category setup. I seems that in either case all the subcategories get rolled up to the catalog (or rather browsing root) level. Have you seen anything like that before? I'm setting both parent category id and the rollup to be safe :)..
>
> Thanks,
> Alex
>
>>>> BJ Freeman <[hidden email]> 8/25/2008 12:32 PM >>>
>
> to get an idea of what you have to do, you can look the mini-language
> for dealing with categories. this is all taken care of if you use them.
> applications\product\script\org\ofbiz\product\category
>
> Alex Melnik sent the following on 8/25/2008 10:19 AM:
>> Jacek, thanks for the help. I tried changes the CategoryWorker but that doesn't seem to help. I am using the rollup. I'm doing an ETL into the schema though. I'm thinking that maybe I'm not setting some field properly, so my categories and subcategories get flattened up in addition to being hirarchical.
>>
>> Any ideas?
>>
>> Thanks,
>> Alex
>>>>> Jacek Wagner <[hidden email]> 8/25/2008 11:09 AM >>>
>> Alex Melnik wrote:
>>> Hello,
>>>
>>> I apologies if this question has been addressed before, but I wasn't able to find info on this. The questions is as follows:
>>>
>>> When I add a category and a subcategory to the catalog, both category and subcategory shows up at the same level (1st level in catalog). How can I turn it off?
>>>
>>> Thanks for the help,
>>> Alex
>>>
>>>
>> Alex,
>>
>> I had the same problem. Please follow email exchange below, it worked
>> for me:
>>
>> Hi Jacek
>>
>> You must assign the parent category using the category rollup screen,
>> it is not enough to just assign the primaryParentCategoryId.
>>
>> Regards
>> Scott
>>
>> 2008/8/23 Jacek Wagner <[hidden email]>:
>>
>>>> Jacques Le Roux wrote:
>>>
>>>>>> What makes you believe that ? Did you see any issues in result ?
>>>>>>
>>>>>> Jacques
>>>>>>
>>>>>> From: "Jacek Wagner" <[hidden email]>
>>>>
>>>>>>>> I have noticed while working with Catalog-Categories that the list of top
>>>>>>>> categories (parent category is null) is incorrect.
>>>>>>>>
>>>>>>>> I believe that CategoryWorker.java (producing the list of top categories)
>>>>>>>> has an error;
>>>>>>>>
>>>>>>>> in line 105 "CurrentProductCategoryRollup" should be replaced with
>>>>>>>> "PrimaryParentCategoryId"
>>>>>>>>
>>>>>>>> Jacek
>>>>>>>>
>>>>>
>>>> I created a top category using UI, I checked db and found in the
>>>> ProductCategory table my newly created category with PrimaryParentCategoryId
>>>> = null as expected.
>>>> Then I created a sub-category using UI and checked db again and found in the
>>>> ProductCategory table my sub-category with PrimaryParentCategoryId pointing
>>>> to top category as expected.
>>>> After that selecting Choose Top Categories from the UI (webtools/menu
>>>> catalog/Browse Categories) I would expect to see my top category only, but I
>>>> have seen top category along with sub-category instead).
>>>>
>>>> Jacek
>>>>
>>>
>>
>>
>>
>>
>
>
>
>
>

Alex Melnik

Re: Catalog Categories Rollup Question

it's a few months old rev.... was at the company when I got here... I found the reason the categories where duplicate. In CategoryWorker.java: getRelatedCategoriesRet() on line 204 and 207, all categories are being added pretty much to the list. Once you comment those addAll calls you regular hirarchy seems to be preserved.

Alex

>>> BJ Freeman <[hidden email]> 8/25/2008 2:26 PM >>>

what rev of the trunk are you using.
just checking since we have had some problems with recent revs.

Alex Melnik sent the following on 8/25/2008 11:43 AM:

BJ Freeman

Re: Catalog Categories Rollup Question

from looking at this it might be from using 1.5.
the was a lot of work done recently to fix typing.
I get this message for getRelatedCategoriesRet
Type safety: The method addAll(Collection) belongs to the raw type List.
References to generic type List<E> should be parameterized

Alex Melnik sent the following on 8/25/2008 2:03 PM:

> it's a few months old rev.... was at the company when I got here... I found the reason the categories where duplicate. In CategoryWorker.java: getRelatedCategoriesRet() on line 204 and 207, all categories are being added pretty much to the list. Once you comment those addAll calls you regular hirarchy seems to be preserved.
>
> Alex
>
>>>> BJ Freeman <[hidden email]> 8/25/2008 2:26 PM >>>
>
> what rev of the trunk are you using.
> just checking since we have had some problems with recent revs.
>
> Alex Melnik sent the following on 8/25/2008 11:43 AM:
>> BJ, Thanks for the advice. I took a look at the xml and it seems I'm doing everything as instructed. I also went through a business setup guided an did step-by-step catalog/category setup. I seems that in either case all the subcategories get rolled up to the catalog (or rather browsing root) level. Have you seen anything like that before? I'm setting both parent category id and the rollup to be safe :)..
>>
>> Thanks,
>> Alex
>>
>>>>> BJ Freeman <[hidden email]> 8/25/2008 12:32 PM >>>
>> to get an idea of what you have to do, you can look the mini-language
>> for dealing with categories. this is all taken care of if you use them.
>> applications\product\script\org\ofbiz\product\category
>>
>> Alex Melnik sent the following on 8/25/2008 10:19 AM:
>>> Jacek, thanks for the help. I tried changes the CategoryWorker but that doesn't seem to help. I am using the rollup. I'm doing an ETL into the schema though. I'm thinking that maybe I'm not setting some field properly, so my categories and subcategories get flattened up in addition to being hirarchical.
>>>
>>> Any ideas?
>>>
>>> Thanks,
>>> Alex
>>>>>> Jacek Wagner <[hidden email]> 8/25/2008 11:09 AM >>>
>>> Alex Melnik wrote:
>>>> Hello,
>>>>
>>>> I apologies if this question has been addressed before, but I wasn't able to find info on this. The questions is as follows:
>>>>
>>>> When I add a category and a subcategory to the catalog, both category and subcategory shows up at the same level (1st level in catalog). How can I turn it off?
>>>>
>>>> Thanks for the help,
>>>> Alex
>>>>
>>>>
>>> Alex,
>>>
>>> I had the same problem. Please follow email exchange below, it worked
>>> for me:
>>>
>>> Hi Jacek
>>>
>>> You must assign the parent category using the category rollup screen,
>>> it is not enough to just assign the primaryParentCategoryId.
>>>
>>> Regards
>>> Scott
>>>
>>> 2008/8/23 Jacek Wagner <[hidden email]>:
>>>
>>>>> Jacques Le Roux wrote:
>>>>
>>>>>>> What makes you believe that ? Did you see any issues in result ?
>>>>>>>
>>>>>>> Jacques
>>>>>>>
>>>>>>> From: "Jacek Wagner" <[hidden email]>
>>>>>
>>>>>>>>> I have noticed while working with Catalog-Categories that the list of top
>>>>>>>>> categories (parent category is null) is incorrect.
>>>>>>>>>
>>>>>>>>> I believe that CategoryWorker.java (producing the list of top categories)
>>>>>>>>> has an error;
>>>>>>>>>
>>>>>>>>> in line 105 "CurrentProductCategoryRollup" should be replaced with
>>>>>>>>> "PrimaryParentCategoryId"
>>>>>>>>>
>>>>>>>>> Jacek
>>>>>>>>>
>>>>>>
>>>>> I created a top category using UI, I checked db and found in the
>>>>> ProductCategory table my newly created category with PrimaryParentCategoryId
>>>>> = null as expected.
>>>>> Then I created a sub-category using UI and checked db again and found in the
>>>>> ProductCategory table my sub-category with PrimaryParentCategoryId pointing
>>>>> to top category as expected.
>>>>> After that selecting Choose Top Categories from the UI (webtools/menu
>>>>> catalog/Browse Categories) I would expect to see my top category only, but I
>>>>> have seen top category along with sub-category instead).
>>>>>
>>>>> Jacek
>>>>>
>>>>
>>>
>>>
>>>
>>
>>
>>
>>
>
>
>
>
>

BJ Freeman

Re: Catalog Categories Rollup Question

In reply to this post by Alex Melnik

Oh and lines have changed it was last worked on 8/17/08

Alex Melnik sent the following on 8/25/2008 2:03 PM:

David E Jones

Re: Catalog Categories Rollup Question

In reply to this post by BJ Freeman

I'm really not sure how something like this would cause data from one place to end up in another place...

Alex: to make progress on this you'd probably have to do an export of your ProductCategory and ProductCategoryRollup
entities and send at least part of it over and hope someone has some time to take a look at it.

Another alternative would be to put some data on the demo.hotwaxmedia.com server to reproduce the issue and then send a
message about it to the mailing list with additional details.

-David

BJ Freeman wrote:

> from looking at this it might be from using 1.5.
> the was a lot of work done recently to fix typing.
> I get this message for getRelatedCategoriesRet
> Type safety: The method addAll(Collection) belongs to the raw type List.
> References to generic type List<E> should be parameterized
>
>
>
> Alex Melnik sent the following on 8/25/2008 2:03 PM:
>> it's a few months old rev.... was at the company when I got here... I found the reason the categories where duplicate. In CategoryWorker.java: getRelatedCategoriesRet() on line 204 and 207, all categories are being added pretty much to the list. Once you comment those addAll calls you regular hirarchy seems to be preserved.
>>
>> Alex
>>
>>>>> BJ Freeman <[hidden email]> 8/25/2008 2:26 PM >>>
>> what rev of the trunk are you using.
>> just checking since we have had some problems with recent revs.
>>
>> Alex Melnik sent the following on 8/25/2008 11:43 AM:
>>> BJ, Thanks for the advice. I took a look at the xml and it seems I'm doing everything as instructed. I also went through a business setup guided an did step-by-step catalog/category setup. I seems that in either case all the subcategories get rolled up to the catalog (or rather browsing root) level. Have you seen anything like that before? I'm setting both parent category id and the rollup to be safe :)..
>>>
>>> Thanks,
>>> Alex
>>>
>>>>>> BJ Freeman <[hidden email]> 8/25/2008 12:32 PM >>>
>>> to get an idea of what you have to do, you can look the mini-language
>>> for dealing with categories. this is all taken care of if you use them.
>>> applications\product\script\org\ofbiz\product\category
>>>
>>> Alex Melnik sent the following on 8/25/2008 10:19 AM:
>>>> Jacek, thanks for the help. I tried changes the CategoryWorker but that doesn't seem to help. I am using the rollup. I'm doing an ETL into the schema though. I'm thinking that maybe I'm not setting some field properly, so my categories and subcategories get flattened up in addition to being hirarchical.
>>>>
>>>> Any ideas?
>>>>
>>>> Thanks,
>>>> Alex
>>>>>>> Jacek Wagner <[hidden email]> 8/25/2008 11:09 AM >>>
>>>> Alex Melnik wrote:
>>>>> Hello,
>>>>>
>>>>> I apologies if this question has been addressed before, but I wasn't able to find info on this. The questions is as follows:
>>>>>
>>>>> When I add a category and a subcategory to the catalog, both category and subcategory shows up at the same level (1st level in catalog). How can I turn it off?
>>>>>
>>>>> Thanks for the help,
>>>>> Alex
>>>>>
>>>>>
>>>> Alex,
>>>>
>>>> I had the same problem. Please follow email exchange below, it worked
>>>> for me:
>>>>
>>>> Hi Jacek
>>>>
>>>> You must assign the parent category using the category rollup screen,
>>>> it is not enough to just assign the primaryParentCategoryId.
>>>>
>>>> Regards
>>>> Scott
>>>>
>>>> 2008/8/23 Jacek Wagner <[hidden email]>:
>>>>
>>>>>> Jacques Le Roux wrote:
>>>>>
>>>>>>>> What makes you believe that ? Did you see any issues in result ?
>>>>>>>>
>>>>>>>> Jacques
>>>>>>>>
>>>>>>>> From: "Jacek Wagner" <[hidden email]>
>>>>>>
>>>>>>>>>> I have noticed while working with Catalog-Categories that the list of top
>>>>>>>>>> categories (parent category is null) is incorrect.
>>>>>>>>>>
>>>>>>>>>> I believe that CategoryWorker.java (producing the list of top categories)
>>>>>>>>>> has an error;
>>>>>>>>>>
>>>>>>>>>> in line 105 "CurrentProductCategoryRollup" should be replaced with
>>>>>>>>>> "PrimaryParentCategoryId"
>>>>>>>>>>
>>>>>>>>>> Jacek
>>>>>>>>>>
>>>>>>>
>>>>>> I created a top category using UI, I checked db and found in the
>>>>>> ProductCategory table my newly created category with PrimaryParentCategoryId
>>>>>> = null as expected.
>>>>>> Then I created a sub-category using UI and checked db again and found in the
>>>>>> ProductCategory table my sub-category with PrimaryParentCategoryId pointing
>>>>>> to top category as expected.
>>>>>> After that selecting Choose Top Categories from the UI (webtools/menu
>>>>>> catalog/Browse Categories) I would expect to see my top category only, but I
>>>>>> have seen top category along with sub-category instead).
>>>>>>
>>>>>> Jacek
>>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>>
>>
>>
>

Alex Melnik

Re: Catalog Categories Rollup Question

David, I probably wasn't clear. I actually commented addAll calls and it works fine now (or at least it seems to present categories properly). So I think I'm good. I was sending the email to let everybody know more than to try to get help. I'll keep you updated if any functionality gets messed up from that

>>> "David E. Jones" <[hidden email]> 8/25/2008 6:33 PM >>>

I'm really not sure how something like this would cause data from one place to end up in another place...

Alex: to make progress on this you'd probably have to do an export of your ProductCategory and ProductCategoryRollup
entities and send at least part of it over and hope someone has some time to take a look at it.

Another alternative would be to put some data on the demo.hotwaxmedia.com server to reproduce the issue and then send a
message about it to the mailing list with additional details.

-David

BJ Freeman wrote:

Scott Gray

Re: Catalog Categories Rollup Question

If it's possible your checkout was taken between the 12th and the 16th
of January, then all of this makes sense because there was a bug in
the CategoryWorker class during that time. If that is the case then
you should make the changes listed here:
http://svn.apache.org/viewvc?view=rev&revision=612431 (click on the
"text changed" link)

Regards
Scott

2008/8/26 Alex Melnik <[hidden email]>:

> David, I probably wasn't clear. I actually commented addAll calls and it works fine now (or at least it seems to present categories properly). So I think I'm good. I was sending the email to let everybody know more than to try to get help. I'll keep you updated if any functionality gets messed up from that
>
>>>> "David E. Jones" <[hidden email]> 8/25/2008 6:33 PM >>>
>
>
> I'm really not sure how something like this would cause data from one place to end up in another place...
>
> Alex: to make progress on this you'd probably have to do an export of your ProductCategory and ProductCategoryRollup
> entities and send at least part of it over and hope someone has some time to take a look at it.
>
> Another alternative would be to put some data on the demo.hotwaxmedia.com server to reproduce the issue and then send a
> message about it to the mailing list with additional details.
>
> -David
>
>
> BJ Freeman wrote:
>> from looking at this it might be from using 1.5.
>> the was a lot of work done recently to fix typing.
>> I get this message for getRelatedCategoriesRet
>> Type safety: The method addAll(Collection) belongs to the raw type List.
>> References to generic type List<E> should be parameterized
>>
>>
>>
>> Alex Melnik sent the following on 8/25/2008 2:03 PM:
>>> it's a few months old rev.... was at the company when I got here... I found the reason the categories where duplicate. In CategoryWorker.java: getRelatedCategoriesRet() on line 204 and 207, all categories are being added pretty much to the list. Once you comment those addAll calls you regular hirarchy seems to be preserved.
>>>
>>> Alex
>>>
>>>>>> BJ Freeman <[hidden email]> 8/25/2008 2:26 PM >>>
>>> what rev of the trunk are you using.
>>> just checking since we have had some problems with recent revs.
>>>
>>> Alex Melnik sent the following on 8/25/2008 11:43 AM:
>>>> BJ, Thanks for the advice. I took a look at the xml and it seems I'm doing everything as instructed. I also went through a business setup guided an did step-by-step catalog/category setup. I seems that in either case all the subcategories get rolled up to the catalog (or rather browsing root) level. Have you seen anything like that before? I'm setting both parent category id and the rollup to be safe :)..
>>>>
>>>> Thanks,
>>>> Alex
>>>>
>>>>>>> BJ Freeman <[hidden email]> 8/25/2008 12:32 PM >>>
>>>> to get an idea of what you have to do, you can look the mini-language
>>>> for dealing with categories. this is all taken care of if you use them.
>>>> applications\product\script\org\ofbiz\product\category
>>>>
>>>> Alex Melnik sent the following on 8/25/2008 10:19 AM:
>>>>> Jacek, thanks for the help. I tried changes the CategoryWorker but that doesn't seem to help. I am using the rollup. I'm doing an ETL into the schema though. I'm thinking that maybe I'm not setting some field properly, so my categories and subcategories get flattened up in addition to being hirarchical.
>>>>>
>>>>> Any ideas?
>>>>>
>>>>> Thanks,
>>>>> Alex
>>>>>>>> Jacek Wagner <[hidden email]> 8/25/2008 11:09 AM >>>
>>>>> Alex Melnik wrote:
>>>>>> Hello,
>>>>>>
>>>>>> I apologies if this question has been addressed before, but I wasn't able to find info on this. The questions is as follows:
>>>>>>
>>>>>> When I add a category and a subcategory to the catalog, both category and subcategory shows up at the same level (1st level in catalog). How can I turn it off?
>>>>>>
>>>>>> Thanks for the help,
>>>>>> Alex
>>>>>>
>>>>>>
>>>>> Alex,
>>>>>
>>>>> I had the same problem. Please follow email exchange below, it worked
>>>>> for me:
>>>>>
>>>>> Hi Jacek
>>>>>
>>>>> You must assign the parent category using the category rollup screen,
>>>>> it is not enough to just assign the primaryParentCategoryId.
>>>>>
>>>>> Regards
>>>>> Scott
>>>>>
>>>>> 2008/8/23 Jacek Wagner <[hidden email]>:
>>>>>
>>>>>>> Jacques Le Roux wrote:
>>>>>>
>>>>>>>>> What makes you believe that ? Did you see any issues in result ?
>>>>>>>>>
>>>>>>>>> Jacques
>>>>>>>>>
>>>>>>>>> From: "Jacek Wagner" <[hidden email]>
>>>>>>>
>>>>>>>>>>> I have noticed while working with Catalog-Categories that the list of top
>>>>>>>>>>> categories (parent category is null) is incorrect.
>>>>>>>>>>>
>>>>>>>>>>> I believe that CategoryWorker.java (producing the list of top categories)
>>>>>>>>>>> has an error;
>>>>>>>>>>>
>>>>>>>>>>> in line 105 "CurrentProductCategoryRollup" should be replaced with
>>>>>>>>>>> "PrimaryParentCategoryId"
>>>>>>>>>>>
>>>>>>>>>>> Jacek
>>>>>>>>>>>
>>>>>>>>
>>>>>>> I created a top category using UI, I checked db and found in the
>>>>>>> ProductCategory table my newly created category with PrimaryParentCategoryId
>>>>>>> = null as expected.
>>>>>>> Then I created a sub-category using UI and checked db again and found in the
>>>>>>> ProductCategory table my sub-category with PrimaryParentCategoryId pointing
>>>>>>> to top category as expected.
>>>>>>> After that selecting Choose Top Categories from the UI (webtools/menu
>>>>>>> catalog/Browse Categories) I would expect to see my top category only, but I
>>>>>>> have seen top category along with sub-category instead).
>>>>>>>
>>>>>>> Jacek
>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>
>