Using CAML queries in SPFx or SharePoint PnP
I am attempting to recreate a webpart I made for SharePoint classic as a SharePoint modern webpart. I need to use a CAML query to get the one person who is on-call in our department (kept in a SharePoint calendar). I can only find very simple query examples but I need to use a complex CAML query. 1) can someone show me where to find documentation on what I am trying to do 2) can someone tell me what I am doing wrong in this code. private getOnCall(): void { const context: SP.ClientContext = new SP.ClientContext(this.properties.siteUrl); const list: SP.List = context.get_web().get_lists().getByTitle('On Call'); context.loadQuery(list, '<View><ViewFields><FieldRef Name="Title" /><FieldRef Name="EventDate" /><FieldRef Name="EndDate" /></ViewFields><Query><Where>' + '<And><Contains><FieldRef Name="Title" /><Value Type="Text">On-Call</Value></Contains><And><Leq><FieldRef Name="EventDate" /><Value IncludeTimeValue="True" Type="DateTime">' + '<Today /></Value></Leq><Geq><FieldRef Name="EndDate" /><Value IncludeTimeValue="True" Type="DateTime"><Today /></Value></Geq></And></And></Where></Query></View>'); context.executeQueryAsync((sender: any, args: SP.ClientRequestSucceededEventArgs): void => { const listEnumerator: IEnumerator<SP.ListItem> = list.getEnumerator(); var title: string; while (listEnumerator.moveNext()) { const item: SP.ListItem = listEnumerator.get_current(); title = item.get_item('Title'); } }, (sender: any, args: SP.ClientRequestFailedEventArgs): void => { } }
CAML query not working
I want to filter list items on the basis of sharepoint user group name. only list items which having Value in Column-Vendor same as Sharepoint group should able to see that list item. I am using following CAML query <Membership Type="CurrentUserGroups"><FieldRef Name="Vendor"/></Membership> but its not working, I tried following also <Membership Type=\"CurrentUserGroups\"><FieldRef Name=\"Vendor\"/></Membership> but still its not filtering but showing all list items for the user.
Filtering List items on the basis of sharepoint group using CAML query in sharepoint online classic
I want to filter items of list library on the basis of sharepoint groups. users belong to one sharepoint group-IT can only see list items which having value in one column Vendor='IT' users belong to another sharepoint group -Finance can only see list items which having value in column Vendor='finance' when user visit page he can only see list items which having value in column mapped with user group. how can I achieve this in sharepoint online classic please find following article for solution,will it work? https://www.crowcanyon.help/article/304/ I added following code of CAML query through sharepoint designer to default view, but its not giving expected result where Vendor is column in list which I want to compare with current users sharepoint group. <And><Membership Type="CurrentUserGroups"><FieldRef Name="Vendor"/></Membership></And>Membership Tag not working in CAML query sharepoint
I am getting error where using Membership tag <Query><Where><Membership Type="CurrentUserGroups"><FieldRef Name="Vendor" /></Membership></Where></Query> error Correlation ID: 076f579f-20f1-b000-c31a-67e814dcf994 Not sure whats wrong, I am using sharepoint online classic
how to get maximum of another column for a grouped column
Hello in my SharePoint list I have below columns and meta data: Doc No Rev Doc-0001 00 Doc-0001 01 Doc-0001 02 Doc-0002 00 Doc-0002 01 Now I want below to result in the view or query, that added another column that show maximum Rev for each Doc No Doc No Rev Maximum Rev Doc-0001 00 02 Doc-0001 01 02 Doc-0001 02 02 Doc-0002 00 01 Doc-0002 01 01 I read something about CAML in the NET, but I do not know how I have to use that for solving my problem. Regards, Masoud
