Cannot see data in List view

[sleo]

Hello,
I just started playing around with SugarCRM a few weeks back for my company. I seem to be having a problem with a custom module I created. Any data I enter into the custom module, I am unable to view it in List view. Now I checked in the mysql database, and the information gets added to the appropriate table, so it is adding it to the database. Any suggestions will be greatly appreciated.

Currently using: openSuse/Apache2/PHP 5/MySql/SugarCRM 5.1.0

[andopes]

Hi sleo

Edit the file include/ListView/ListViewData.php and add this line

 echo "<LI>$main_query"; 
  

After the line

 $main_query = $ret_array['select'] . $params['custom_select'] . $ret_array['from'] . $params['custom_from'] . $ret_array['where'] . $params['custom_where'] . $ret_array['order_by'] . $params['custom_order_by']; 
  

Cheers

[sleo]

Thanks andopes. This gave me the sql statement the list view is using. Apparently one of the columns being selected is not in the database table. Will look through the custom module and see where it is coming from.

__________________________________
This is the Sql statement:

SELECT lgstu_stumodule.id ,
lgstu_stumodule_cstm.input_date_t_c,
lgstu_stumodule_cstm.pfl_registered_c,
lgstu_stumodule_cstm.pfl_source_c,
lgstu_stumodule_cstm.pfl_interviewer_c,
lgstu_stumodule_cstm.pfl_country_c,
lgstu_stumodule_cstm.lge_office_c,
lgstu_stumodule_cstm.direct_applicant_c,
lgstu_stumodule_cstm.pfl_visa_counselling_only_c,
lgstu_stumodule_cstm.pfl_scholarship_student_c,
lgstu_stumodule_cstm.pfl_middle_name_c,
lgstu_stumodule_cstm.pfl_dob_c,
lgstu_stumodule_cstm.pfl_month_intake_c,
lgstu_stumodule_cstm.pfl_year_intake_c,
lgstu_stumodule.pfl_id ,
CONCAT(IFNULL(lgstu_stumodule.first_name,''),' ',IFNULL(lgstu_stumodule.last_name,'')) as name,
lgstu_stumodule.first_name ,
lgstu_stumodule.last_name ,
lgstu_stumodule.salutation ,
lgstu_stumodule.title ,
lgstu_stumodule.phone_work ,
lgstu_stumodule.assigned_user_id
FROM lgstu_stumodule
LEFT JOIN lgstu_stumodule_cstm
ON lgstu_stumodule.id = lgstu_stumodule_cstm.id_c where ((lgstu_stumodule.assigned_user_id = '1')) AND
lgstu_stumodule.deleted=0
ORDER BY lgstu_stumodule.pfl_id ASC;


This is the error in mysql:
ERROR 1054 (42S22): Unknown column 'lgstu_stumodule_cstm.pfl_year_intake_c' in 'field list'

[sleo]

Works great now. Thanks again.
Apparently the year intake field is not being added to the database when I set it to Integer (but if I set it to Test, it works fine). Weird.