Database mapping for severity, priority, reproducibility

General discussion of Mantis.

Moderators: Developer, Contributor

Post Reply
Andre.Stuhrmann
Posts: 4
Joined: 07 Feb 2023, 10:03

Database mapping for severity, priority, reproducibility

Post by Andre.Stuhrmann »

Hello,

we are in the middle of a migration from Mantis Bugtracker to Jira.

The main table is mantis_bug_table. For the fields mentioned in the subject I can only find numeric values in the main table. E.g., severity = 50. I can not find where those values are mapped. None of the tables in the database folder "Tables" seems to provide mapping values for these three fields.

Can anyone tell where the text values like "urgent" are stored/mapped?

Thanks a lot in advance.

Best regards,
André
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Database mapping for severity, priority, reproducibility

Post by cas »

checkout core/constant_inc.php
Andre.Stuhrmann
Posts: 4
Joined: 07 Feb 2023, 10:03

Re: Database mapping for severity, priority, reproducibility

Post by Andre.Stuhrmann »

Dear cas,

thank you for your reply.

I might not have been clear about what I intend to see. I'm using SQL to get information out of the database. What I get are number values for the three respective fields. I would like to map those to text values. Please see the attachment for clarification.

Do you know in which table I can find the text values for priority, severity and reproducibility?

Best regards,
André
Attachments
mantis database.jpg
mantis database.jpg (30.43 KiB) Viewed 31241 times
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Database mapping for severity, priority, reproducibility

Post by cas »

Like I said, they are not in a table, those are constants.
You would need to create a table holding all the constants.
Andre.Stuhrmann
Posts: 4
Joined: 07 Feb 2023, 10:03

Re: Database mapping for severity, priority, reproducibility

Post by Andre.Stuhrmann »

Dear Cas,

thanks for the clarification.

I can find the mapping values for severity and priority in that file. However, there is nothing for reproducibility. Do you have an idea where I can find those information?

Best regards,
André
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Database mapping for severity, priority, reproducibility

Post by cas »

That is in the same file:
# reproducibility
define( 'REPRODUCIBILITY_ALWAYS', 10 );
define( 'REPRODUCIBILITY_SOMETIMES', 30 );
define( 'REPRODUCIBILITY_RANDOM', 50 );
define( 'REPRODUCIBILITY_HAVENOTTRIED', 70 );
define( 'REPRODUCIBILITY_UNABLETODUPLICATE', 90 );
define( 'REPRODUCIBILITY_NOTAPPLICABLE', 100 );
Andre.Stuhrmann
Posts: 4
Joined: 07 Feb 2023, 10:03

Re: Database mapping for severity, priority, reproducibility

Post by Andre.Stuhrmann »

Dear Cas,

thank you very much.

For some reasons my file doesn't contain the reproducibility. Thank you for sharing the list.

Additionally, thank you in general for your help. It is well appreciated.

Best regards,
André
Post Reply