List of Cool Mods completed

**crmdaddy** · 2008-06-17, 10:58 AM

Hi all,
Just want to share the wonderful things that you can do with SugarCRM.

List of cool Mods to version 4.51 CE. We didnt use 5.0 due to "beta" email client.

1. Team based Inbound Group Email. Only User on the same team can read and see the email. Take From Group is also filtered by team. All email listviews are filtered accordingly.

2. Email notification when a new case is created or selected status change.

3. Time calculation in case module - e.g response time, resolution time, etc

4. New Assets module linked to Problems

5. Mutiple Order By column and sort orders on Saved Search, instead of just One sort column.

6. Dashboard charts on Cases.

7. Auto populate email address fields - To and From field depending on scenarios.

... etc etc etc etc

8. Footer check cracked on both 4.51 and 5.0 - however we did that for fun only. Power by sugar and copyright footer were left intact because we feel that without Sugar, we dont have anything to start with and credit must be given.

Daddy is cool ....

P/S : Sugar shouldnt spend time on coding the footer checks. Instead, should make the above mods standard in the CE.

Thanks sugar!

**eggsurplus** · 2008-06-17, 04:51 PM

I love the multiple order by feature! How did you go about doing that?

**SugarDev.net** · 2008-06-17, 04:56 PM

That's a great one indeed!

In SQL it's just

[code]ORDER BY column1, colum22[code]

..so I guess it's not that hard to implement

**eggsurplus** · 2008-06-17, 06:37 PM

True, I'm wondering how they handled the GUI side of it more than anything. Maintain the sort order indicators, how to clear out the sort order (probably just clear), etc.

**SugarDev.net** · 2008-06-17, 08:56 PM

Well, out of my head:

- there are 2 sorting variables, 1 optional
- everytime a sort link is clicked, the current first is called second, and the clicked one is called first
- make a check for the existence of the second one in ListView class, and insert SQL
- save everything in the user_preferences table, using new names for sort2
+you need some means of displaying this fact to the user..

**crmdaddy** · 2008-06-18, 01:37 AM

well it is really not that hard once u got the flow right. Look at the picture attached. Triple sort preferences are also saved with saved searches. All 3 sorts are optional.
Just extend the single sort to triple sort ...