Problem: infos at company-detail view

[mike2009]

Hello,

I have some problem in "customizing" the shown infos.

1. Company detail view

below are all registers with several informations, i.e. contacts, projects ...
One info-block is activities(maybe it is called history in English version) (in German: Verlauf)

I see there notes, calls listed.

My problem is, these informations are sorted by "date of change".
I created via Studio a own field called "Ereignis", the date, when this action was performed.
I can insert this field in every form of "calls", but where can I change the fields for this info-display ?

Sorting by "date of change" is not useful for a history, because infos are not always stored "on the fly".

I hope you can understand what I mean.

Thanks for any helpful hint.

Mike

[roblaus]

There are at least 50 threads re. this topic, if I remember correctly there is even one with sort of a code sample. This has to be done in the code because the history panel is not a "normal" subpanel but aggregates three different tables.

[mike2009]

Thanks.
Of course, I tried out several hints I found in the topics here.
Nothing works, also some procedures I found in DevGuide didn't work.

I know about the special construction of history-subpanel.

I got 3 different resultes:
1st: nothing happened, no changes where seen on screen
2nd: sql-error (.... in ORDER BY statement
3rd: I didn't see any subpanel at contacts, but no error, also in php errorlogfile on server no entry

I changed (like described in forum) forhistory.php-files of all 5 components in history.

My issue is:

contacts detail-view
-> subpanel history

I added to all forms of the 5 modules a custom-field calles event_date_c.
This should represent the date, when the action (call, note ...) happened.

In the history-subpanel I want to SEE this user-field and I want to SORT by this field.

This user-field I inserted in the php-files, I also changed the sort-criterias.
I rebuild all relationships.

I never got the vorrect effect.

My best result was: the - by default - displayed field date_modified was empty on viewlist and no error occured.

I am not a PHP-profi, but I understand php, can write compact scripts.
But I do not understand the global structure of sugar.

Can anyone gibe me another sorce where I can read informations about my request ?
(maybe also a link here in forum. Several searches bring up 12 to 32 pages - I read mostly the top 10)

Thanks.
Mike