0
votes
0answers
21 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
189 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
322 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
526 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
529 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
144 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
272 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
291 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
614 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
282 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
690 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
601 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
204 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
4k 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
572 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
234 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
526 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
590 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
435 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
3k 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 ...