SharePoint 2007 Linked Sources and filtering

  • SharePoint 2007 Linked Sources and filtering TeckniX

    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? ;)


  • 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!


  • You may find this javascript based filtering solution to be useful

    SharePoint InstantListFilter

sharepoint-designer filter libraries
Related questions and answers
  • I'm having this issue on several server environments. We have a list at the site collection root. There is a site column created as a multi-value lookup on that list's Title field. This site column is used in document libraries in subsites as a required field. When we upload anything but an Office 2007 document, the user is presented with the document metadata fill-in screen (EditForm.aspx... for the lookup field is null. It smells like a SharePoint bug to me - but before I go calling Microsoft, has anyone seen this & worked around it? Edit: the only entry I see in the SP trace logs relating

  • Did anybody tried Filtering Linked Data Sources using the QueryString as paramters in CAML (Select Command) and not XSLT filters AggregateDataSource with Parameter <DataSources><..." DataSourceMode="List" UseInternalName="true" selectcommand="&amp;lt;View&gt;&amp;lt;Query&gt;&amp;lt;Where&gt;&amp;lt;Eq&gt;&amp;lt;FieldRef Name=&amp;quot;ID&quot;/&amp;gt;&amp;lt;Value Type=&amp;quot;Counter&quot;&amp;gt;{ID}&amp;lt;/Value&gt;&amp;lt;/Eq&gt;&amp;lt;/Where&gt;&amp;lt;OrderBy&gt;&amp;lt;FieldRef Name=&amp;quot;PublishedDate&quot; Ascending

  • /. I have contradictory observations: When John adds an item to the library while working from W2, the workflow is initiated but goes to Stopped status, and the other list is not updated. When John...Using WSS 3.0 running on SBS2008. I have an Infopath form library, to which I have used SharePoint Designer 2007 to attach a custom workflow. It's a pretty normal workflow which updates a property in another list based on a lookup. I have two users, call them Jane and John. Jane is a member of several SP groups, one of which has Full Control permissions. John is a member of a couple of SP groups

  • asking to either keep, move, or delete this instance (number 31) does not show up. I've tried the following things: Removing the "Series Items in the both the doc library and the pages folders from SharePoint Designer... prolly not the wisest move, but it had worked before. Tried tricking the system by issue the following url request: http://myserver/en/mydep/mymeeting/Lists/Meeting...So, a meeting workspace was created. Subsequent meetings then where linked to the workspace, one by one, as the meetings where scheduled. At some point the organizer deleted "something

  • So I did create on an SPWeb 20 custom lists and then a tasks list. For each of those 20 lists I've created 20 site lookup columns. I then created 20 Content Types based on Task content type. Then I've added each content type to the Tasks list. After that I've added each lookup site column to the corresponding list content type. So far so good. I've built a custom WebPart that displays task items... columns. If I put in the FieldRef the internal name for lookup column no 14 or above, it is not working anymore. Why? If I don't use LookupId='TRUE' and do this: (use the value of the lookup

  • , a new item added to the lookup list, as expected, but the content type of new item is always "Folder" instead of normal "Item". I have tested my field with different types of list but there is no issue... available next time in the drop down. To achieve this, I am first checking the value in lookup list. If value exists then I just return the normal "ID;#Value" otherwise; I first add the new text value to the target list and then return the newly added item's "ID;#Value" pair. My Field is working fine if I add it in any list where "Folder" is not a default content type. For example, I can create

  • I'd really like to prepare development environment for Sharepoint 2010. This is what I did: I installed Windows 7 x64 I installed VMWare Workstation Created a VM domain controller based on Windows... (Windows6.1-KB974405-x64.msu) Enabled all roles indicated in the list (IIS and WCF) Installed Sharepoint Foundation 2010 didn't run the product configuration wizard (yet) created two additional domain user accounts..." -AsPlainText -Force) When I run it, I'm prompted for database credentials and I enter mydomain\SPF_DATABASE and password I'm also prompted for farm credentials and I enter mydomain\SPF_ADMIN with password

  • happening. When I activate ContentTypes, the content type and field are deployed as expected into my site collection. When I activate Registration, the list is provisioned and the content type is added as expected. When I try to add a new item to the list, the list form only shows the Title field from Item. Now, here's the weird part. If I add a second content type to the list (through the UI...I've encountered the strangest problem. I've got two features: ContentTypes: contains a couple of custom fields and a content type (based on plain ol' 0x01) called Withdrawals that uses them

  • I have an odd thing happening that I can't explain and I wondered if anyone could offer some insight. I have a site with x number of Picture Libraries, and I'm using a DVWP to display a list of all of the libraries with links to them, call it an automatic navigation list so that when you make a new one it automatically shows up on the list. The issue I have is that the ListProperty.Title value...;&amp;lt;/ViewFields&gt;&amp;lt;/View&gt;" id="dataformwebpart2"></SharePoint:SPDataSource></DataSources> <datafields>@ListId,ListId;@WebId,WebId;@ID,ID

Data information