Hi Hardev,<br><br>To add more fields to 'Activities' or 'Acitivity History' in the related list of any module, you will have to change the $list_fields array in modules/Calendar/Activity.php<br><br>And the queries to add new column to <module>_cf table is handled in the file modules/Settings/AddCustomFieldToDB.php file and the line of code that actual does this, is as follows:<br>
<br>$adb->alterTable($tableName, $columnName." ".$type, "Add_Column");<br><br><div><span class="gmail_quote">On 3/5/09, <b class="gmail_sendername">Hardev Bassan</b> <<a href="mailto:Hardev.Bassan@warwick.ac.uk">Hardev.Bassan@warwick.ac.uk</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
All,<br> <br> I would like to display some more database fields from the activity database (For example - fields duration_hours and duration_minutes) in the potentials -additional information - activity History area.<br> <br>
Can you suggest what files and code I will need to change to get this affect. example please.<br> see attached pdfs<br> <br> Also, when I add a new custom field to a module, I can see the additional change in the xXX_CF table. But, when I search for relevant strings in the source files under htdocs - I don't find any other than in the logs (because debug is enabled). I am using windows XP to do the search.<br>
<br> Where are the new code related to the additional field in the _CF table.<br> Help!<br> <br> Regards<br> <br>Hardev<br>_______________________________________________<br> Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com">http://jobs.vtiger.com</a> <br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Regards,<br>Asha<br>vtiger Team