MySQL Bugs: #31645: "Custom Fields" -> "Display on List Issues Page" doesnt work properly

Bug #31645	"Custom Fields" -> "Display on List Issues Page" doesnt work properly
Submitted:	16 Oct 2007 17:21	Modified:	28 Mar 2008 3:48
Reporter:	Grzegorz Sterniczuk	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Eventum	Severity:	S3 (Non-critical)
Version:	eventum-2.1-0.261.r3377	OS:	Linux (PLD)
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	custom fields

Description:
Then I set my own Custom Field, there is no possibility to view it anywhere else than in "Create Issue" page. If I set "Display on List Issues Page" to "Yes" and for example set my custom field on 2 position in "Manage Columns to Display", then "List Issues" display strange table.

How to repeat:
Set your own Custom Field.

Hi,

I am unable to reproduce this. Can you send me a screenshot of your list issues page and your "edit columns to display" page?

/bryan

Manage columns to display

Attachment: zrzutekranu-Eventum - Mozilla Firefox.png (image/png, text), 182.83 KiB.

Manage custom fields

Attachment: zrzutekranu-Eventum - Mozilla Firefox-1.png (image/png, text), 192.73 KiB.

My Assignments with custom field

Attachment: zrzutekranu-List of Issues - Eventum - Mozilla Firefox.png (image/png, text), 172.43 KiB.

My Assignments without custom field

Attachment: zrzutekranu-List of Issues - Eventum - Mozilla Firefox-1.png (image/png, text), 163.90 KiB.

Hi,

I am still unable to reproduce this problem. I have duplicated your setup exactly from the screenshots and everything works normally.

On list.php, after line 107 add this:
echo "<pre>";print_r($list);echo "</pre>";

This is output from echo "<pre>";print_r($list);echo "</pre>";

Attachment: ble.txt (text/plain), 8.33 KiB.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Sorry for the delay in response, I have looked at this several times and not seen anything new but I finally spotted something that looks out of place. Can you apply the following patch and send the results?

Index: include/class.issue.php
===================================================================
--- include/class.issue.php     (revision 3541)
+++ include/class.issue.php     (working copy)
@@ -2501,6 +2501,7 @@

         // get any custom fields that should be displayed
         $custom_fields = Custom_Field::getFieldsToBeListed($prj_id);
+        echo "<pre>";print_r($custom_fields);

         $stmt = "SELECT
                     iss_id,
@@ -2706,6 +2707,7 @@
                 if (count($custom_fields) > 0) {
                     $res[$i]['custom_field'] = array();
                     $custom_field_values = Custom_Field::getListByIssue($prj_id, $res[$i]['iss_id']);
+                    print_r($custom_field_values);
                     foreach ($custom_field_values as $this_field) {
                         if (!empty($custom_fields[$this_field['fld_id']])) {
                             $res[$i]['custom_field'][$this_field['fld_id']] = $this_field['value'];

Array
(
    [2] => Osoba zgłaszająca
)
Array
(
)
Array
(
)
Array
(
)

I have 3 assignments.

The problems is Custom_Field::getListByIssue() does not return any values. You will need to add debug information to this method.

It is most important to get the output of the main query.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".