SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've created a couple of linked sources before by following different tutorials and have always had pretty good luck with them.

One issue did come up and I've been stumped on it! I've joined (tried merge also) 2 different sources:

  1. Item list
  2. Document library

I've got one of the columns of the document library matches the column of the item list (it's actually a lookup) I can query and filter correctly without any problem. The issue comes when I try to filter by column headers. Usually I'm able to get a dropdown with 'suggested' column filters. When you join the tables, this is no longer available and you end up having only a A-Z, Z-A sorting.

Why is this broken? Is this a sharepoint bug or simply inadequacy at doing a lookup on the dropdown?

I've managed to capture the url used in the iframe: _layouts/filter.aspx?ListId={YOUR-LIST-ID}&FieldInternalName=DocIcon&ViewId={YOUR-VIEW-ID}&FilterOnly=1&Filter=1

I can't seem to capture the one that get's sent though when the datasource is a join of 2 different lists. The question is has anyone successfully enabled the column header filtering and obtained the 'suggested' filters when 2 datasources were used? If so, well how? ;)


share|improve this question
up vote 0 down vote accepted

It seems that no answer could be found for the above. I simply went another direction by using the javascript API to get something close to what i needed. If anyone feels like they have more to add, then please add a comment!


share|improve this answer
@TeckniX: Something that might help next time is if you edit your question with more info on what you've tried or perhaps some reformatting. The system will then display it on the home page of the site and catch more eyeballs. – Alex Angas Mar 15 '10 at 22:34

You may find this javascript based filtering solution to be useful

SharePoint InstantListFilter

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.