Filter by Person in a DataView Webpart

Question

I am trying to Filter Items in a Data View webpart using my Assigned To(Person or Group field) But the Values in my Dropdown has HTML in it.

I had the same issue when displaying Items in Webpart and Fixed it replacing Filed with <xsl:value-of select="@AssignedTo" disable-output-escaping="yes" /> But Don't know How to change it in Filter Choice values .....

Answer 1

Displaying the value correctly is a simple matter of adding the disable-output-escaping="yes" attribute.

Person or Group columns are more complicated when it comes to sorting or grouping.  See my blog post:
http://mdasblog.wordpress.com/2010/03/02/unlocking-the-mysteries-of-data-view-web-part-xsl-tags-part-12-miscellaneous-person-or-group-columns/

M.

---

Sympraxis Consulting LLC - Marc D Anderson's Blog - @sympmarc - jQuery Library for SharePoint Web Services (SPServices) - Unlocking the Mysteries of the SharePoint Data View Web Part XSL Tags eBook

Answer 2

Marc, I am having trouble showing person in field filter choices but not in list data I know adding disable output escape value to yes can correct this but where to add it to changes values in filter values as shown in figure( not in list item value )

Answer 3

Sorry, I missed that.  As I explain in the blog post, Person or Group columns are problematic.  You're going to need to dig into the XSL to customize it.  It's not just choosing the value that you'll have problems with; you'll also have to adapt the filtering logic.

M.

---

Sympraxis Consulting LLC - Marc D Anderson's Blog - @sympmarc - jQuery Library for SharePoint Web Services (SPServices) - Unlocking the Mysteries of the SharePoint Data View Web Part XSL Tags eBook

Answer 4

I'm having the same problem.  Can't get the filter to show just the name and not the HTML.  Tried substringing but that did not work.  Do you have the actual xsl code to fix this standard issue?

Answer 5

Substringing out the ID or name will work. Check out my SPXSLT Codeplex Project for templates you can use.

M.

---

Sympraxis Consulting LLC - Marc D Anderson's Blog - @sympmarc - jQuery Library for SharePoint Web Services (SPServices)

Answer 6

Hi Marc,

Forgive an XSL newbie but if I used your code for Strip HTML where would the call to the template go?

I have my filters set up in the top row of my columns.  Current code is something like this:

<th class="ms-vh" nowrap"">

  <xsl:call-template name="dvt.headerfield"ddwt:atomic="1" xmlns:ddwrt="http://schemas.microsoft.....

     <xsl:with-param name="fieldname">@AssignedTo</xsl:with-param>

     <xsl:with-param name="fieldtitle">Activity POC</xsl:with-param>

     <xsl:with-param name="displayname">Activity POC</xsl:with-param>

     <xsl:with-param name="dvt_sorttype">text</xsl:with-param>

     <xsl:with-param name="sortable">1</xsl:with-param>

     <xsl:with-param name="fieldtype">x:string</xsl:with-param>

</xsl:call-template>

</th>

The value code in the DVWP dvt_1.rowview template is:

   <xsl:value-of select="@AssignedTo" disable-output-escaping="yes"/>

would I place you code after the </xsl:template> tag?









Answer 7

I think you probably want one of the templates that strips values out of Person or Group columns, not this one.

There are general instructions in the documentation on the site.

M.

---

Sympraxis Consulting LLC - Marc D Anderson's Blog - @sympmarc - jQuery Library for SharePoint Web Services (SPServices)

Answer 8

Hi,

I understand how to substring out my value so that just the person info shows up in a column.  But how do you fix the filter????????????  This seems to be a major problem for all?  Here is the filter code in the column heading:

<xsl:call-template name="dvt.headerfield" ddwrt:atomic="1"
xmlns:ddwrt="schemas.microsoft.com/WebParts/v2/DataView/runtime">
<xsl:with-param name="fieldname">@AssignedTo</xsl:with-param>
<xsl:with-param name="fieldtitle">AssignedTo</xsl:with-param>
<xsl:with-param name="displayname">Assigned To</xsl:with-param>
<xsl:with-param name="dvt_sorttype">text</xsl:with-param>
<xsl:with-param name="sortable">1</xsl:with-param>
<xsl:with-param name="fieldtype">x:string</xsl:with-param>
</xsl:call-template>

Do I modify one of theses rows or am I in the wrong place?

Answer 9

Hey @TLunn,

I also got same problem when we have upgraded from SP2010 to 2013. So, I have poked around XSLT and Rich fields for couple of days. Finally, I figured out a way to solve the issue. Basically, you just need to grab the values from rich text field properties like @AssignedTo.title, @AssignedTo.email etc. In my case, I had to show user name from People field. So I have changed my header field XSLT as below. Rich Text fileds like People and URL, returns few extra attributes like User ID, Title, URL to display profile, SIP ID, email. When you convert those all atributes into string, it returns chunck of HTML and it shows up in filter. So, get the exact value whatever you want (if you still have this issue :P ) from rich text field properties. In your case it should be <xsl:with-param name="fieldtitle">AssignedTo.title</xsl:with-param>. I hope this helps you to resolve your issue

<xsl:call-template name="dvt.headerfield" ddwrt:atomic="1" xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime">
       <xsl:with-param name="fieldname">@Assigned_x0020_Writer.title</xsl:with-param>
       <xsl:with-param name="fieldtitle">Internal Writer</xsl:with-param>
       <xsl:with-param name="displayname">Internal Writer</xsl:with-param>
       <xsl:with-param name="sortable">1</xsl:with-param>
       <xsl:with-param name="fieldtype">x:string</xsl:with-param>
      </xsl:call-template>