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 => { } }
