Category becomes Category_id? (John Reese)

Date: Mon, 16 May 2011 13:16:50 -0400
From: John Reese <[email protected]>
Subject: Re: [mantisbt-help] Category becomes Category_id?
To: Help with Mantis <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

On 05/16/2011 09:28 AM, Jon Hardcastle wrote:
> Hi,
>
> We have just upgraded from Mantis 1.1.7 to MantisBT 1.2.4
>
> and some users have noticed that 'category' no longer appears on any of
> the reports (we have quite alot of tailored reports)
>
> I dug around in the code and config files and found something called
> 'category_id'
>
> Does anyone know if these are one and the same? and if so why it changed
> names?
>
> Is there anyway to bulk change all of our references?
>
> Thanks.

Basically, 1.2 introduced two new concepts for categories:  global
categories that can be used in any project, and the ability for child
projects to inherit categories from parent projects.  In order to
support those features, categories needed to become their own separate
entities, and issues needed to be updated to then reference those
entities rather than store a copy of the category name.

What you see as the category_id is a foreign key reference to
mantis_category_table.  Your reports will need to then look up the row
in that table that matches the id specified by the category_id column if
it wants to show the category name.

If you would like a code reference to use, you can look in the file
mantisbt/core/category_api.php for a set of functions to retrieve that
sort of information.

Cheers

-----------------



Hi,

Thanks for getting back to me.

We aren't generating reports in code. But we have tailored some of the view
screens and the csv export etc.

How/what should one do for category in these cases?

BUMP

------------------------------------------------------------------------------
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay

_______________________________________________
mantisbt-help mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mantisbt-help