Custom Button in Reports

The issue you're encountering with row.getFieldValue("fkJobId"); not returning the field value in a report view, while it works fine in a list view, could be due to the way PHPRunner handles data in different views.

Potential Reasons and Solutions:

1. Field Accessibility:

   • In report views, the data may not be structured the same way as in list views. Ensure that the field fkJobId is actually available and populated in the context of the report. You can check this by logging the available fields in the row object.
   
   

   console.log(row);
   

2. Row Object:

   • The row object in a report view may not contain the same methods or properties as in a list view. You might want to check if row is defined and if it has the expected structure.
   
   
   
   

3. Check Field Names:

   • Ensure that the field name fkJobId is correctly spelled and matches the name used in your database and PHPRunner configuration. Sometimes, discrepancies in naming can lead to undefined results.
   
   
   
   

4. Use getFieldText:

   • If getFieldValue doesn’t work, you can try using getFieldText to see if it retrieves the value correctly. However, this will return the displayed text rather than the actual value.
   
   

   var pkeys = row.getFieldText("fkJobId");
   

5. Debugging:

   • Add debugging statements to see what the row object contains in the report context. This can give you clues about what fields are available.
   
   
   
   

6. Alternative Approach:

   • If the above methods do not work, consider creating a custom SQL query for the report that ensures the desired fields are included.
   
   
   
   

Example Debugging Code:

You could modify your code temporarily to include some debugging information, like so:

var pkeys = row.getFieldValue("fkJobId");
console.log("fkJobId Value: ", pkeys); // Check if it returns the expected value
console.log("Row Object: ", row); // Inspect the entire row object

var win = Runner.displayPopup( { 
 url: "jobs1_edit.php?page=editjob&editid1="+pkeys,
 width: window.innerWidth-10,
 height: window.innerHeight-10,
 header: '<a href="#" onclick="window.win.close();return false;">.</a>',
 afterCreate: function(popup) {
 window.popup = popup;
 }
});
return false;
Conclusion:
By following the above steps, you should be able to determine why the fkJobId field is not returning a value in your report. Make sure to check the structure of the row object and verify that the field is available in that context. If necessary, adjust your approach based on what you find during your debugging process.

Reports are a special kind of creatures and every single line in reports can be an aggregated value coming from multiple database records. This is why the kind of functionality you looking for is not available in reports and in this specific situation you need to use a regular table.