Bug in reports, subcategories

[Ingeborg Hellemo]

We use subcategories extensively. There is a bug in the report generator
related to subcats.

Howto reproduce:
* Goto Home > Report > Server (or some other category with subcategories).
* Click on subcats for a server which belongs to a subcategory. You are now in
<https://nav.uit.no/report/netboxinfo?netboxid=(#ofnetbox)>.
* Click on the name of a subcategory
* You will now enter https://nav.uit.no/report/netboxinfo?category=(Name of
subcat)>

Lo and behold:

Netboxinfo
Configuration error! The report generator is not able to do such things.
column "category" does not exist LINE 1: ...IN netboxcategory USING
(netboxid)) AS foo WHERE category =... ^

[Morten Brekkevold]

Post by Ingeborg Hellemo
* You will now enter https://nav.uit.no/report/netboxinfo?category=(Name of
subcat)>
Netboxinfo
Configuration error! The report generator is not able to do such things.
column "category" does not exist LINE 1: ...IN netboxcategory USING
(netboxid)) AS foo WHERE category =... ^

I can confirm this on my end. Please report this bug at
https://bugs.launchpad.net/nav/+filebug .

[Stokkenes Vidar]

I just found another probably related bug, which I don't think is subcat related at all.

I can reproduce kind of the same error with http://nav.foo.com/report/modules?typeid=XXX:

"Configuration error! The report generator is not able to do such things. column "typeid" does not exist LINE 1: ...duleid) tempaggr2 USING (moduleid)) AS foo WHERE typeid = '... ^"

-Vidar

-----Opprinnelig melding-----
På vegne av Ingeborg Hellemo
Sendt: 14. desember 2011 11:13
Emne: Bug in reports, subcategories
We use subcategories extensively. There is a bug in the report
generator related to subcats.
* Goto Home > Report > Server (or some other category with
subcategories).
* Click on subcats for a server which belongs to a subcategory. You are
now in <https://nav.uit.no/report/netboxinfo?netboxid=(#ofnetbox)>.
* Click on the name of a subcategory
* You will now enter
https://nav.uit.no/report/netboxinfo?category=(Name of subcat)>
Netboxinfo
Configuration error! The report generator is not able to do such things.
column "category" does not exist LINE 1: ...IN netboxcategory USING
(netboxid)) AS foo WHERE category =... ^
--
Dep. of Information Technology --- Univ. of Tromsø

[Morten Brekkevold]

Post by Stokkenes Vidar
I just found another probably related bug, which I don't think is subcat related at all.

That link in itself isn't very interesting unless you know where you got
it from. When you do, please report it at
https://bugs.launchpad.net/nav/+filebug :-)