This has become a serious requirement in two of the projects we are dealing with, so I thought it is worth sharing with the community.<\/P>
\n
Let’s say, you have a list for which you want to display all the list items Created By the currently logged in user. There are two ways to do it:<\/P>
\n
A) Through web browser interface: List settings –> Filter –> Choose Created By field and make it equal to [Me]<\/P>
\n
B) If you want to put it in your site def, things are done a little bit differently. <\/P>
\n
First of all, the [Me] operator only works on lookup fields bound to the list “user information” and on the built-in system fields (i.e. “created by” OR “modified by”)<\/P>
\n
Secondly, at the end of the day [Me] is translated to an integer. In order to implement such a functionality you should locate the Schema.xml of the list or document library for which you wish to create this view for and follow these steps:<\/P>
\n
1) Open Schema.xml<\/P>
\n
2) Find views element <\/P>
\n
3) Either create a new view element or insert the following snippet into one of the existing views for which you want to implement the filter:<\/P>
\n
<Query>
<Where>
<Eq>
<FieldRef Name=”Author” \/>
<Value Type=”Integer”>
<UserID Type=”Integer” \/>
<\/Value>
<\/Eq>
<\/Where>
<\/Query><\/P>
\n
4) Save Schema.xml <\/P> 5) Restart IIS<\/P> This has become a serious requirement in two of the projects we are dealing with, so I thought it is worth sharing with the community. Let’s say, you have a list for which you want to display all the list items Created By the currently logged in user. There are two ways to do it: […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-1147","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts\/1147","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/comments?post=1147"}],"version-history":[{"count":0,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts\/1147\/revisions"}],"wp:attachment":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/media?parent=1147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/categories?post=1147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/tags?post=1147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
This will turn out to an actual T-SQL with where clause and equal operator (
\n
\n
\n
Now you have the view with a filter on the current logged in user. In next post I will show you how to implement the same functionality using content query web part (CQWP) which is awesome for cases of this kind.
<\/P><\/p>\n
\n","protected":false},"excerpt":{"rendered":"