dashlets - tasks filter question

[dcbour]

How would I create a filter such that any non-completed items that either have no due date, past due or due within the week are shown. Today, I can pick no filter or due in a specified period...Thanks in advance
D.

[mycrmspaceclemens]

How would I create a filter such that any non-completed items that either have no due date, past due or due within the week are shown. Today, I can pick no filter or due in a specified period...Thanks in advance
D.

Hi

You need to know to write or modify a dashlet. Check the Wiki for a start http://www.sugarcrm.com/wiki/index.php?title=Dashlets

Cheers

[roblaus]

Hi,

As a work-around: Put more than one task dashlet on your homepage. You can set the title for each of them and set different filters. It's not a beautiful solution (an SQL based view would be much better) but it works...

rgds
rl

[dcbour]

My first solution....

I've patched the following files...note documentation is not my strong point...

This changes apply to version 4.5.0f.

modules/Home/language/en_us.lang.php
include/generic/SugarWidgets/SugarWidgetFielddatetime.php
cache/jsLanguage/Home/en_us.js

I'm guessing the cache file regenerates via a process, but in the event that it doesn,'t, I've uploaded a copy too renamed with a .txt extension so it would upload.

Essentially, added a new Due In 7 days filter built off the logic of the "in 7 days" filter shown...which is a between today and today + 7 days....new filter searches on < today + 7 days (which also gets overdue items) OR is null (gets items without due dates).

Files are attached..do a search through it for "DUEIN" to find my specific mods...

Hope someone else finds this useful...
If you want questions or clarification...like I know what I'm talking about... ha ha ha ...drop a line....via private message or reply here as I'm set to receive notice of replies via email, etc.

Dave.

P.S. Great job to all who've contributed here so far..one of the best OS projects I've come across yet.
D.

[leenwebb]

Hi Dave,
Thanks for putting up your solution here -- it's nice to find a thread with an ANSWER, instead of just another person pointing to the wiki! (I don't mean that to sound snotty... I'm just glad to actually have a solution.)


Eileen

[dcbour]

Thanks, but this was really an easy fix. Just glad I could contribute.