CiviCRM Community Forums (archive)

We're wondering if anyone has implemented, or plans to implement a filter for activities on the contact activity tab. We are finding after a few months that individual contacts activity lists become very long so finding something becomes quite difficult. It would be great to have a filter drop down by activity type in order to help find the activity you're looking for?

Let me know if anyone has implemented this or thinks they could implement into the system - would be a useful thing to add to core I think?

I added a sort+filter on the client side with a nice jquery datatable.

Kurund is working on that tab for the next version, can't recall what it is, might be around that.

X+

No. Its currenty not on the short/medium term roadmap

if important to your org, please consider contributing code and/or sponsoring a developer to do the needed work

lobo

The developer intro chapter gives you a fair amount of info and guidance on how to locate the files involved in rendering a page.

I dont think u can do it with hooks

To a large extent it depends on how simple / complex you want the filtering to be. Seems like it could potentially be a modified version of the "find activities" function (and potentially complex). on the other hand you could add a simple form with status id's and activity type id's and reload the page with a filter on those

lobo

xavier: Can you share what you did with your client side approach?

Yeap, quick and easy: modified the template to use datatables
http://www.datatables.net/

You still load all the raws, but they are now searchable/sortable

check, I think the plugin is now part of civi

X+

cool, thats quite awesome. Thanx for pushing this forward

A few thoughts:

I dont think getting rid of the pager is a good idea. If you have lots of activities / contact, loading all of them in the browser might take too long / consume too much memory / does not scale

I think improving the code at the backend to take "activity type" as a filter from the GET params and then filtering it at the mysql query level is a more scalable approach. So basically the select box, calls back to the server and filter it with the activity type.

Ping us on IRC, we can help you with it and potentially even "fix" the query to do the right things. I think u've made some great steps forward and with these changes we can get it into core for 3.4 / 4.0

lobo

And online "chat"

http://webchat.freenode.net/?channels=#civicrm

type any phrase with "dlobo" on it, and he will get a pop-up that you try to contact him and so you can chat.

If you need to add extra pagination filters for the list of activities (and filter by activity type) can you extend
CRM_Activity_BAO_Activity::retrieve so we can re-use that logic in the api too ?


X+