Forum Discussion
列表视图的js查询，不能正确的根据条件查询结果
如下代码添加在视图aspx文件中，需要过滤的条件是分配对象是本人（ID=6）或者分配对象里的用户组是本人所在的组，下面为了测试查询条件，写死了用户ID，但是列表查询结果仍然是所有件数，query并没有起作用，希望可以得到各位的指点，万分感谢！
<script type="text/javascript">
var groups;
var q;
var user;
var camlQuery;
var list;
var listitem;
var query;
function CheckCurrentUserMembership() {
var clientContext = SP.ClientContext.get_current();
q ="<View><Query><Where><OR><Eq><FieldRef Name='AssignedTo'/><Value Type='Integer'>6</Value></Eq></OR></Where></Query></View>";
list = clientContext.get_web().get_lists().getByTitle('休假申请工作流 任务');
camlQuery = new SP.CamlQuery();
camlQuery.set_viewXml(q);
this.listItems = list.getItems(camlQuery);
clientContext.load(this.listItems);
}
var groups;
var q;
var user;
var camlQuery;
var list;
var listitem;
var query;
function CheckCurrentUserMembership() {
var clientContext = SP.ClientContext.get_current();
q ="<View><Query><Where><OR><Eq><FieldRef Name='AssignedTo'/><Value Type='Integer'>6</Value></Eq></OR></Where></Query></View>";
list = clientContext.get_web().get_lists().getByTitle('休假申请工作流 任务');
camlQuery = new SP.CamlQuery();
camlQuery.set_viewXml(q);
this.listItems = list.getItems(camlQuery);
clientContext.load(this.listItems);
}
$(document).ready(function ($) {
SP.SOD.executeFunc('sp.js', 'SP.ClientContext', CheckCurrentUserMembership);
ExecuteOrDelayUntilScriptLoaded(CheckCurrentUserMembership, "SP.js");
ExecuteOrDelayUntilScriptLoaded(CheckCurrentUserMembership, "SP.ClientContext");
});
</script>
SP.SOD.executeFunc('sp.js', 'SP.ClientContext', CheckCurrentUserMembership);
ExecuteOrDelayUntilScriptLoaded(CheckCurrentUserMembership, "SP.js");
ExecuteOrDelayUntilScriptLoaded(CheckCurrentUserMembership, "SP.ClientContext");
});
</script>
No RepliesBe the first to reply