Hot answers tagged

2

I don't think this is currently possible since it's a comma seperated value. All filtering options are void since searching on exact word contains either 0 or 2 since both contain the word black. Unless I am mistaken CAML Query does not Support removing a character in this case the comma and then search for exact word. if it was space seperated instead ...


2

Create a view in your list. Set a filter on the view to filter the data so the total number of items displayed in the view is less than the threshold, based on e.g. a date range, a number, by item id etc. Then after you can use the ListItemCollectionPosition class to implement paging list item retrieval according to the position of items relative to their ...


2

SP.CamlQuery does not have a property RowLimit , you have to set in the caml markup: camlQuery.set_viewXml("<View><Query> <OrderBy> <FieldRef Name='ID' Ascending='False' /> </OrderBy> </Query> <RowLimit>5</RowLimit> </View>");


1

try this using (SPSite spsite = SPContext.Current.Site) { using (SPWeb web = spsite.OpenWeb()) { SPQuery query = new SPQuery(); SPList list = web.Lists["CalendarList"]; query. ExpandRecurrence = true; // query.RowLimit = 20; ...


1

Using Client Object Model, You can query large list by using ListItemCollection Property ClientContext clientContext = new ClientContext("YOURURL"); List list = clientContext.Web.Lists.GetByTitle(“Tasks”); ListItemCollectionPosition itemPosition = null; while (true) { CamlQuery camlQuery = new CamlQuery(); camlQuery.ListItemCollectionPosition ...


1

This might be duplicate of List with > 5000 items working with Paging? Please have a look and let me know whether it is helpful or not Thanks


1

Using Linq query, you can get result what exactly you want. var reg = new Regex("\\\bblack\\\b", RegexOptions.IgnoreCase); var result = from item in lst.Items.Cast<SPListItem>() where reg.IsMatch(item["Title"].ToString()) select item;


1

try this: <Where><And><Gt><FieldRef Name='Date'/><Value Type='DateTime'>" + dTfrom.SelectedDate.ToString("yyyy-MM-ddTHH:mm:ssZ") + "</Value></Gt><Lt><FieldRef Name='Date'/><Value Type='DateTime'>" + dtTo.SelectedDate.ToString("yyyy-MM-ddTHH:mm:ssZ") + ...


1

Valid values for DateRangesOverlap are <Year>, <Month>, <Now>. If you want to get future recurrence events for single month than use <Month>. If you want to get future recurrence events for entire year than use <Year>. I assumed here in below updated query that you need current month's results for recurrence events. SPQuery ...


1

Resolved by applying below code using (SPSite spsite = SPContext.Current.Site) { using (SPWeb web = spsite.OpenWeb()) { SPList list = web.Lists["CalenderList"]; SPQuery query = new SPQuery(); query.ExpandRecurrence = true; ...


1

You need to format the date like this: Server Site string date = SPUtility.CreateISO8601DateTimeFromSystemDateTime(inputDate); Sample for your case: inputDate = new DateTime(2016,04,18); string date = SPUtility.CreateISO8601DateTimeFromSystemDateTime(inputDate); Client Side (client object model) string date = ...


1

Another option is to avoid the CAML and use calendar views. According to this blog post, you can create a view that shows recurring events and displays them in chronological order. Then at the end of the view definition, you can limit the view to show the next 2 items. To create the view, go to the calendar and follow these steps: Ribbon -> Calendar -> ...



Only top voted, non community-wiki answers of a minimum length are eligible