Archive for the ‘Filter’ Category

New SharePoint FilterPoint web part – public beta released

Date:November 1st, 2010 Author: Tags: , , ,
Category: Filter, General, SharePoint webparts Comments:0 ;

FilterPoint SharePoint webpartWell finally, after months of hard work we are delighted to be able to let you know that we have just released our new FilterPoint web part for SharePoint in beta.

FilterPoint has been a long time coming so we hope you are going to like it.  It’s a tool that we always knew we wanted to develop. Dynamic filtering  – the ability to flip between filter values at the click of a mouse – is one of the building blocks for the kinds of rich applications that our customers like to build for themselves.  It builds on the power of webpart connections (a much neglected area in SharePoint) and once you have the ability to apply a group of filters to a page with a selection of webparts and lists you have the potential for some really nice dashboards.

But, as I said FilterPoint has been a long time coming, because what started out looking like a straight forward project turned out to be anything but . . . .

It starts off looking ever so simple with plenty of online examples – but when you start delving into the details it quickly becomes the stereotypical “Can of Worms” project.

There are basically two interfaces you can use – one old IFilterProvider interface , and the new ITransformableFilterValues interface. So far sounds easy but how about some wildcards….

With the new ITransformableFilterValues interface – you can’t create filters dynamically,  and you can’t have multiple connections on the consumer side in SP 2007.

On the other hand, with the old IFilterProvider interface you can’t send multiple filter values to List view web parts and you can’t connect more than one provider web part to a consumer web part. And that’s just scratching the surface.

To top it all off you have little control over what the filter consumer web part actually does with the info you give it – want to say “Equals” or “Not Equals” or “Greater Than” etc and thats out of the scope of what a filter provider can do (we’ve got some ideas on how to work around this in a future version of FilterPoint though).

My oh my, enough to make your head spin!

FilterPoint Webpart, filtering optionsAnyway- we’ve worked really hard to make this web part as simple to use as possible whilst still being compatible with any web parts that can accept the standard web part connections.  We have managed to come up with a tool which allows you to apply multiple filters to multiple webparts and lists, and (at least when working with our Planner and PivotPoint) you can have some control over the operator – using “not equal”, “greater than” and “less than” as well as the standard “equals”.  We hope to extend this aspect of the functionality in v2.

So, why might you want to use this thing then?

Well, you might want to use simply it to guide your users to the most relevant data in one list or webpart – giving them the ability to “filter on the fly”, selecting new data sets, and then clearing filters in one click.

Or, at the other extreme, you might want to bring together a collection of lists and web parts on one page, and use FilterPoint to create a truly dynamic dashboard for your users.

In fact, once you start to use filters and webpart connections there are any number of different ways to enhance the functionality of your SharePoint site with a tool like FilterPoint – we already have it set up on our Sales Pipeline and Client lists here, and are finding more possible uses every day.

We are planning to have FilterPoint ready for full public release by the end of the month.  In the meantime, if you pre-register for your free trial, you will qualify for a 25% discount on the product purchase price.

We hope you like it, and as always, we are keen to hear your thoughts and feedback.

Filterpoint Download

How To setup a SharePoint view filter to compare 2 list fields

Date:June 1st, 2010 Author: Tags: ,
Category: Filter, SharePoint Ideas Comments:2 ;

There are many instances where you might want to view a set of SharePoint list records which have been filtered on a comparison between values in 2 columns.  You might want to view a list of all sales reps who have failed to hit their targets: Actual SalesCredit Limit, or employees who have not used their full vacation entitlement: Vacation Entitlement>Days taken.

A customer recently contacted me with just this type of question :-

They use a SharePoint list to keep track of orders waiting to be manufactured and delivered – so amongst other fields they have Scheduled Delivery Date (which they have promised to a customer) and the Estimated Delivery Date which is kept up to date with the latest estimate. Most of the time the two agree but sometimes for various reasons the delivery date slips.

They have been using Reminder to send out automated emails for upcoming orders and ones that had just been missed but they wanted to setup a view that would show only orders where the Estimated delivery date was later than the date they had told the customer. Account managers could then use this list to keep customers up to date – “There is a delay on that order we have scheduled for you for next month, we estimate it will be ready on the 17th”

Sounded pretty simple to me and I confidently told them how they could do it (more…)

Use SharePoint Filtered Views to Stop Sending Alerts to Yourself

Date:April 19th, 2010 Author: Tags: , , , ,
Category: Filter, General, SharePoint Alert, SharePoint Ideas Comments:0 ;

How annoying is it when you have just created or amended an item in SharePoint, and you immediately get an Alert email about it?

You know the kind of situation: you might be working in a team list, you have the list set up to alert you when an item assigned to you is added or amended, so as soon as you add or amend an item yourself an alert email pings through to your inbox. Completely unnecessary inbox clutter.

So, lets switch off those annoying “alerts to myself” – has to be an easy one click operation, right?


How To Use Filters in SharePoint to show items in the current Calendar Month

Date:November 26th, 2009 Author: Tags: , , ,
Category: Calculated Columns, Filter, SharePoint Ideas Comments:209 ;

Its very easy using the Filter feature of SharePoint views to show only items completed in the last 30 days or items due in the next X days; for example :-

Completed >= [Today]-30

On the Advanced SharePoint View and Filter techniques post Ed asked how you could filter for the current calendar month rather than a rolling 30 day period (for example all tasks due this calendar month).

Like all great questions it seemed simple enough – something like only showing items where the Month and Year of the due date = the Month and Year of the current date.


Tip – Sending an SharePoint email Alert when a Task is completed

Date:October 16th, 2009 Author: Tags: , , , ,
Category: Filter, SharePoint Alert, SharePoint Reminder, SharePoint webparts Comments:0 ;

Victor from New York asked

Is there a way to configure a Reminder webpart to send an email when task item status in the task list is set to “completed”?

Sure there is!

In this case the trick is to use a SharePoint Views to filter out the tasks you are interested in.


Tip – don’t send SharePoint email alerts for old items.

Date:October 16th, 2009 Author: Tags: , , ,
Category: Filter, SharePoint Alert, SharePoint Reminder, SharePoint webparts Comments:0 ;

There are some scenarios where you could setup Reminder to generate emails alerts in a simple workflow scenario such as such as when a Task is completed,  a helpdesk ticket is closed, a company announcement is made, a vacation request or expenses claim is approved and so on.

When you first set up this kind of reminder, an email alert for any records already in this state (e.g. completed tasks) will also be sent and some of these could be quite old, so you could end up sending quite a lot of “old” reminder emails.

If you want to avoid sending emails for these old records you have 2 options:

  • Use the Redirect Emails function to redirect the emails to yourself the first time its ran, delete these and then remove the redirect

This also gives you the opportunity to double check that everything is setup correctly.

  • Use a view to filter out old records

For example you could filter to show only records with an ID > a recent ID.

Or you could add filter to show only records Created after a certain date.

Tip – All records in SharePoint have an ID and its sequential and automatically generated. To find the id you can show the ID column in your view or see the ID in the URL in your browser address bar.

SharePoint Reminder Webpart Free Trial Dowmload

Filterpoint Download

The … ehem… Truth about using [Today] in SharePoint Filters

Date:November 25th, 2008 Author: Tags: , ,
Category: Calculated Columns, Filter, SharePoint Ideas Comments:12 ;

Back in the day of Windows SharePoint Server 2 and SharePoint Server 2003 you couldn’t use [Today] in Filters.

For example if you tried to setup a filter like this to show items added in the last 7 days

"Filter value is not in a supported date format"

Created is greater than [Today] - 7

Created is greater than [Today] – 7

You would receive an error “Filter Value is not a valid date” when clicking OK


Advanced SharePoint View and Filter techniques

Date:October 26th, 2008 Author: Tags: , , ,
Category: Filter, SharePoint Ideas Comments:119 ;


We discussed in a previous article how to customise SharePoint’s built in Task List and briefly looked at the power of Views with Filters. In this article we will build upon that by demonstrating some advanced use of Filters.

This article assumes that you are already familiar with Views and Filters – if not please review the previous article.


Extend and customise SharePoint Task lists

Date:October 26th, 2008 Author: Category: Filter, SharePoint Alert, SharePoint Ideas Comments:13 ;


One great feature of SharePoint is the ability to extend and customise the built in List types (such as Announcements, Contacts, Issues and Tasks) to meet your requirements. In this series of articles we will give you some ideas on how you can modify a task list to meet the needs of business processes you have in your organisation.