过滤和排序数据视图Web部件以仅显示本周的事件 [英] Filtering and sorting a data view web part to show this week's events only

问题描述

我有三个自定义列已添加到我已链接到链接数据源的多个事件日历中。

I have three custom columns which have been added to several events calendars which I have linked into a linked data source.

• 周开始：    = [开始时间] -WEEKDAY（[开始时间]，2）+1
• 周结束：     = [Week start] + 6
• 要求的设备： 选择列

在新页面中插入的数据Web部件显示链接数据源的内容。我想过滤数据源，以便它只显示本周发生的事件，以及请求设备的位置。

A data web part inserted in a new page shows the content of a linked data source. I'd like to filter the data source so that it only shows events which take place this week, and where equipment has been requested.

这是我正在使用的代码，但它不是按本周过滤 - 而是显示所有已请求设备的事件。

This is the code I am using but it is not filtering by this week - instead it is showing all events where equipment has been requested.

<xsl:variable name="Rows" select="/dsQueryResponse/Rows/Row[number(ddwrt:FormatDateTime(ddwrt:FormatDate(string(@EventDate),1033,5),1033,'yyyyMMddHHmmss')) &gt;= (ddwrt:FormatDateTime(ddwrt:FormatDate(string(@WeekStart),1033,5),1033,'yyyyMMddHHmmss')) and (ddwrt:FormatDateTime(ddwrt:FormatDate(string(@EventDate),1033,5),1033,'yyyyMMddHHmmss')) &lt;= (ddwrt:FormatDateTime(ddwrt:FormatDate(string(@WeekEnd),1033,5),1033,'yyyyMMddHHmmss')) and @EquipmentRequested != '']"/>

关于我做错的任何想法？

Any ideas on what I am doing wrong?

推荐答案

您好NCCAdm，



从您的描述中，您在XSL Dataview中过滤日期列时遇到问题。



请参阅以下有关SPD条件格式和日期比较的文章：



https://amavs.wordpress.com/2010 / 12/16 / date-comparison-formatdatetime-function-ddwrt-namespace /



类似的问题帖子：



https://sharepoint.stackexchange.com/questions / 58499 / issue-using-ddwrtformatdatetime-in-xsl-variable



最好的问候， 



Lisa Chen 

Hi NCCAdm,

From your description, you got problem with filtering date column in XSL Dataview.

Refer to the following article about SPD conditional formatting and date comparison:

https://amavs.wordpress.com/2010/12/16/date-comparison-formatdatetime-function-ddwrt-namespace/

Similar issue post:

https://sharepoint.stackexchange.com/questions/58499/issue-using-ddwrtformatdatetime-in-xsl-variable

Best Regards, 

Lisa Chen 

这篇关于过滤和排序数据视图Web部件以仅显示本周的事件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！