Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Sharepoint List Filters

  Asked By: Madhu    Date: Jan 08    Category: Sharepoint    Views: 2461

I'd like to filter a sharepoint list view of tasks to only show items
for the "current payroll cycle", which is a calculation based on the
current week (Friday 5PM + 7 days).

Currently I can sort of do this with custom columns on the table that do
calcuations on current date, but this requires each task be updated each
day since [Today] isn't officially supported (I'm using the "create a
Today column and then delete it" hack). I also have to keep a bunch of
columns that contain bits of the calculation to determine the current
payroll cycle (julian days etc).

It seems to me a incredible shortcoming of sharepoint if I can't do
advanced filtering on a list based on current day. Can I create a filter
in sharepoint desinger that could do this? I basically just want a SQL
query kind of like this....

select taskname, duedate, priority, complete% from sharepoint_task_list
where duedate BETWEEN *calculation of friday before sysdate* AND
*calculation of friday before sysdate + 7*

Is this possible in designer? I've heard there's a query language called
CAML for sharepoint, but does that require custom code to use?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Uttam Vanjare     Answered On: Jan 08

I seem to have found a "solution" here:

blogs.msdn.com/.../filtering-an
d-formatting-with-date-values.aspx

However, it seems to me that MS really needs to work on a better
filtering mechanism than the current  one, since the author of the
article wrote a bunch of custom  XSL to simply filter  by a date  range! No
easy way for users to do any kind  of complex date filtering  without
involving a dev.

 
Didn't find what you were looking for? Find more on Sharepoint List Filters Or get search suggestion and latest updates.




Tagged: