CAML查询以获取最后修改的项目 [英] CAML query to get the last modified items

问题描述

大家好，

我有一个清单.每当用户修改此列表中的项目时，都会将其创建为具有更改日期的新条目.就像审计跟踪一样.

I have a list. Whenever a user modifies an item in this list, it will be created as a new entry with changed date. It's like an audit trail.

我有一个屏幕列出列出当天或少于当天修改的项目.即我的列表可以包含同一项目的多个行，但更改日期不同.我需要显示当天修改过的项目，或者如果当天未修改过的项目，则 该项目最早在该天之前修改.

I have a screen to list the items modified on that day or less than that day. ie my list can contain multiple rows for the same item but with different changed date. I need to show the items modified on that day or if it's not modified on that day, then the item modified on the earliest day just before that day.

如果是在SQL中，我将在我的表中完成一个max(项目ID)，其中changedate< mygivendate由"Anyfield"分组.

If it was in SQL i would have done a max (Item ID) From my table where changeddate < mygivendate group by 'Anyfield'.

这里有帮助

推荐答案

Sree，

您可以在以下位置创建新视图:-

you can create new view where you can like below: -

并创建一个如下所示的过滤器:-

and create a filter like below : -

希望这对您有所帮助.

此致

Gaurav

如果有帮助，请标记为答案...

这篇关于CAML查询以获取最后修改的项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！