0
votes
0answers
15 views

Due in next 90 days filter in a data view

I'm making data views and for a couple of them I want to filter to show any items that are due within the next x amount of days. My immediate thought was to filter by Current Date + 90. I've done ...
0
votes
1answer
19 views

Cross referencing with Dataview webpart

Oh man I must be losing my mind but I can't for the life of me figure this out. I have a list called "Stuff" and a library called "Stuff documents". "stuff documents" has a lookup column to the title ...
0
votes
2answers
87 views

Multiple Filter Dropdowns on a webpart page

I am looking to set up three dropdowns at the top of a web part page that will allow the user to choose Week#, Region and Site in order to show a specific item (or items) from a Sharepoint custom list ...
0
votes
1answer
506 views

Filter Data View Webpart based on results of javascript query

I'm trying to dynamically filter the records that a Data View WebPart displays based on the return value of a javascript query. I would like some advice as to how I should do this or if it's even ...
0
votes
0answers
54 views

Modifying CAML to filter by passed parameter

I have a list which contains a column called "Actual Start Date". I want to filter this list at the users command to only select the date they have selected. I have created a parameter called "Start" ...
1
vote
0answers
208 views

SharePoint 2010 Data view web part filter values show all items when page loads

I prepared the data form web part with data source as SQL table on the page. On the same page, I created another list view webpart which contains items as parameters to filter SQL data through ...
0
votes
1answer
532 views

Unable to create valid SPDataSource Select Command

I am to use SharePoint Designer, no custom c# code. Currently using a SharePoint:SPDataSource on a DVWP to show a list. When the SelectCommand is blank it works fine but I will need to create dynamic ...
0
votes
1answer
1k views

SP2010: Filter list in a WebPart by Contains not Equals (adding a wildcard)

This question isn't new here, but after reviewing existing posts I still need your advice. If I need to "search" list data using a wildcard, I have to modify the XSL code. A step-by-step instruction ...
1
vote
2answers
822 views

XSLT filter for Yes/No Column/Field in SharePoint Custom List for SharePoint Designer DataView WebPart

I'm trying this with no luck: [@ActiveStatus='Yes'] also tried 1, '1', 'True' .. get no rows back.. If I remove the filter I get back all rows. full line in code view looks like this: ...
0
votes
1answer
156 views

How to filter datview to show data from last year and current year in SharePoint

I have a dataview web part displaying data from a list which I've designed using SharePoint designer. How do I filter it so that I show data from last year as well as the current year? Note: It ...
0
votes
2answers
342 views

Capture filter value, within xslt, passed in from connected web part

Is it possible to get hold of the value of a filter being passed in by a connected web part? For example, if a sharepoint list filter is sending a filter value of "1" to webpart A (a dataview ...
1
vote
2answers
354 views

Filter Library with parameter

I am an intern at a company, so I am not completely sure about the structure of the servers etc. However, I have a library that I want to filter by the department that the currently logged on user is ...
0
votes
2answers
707 views

Send Paramets from HTML form to DVWP via javascript

Good day! I have a DVWP. DVWP has parameters as query string "StartDate" and "DateEnd" and filters on datefield "Date" by parameters "StartDate" and "EndDate". Also I have form on the page with ...
0
votes
1answer
329 views

Filter Data View with SOAP Query as Source

I am creating a printable company directory. I have a SOAP Service query that pulls everyone's data from the search service. The query returns all the results I want. I have enabled the "Sort & ...
1
vote
1answer
834 views

Calendar DVWP to show only today with recurring and all day events

I got a interesting problem here. I developed a dashboard for one of our departments, they wanted a widget that shows only today's events. I have the DVWP in place, and filtering by a calculated ...
1
vote
1answer
694 views

How can I Filter a Joined DVWP by [Current User] in Multi-User People/Groups field?

I have a joined DVWP. List A includes a "category" lookup field among other columns. List A includes the same "category" lookup field as well as a People/Groups field with multiple selections. I'd ...
2
votes
0answers
221 views

DVWP ASP.NET Filter for all pages

I have created a drop down along with DVWP as described in http://social.technet.microsoft.com/Forums/en-US/sharepointcustomization/thread/949d4443-58a4-464b-9603-e4c280740650. However I see one ...
5
votes
1answer
5k views

Can I Filter a List/Data View using Contains instead of equals in SP2010?

I have a page where I am using a Text Filter to filter a long (15K) list of clients in a Business Data List web part. The filter works fine for All and for an entered name, so long as the full name is ...
4
votes
1answer
2k views

Dynamically setting Default Value in ParameterBinding through Javascript

To make a long story short (too late), we have a dropdownlist that is populated through a list of items. We want to use this dropdownlist to filter the list in a data view web part. This works ...
1
vote
1answer
628 views

How do I use a javascript variable in the Filter Criteria for a DVWP?

I am converting some numbers using Javascript and need to filter a list using these conversions. I cannot do the conversions within SharePoint itself, so I had to use Designer and some Javascript. I ...
0
votes
1answer
260 views

How do I set up a greater than filter by using a Form Web Part?

I have a list that needs filters of greater than and lesser than an entered date. I can connect the form web part to return the same date, but I need it to return the dates greater than or equal to ...
4
votes
2answers
1k views

How to limit a Data View Web Part to 1 Item Per (Most Recent)?

I have a DVWP that I need to set up a complex filter on. It WAS all set - grouped by category field, sorted by item title, then filtered on 2 other fields (year & quarter). Then I was given ...
1
vote
1answer
542 views

How to Group DVWP Rows by a Joined Source Field?

I have a joined data source of 2 sharepoint lists and am trying to group by category and setup conditional formatting, yadda yadda yadda, in a DVWP using various fields within these lists. I'm able ...
0
votes
1answer
622 views

How do I filter on a sum in a group footer? (Data View Web Part)

I have a DVWP that displays groups of data. For each group, I've got a sum of one of the columns. This sum exists in the group footer in a template called dvt_1.groupfooter0. <xsl:variable ...
0
votes
0answers
463 views

How do I change the date filter format in the Data View Web Part toolbar?

I have added a toolbar to the DVWP and enabled the Filter option. When I click on the filter, the Due Date field displays choices as "Saturday, September 11, 2010". Within the DVWP I have the format ...
0
votes
2answers
1k views

Using jQuery variable in DVWP

I am running SharePoint Foundation on Windows Server on a hosted site. I am able to retrieve a value with jQuery from the User Information List. Using Sharepoint Designer 2010, I have added a DVWP ...
0
votes
3answers
4k views

Dataview, filter to see “All items”

I have two dataviews in a page layout. The first one display all the categories of items, and then second one displays the items based on the selected category. It work find with filters and Query ...