Page 1 of 1

Database mapping for severity, priority, reproducibility

Posted: 07 Feb 2023, 10:18
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é

Re: Database mapping for severity, priority, reproducibility

Posted: 07 Feb 2023, 10:43
by cas
checkout core/constant_inc.php

Re: Database mapping for severity, priority, reproducibility

Posted: 07 Feb 2023, 12:20
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é

Re: Database mapping for severity, priority, reproducibility

Posted: 07 Feb 2023, 14:59
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.

Re: Database mapping for severity, priority, reproducibility

Posted: 09 Feb 2023, 10:52
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é

Re: Database mapping for severity, priority, reproducibility

Posted: 09 Feb 2023, 12:11
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 );

Re: Database mapping for severity, priority, reproducibility

Posted: 09 Feb 2023, 18:40
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é