Displaying last note on view_all_bugs_page.php
Moderators: Developer, Contributor
Displaying last note on view_all_bugs_page.php
Hello,
I tried to customize our Mantis to met my needs and succeeded in most parts. I renamed and added new statuses, priorities, hid uneccessary fields (severity, reproductibility...) and so on... but I dont know how to display "last note" of issue as new column on view_all_bug_page.php. How do I do that? I tried with custom columns, but i don't think this is the way to solve my problem.
Please give me ideas how to display "last note" of issue on view_all_bug_page.php.
Thanks in advance ...
I tried to customize our Mantis to met my needs and succeeded in most parts. I renamed and added new statuses, priorities, hid uneccessary fields (severity, reproductibility...) and so on... but I dont know how to display "last note" of issue as new column on view_all_bug_page.php. How do I do that? I tried with custom columns, but i don't think this is the way to solve my problem.
Please give me ideas how to display "last note" of issue on view_all_bug_page.php.
Thanks in advance ...
Re: Displaying last note on view_all_bugs_page.php
I resolve this issue by myself. The solution includes modifing core Mantis files (filter_api.php) and some other minor changes in order to work with SQL Server 2008. Brief description:
I had to change file "filter_api.php":
- function "filter_get_bug_rows", where I added SQL CASE statement to retrieve last note or description for selected issue as "last_note". The idea is that i only need to add new columns with desired information in original SQL statement, to print these information in view_issues_page_columns.php...
- deleted "DISTINCT" word from all SQL queries in "filter_api.php"
Created in root directory "mantis" file "custom_strings.php", where I added entry:
$s_last_note = 'Last Note';
Changed file "columns_api.php" where i added new function "print_column_last_updated" where I remove functionality to sort issues for this column. This must be done in order to prevent sort error when user clicked on "Last note" link.
Then I go to Manage -> Manage Configuration where I modified configuration options for view_issues_page_columns. I added "last_note" to view this column on "view_bug_page.php".
I can provide more details how I did this, if anyone has interest.
I had to change file "filter_api.php":
- function "filter_get_bug_rows", where I added SQL CASE statement to retrieve last note or description for selected issue as "last_note". The idea is that i only need to add new columns with desired information in original SQL statement, to print these information in view_issues_page_columns.php...
- deleted "DISTINCT" word from all SQL queries in "filter_api.php"
Created in root directory "mantis" file "custom_strings.php", where I added entry:
$s_last_note = 'Last Note';
Changed file "columns_api.php" where i added new function "print_column_last_updated" where I remove functionality to sort issues for this column. This must be done in order to prevent sort error when user clicked on "Last note" link.
Then I go to Manage -> Manage Configuration where I modified configuration options for view_issues_page_columns. I added "last_note" to view this column on "view_bug_page.php".
I can provide more details how I did this, if anyone has interest.
Re: Displaying last note on view_all_bugs_page.php
I resolve this issue by myself. The solution includes modifing core Mantis files (filter_api.php) and some other minor changes in order to work with SQL Server 2008. Brief description:
I had to change file "filter_api.php":
- function "filter_get_bug_rows", where I added SQL CASE statement to retrieve last note or description for selected issue as "last_note". The idea is that i only need to add new columns with desired information in original SQL statement, to print these information in view_issues_page_columns.php...
- deleted "DISTINCT" word from all SQL queries in "filter_api.php"
Created in root directory "mantis" file "custom_strings.php", where I added entry:
$s_last_note = 'Last Note';
Changed file "columns_api.php" where i added new function "print_column_last_updated" where I remove functionality to sort issues for this column. This must be done in order to prevent sort error when user clicked on "Last note" link.
Then I go to Manage -> Manage Configuration where I modified configuration options for view_issues_page_columns. I added "last_note" to view this column on "view_bug_page.php".
I can provide more details how I did this, if anyone has interest.
I had to change file "filter_api.php":
- function "filter_get_bug_rows", where I added SQL CASE statement to retrieve last note or description for selected issue as "last_note". The idea is that i only need to add new columns with desired information in original SQL statement, to print these information in view_issues_page_columns.php...
- deleted "DISTINCT" word from all SQL queries in "filter_api.php"
Created in root directory "mantis" file "custom_strings.php", where I added entry:
$s_last_note = 'Last Note';
Changed file "columns_api.php" where i added new function "print_column_last_updated" where I remove functionality to sort issues for this column. This must be done in order to prevent sort error when user clicked on "Last note" link.
Then I go to Manage -> Manage Configuration where I modified configuration options for view_issues_page_columns. I added "last_note" to view this column on "view_bug_page.php".
I can provide more details how I did this, if anyone has interest.
-
- Posts: 1
- Joined: 04 Jun 2012, 15:03
Re: Displaying last note on view_all_bugs_page.php
Hi, matejp.
i have the same problem.
Can you to attach your file filter_api.php?
Giacomo
i have the same problem.
Can you to attach your file filter_api.php?
Giacomo
Re: Displaying last note on view_all_bugs_page.php
Hi,
Can you provide me the code to resolve this issue?
Thanks!
Toti
Can you provide me the code to resolve this issue?
Thanks!
Toti
Re: Displaying last note on view_all_bugs_page.php
Hi I would be interested in using this feature with our Mantis Setup at our organization.
Please share the detailed steps and the plugins if any?
awaiting your response.
Regards
Santosh S
Please share the detailed steps and the plugins if any?
awaiting your response.
Regards
Santosh S
-
- Posts: 68
- Joined: 06 Aug 2012, 18:13
Re: Displaying last note on view_all_bugs_page.php
I would love to know how to remove particular fields in Mantis that I do not need such as "Steps to Reproduce" amongst others.
EDIT - I have since figured out how to remove particular fields that I do not need such as "Steps to Reproduce" etc... in Mantis.
EDIT - I have since figured out how to remove particular fields that I do not need such as "Steps to Reproduce" etc... in Mantis.
Last edited by newmantisuser on 15 Nov 2012, 14:53, edited 1 time in total.
Re: Displaying last note on view_all_bugs_page.php
Hi, matejp.matejp wrote:I resolve this issue by myself. The solution includes modifing core Mantis files (filter_api.php) and some other minor changes in order to work with SQL Server 2008. Brief description:
I had to change file "filter_api.php":
- function "filter_get_bug_rows", where I added SQL CASE statement to retrieve last note or description for selected issue as "last_note". The idea is that i only need to add new columns with desired information in original SQL statement, to print these information in view_issues_page_columns.php...
- deleted "DISTINCT" word from all SQL queries in "filter_api.php"
Created in root directory "mantis" file "custom_strings.php", where I added entry:
$s_last_note = 'Last Note';
Changed file "columns_api.php" where i added new function "print_column_last_updated" where I remove functionality to sort issues for this column. This must be done in order to prevent sort error when user clicked on "Last note" link.
Then I go to Manage -> Manage Configuration where I modified configuration options for view_issues_page_columns. I added "last_note" to view this column on "view_bug_page.php".
I can provide more details how I did this, if anyone has interest.
could you please attach your file filter_api.php ?
Re: Displaying last note on view_all_bugs_page.php
Hi, matejp.matejp wrote:I resolve this issue by myself. The solution includes modifing core Mantis files (filter_api.php) and some other minor changes in order to work with SQL Server 2008. Brief description:
I had to change file "filter_api.php":
- function "filter_get_bug_rows", where I added SQL CASE statement to retrieve last note or description for selected issue as "last_note". The idea is that i only need to add new columns with desired information in original SQL statement, to print these information in view_issues_page_columns.php...
- deleted "DISTINCT" word from all SQL queries in "filter_api.php"
Created in root directory "mantis" file "custom_strings.php", where I added entry:
$s_last_note = 'Last Note';
Changed file "columns_api.php" where i added new function "print_column_last_updated" where I remove functionality to sort issues for this column. This must be done in order to prevent sort error when user clicked on "Last note" link.
Then I go to Manage -> Manage Configuration where I modified configuration options for view_issues_page_columns. I added "last_note" to view this column on "view_bug_page.php".
I can provide more details how I did this, if anyone has interest.
could you please attach your file modified files?
Re: Displaying last note on view_all_bugs_page.php
This user has not visited forum since 2010, so I think the chance is quite slim.
Would be nice with a simple tutorial from some devs on how to do add custom columns from SQL extracts.
Would be nice with a simple tutorial from some devs on how to do add custom columns from SQL extracts.
Re: Displaying last note on view_all_bugs_page.php
You should update the description of the plugin as it tells something about tags, but not last note.
Adds the Tags column to views in the Mantis bug tracker