Bulk update and delete using SPservice in SharePoint

By - 

$().SPServices.SPUpdateMultipleListItems({
  listName: "States",
  CAMLQuery: "<Query><Where><Eq><FieldRef Name='Status'/><Value Type='Text'>Active</Value></Eq></Where></Query>",
  valuepairs: [["Status", "Inactive"]]
});
This call to SPUpdateMultipleListItems will update all of the items in the States list which have their Status = "Active", setting their Status = "Inactive".
$().SPServices.SPUpdateMultipleListItems({
  listName: "States",
  CAMLQuery: "<Query><Where><Eq><FieldRef Name='Status'/><Value Type='Text'>Inactive</Value></Eq></Where></Query>",
  batchCmd: "Delete"
});
This call to SPUpdateMultipleListItems will delete all of the items in the States list which have their Status = "Inactive".


Anandan is a SharePoint and Microsoft Azure consultant.He is having 9+ years of experience in the web, cloud, Machine Learning, IoT and mobile technology. He handled multi-platform solution as a consultant with the experience of designing, developing and deploying solutions by leveraging Microsoft, IBM, Apple, and Google technology stack, has played a dynamic role in the development of SharePoint and ML technologies. He writes articles related to SharePoint Online/On-Premises and Machine Learning.

Comments

Post a Comment

Popular posts from this blog

List attachment link in SharePoint 2013 search.

By -
Issue : List attachments links are not able to show in SharePoint 2013 search. Causes: There is no clear field for the attachments in SharePoint list.So we could not get the property related to attachments in the crawl. Solution:We can manually add the field in list where we have the attachment.This field will have the attachment URL.We can make this by Item added event receiver.Now our custom field will be available in crawl property and we can able to create a new managed property, which will map the custom field crawl property. So we can edit the display template based on new managed property.Display template sample is available in the below snippet. Crawl of the list attachment arguments are given in the below URLs. http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=83 http://sajiviswam.wordpress.com/2011/11/23/are-list-attachments-indexed-in-sharepoint-search/ <html xmlns:mso="urn:schemas-microsoft-com:office:office" xmlns:msdt="uuid:C2F...
Read more

Create page layout for SharePoint 2013 search result webpart.

By -
Add new module in a under a project. Add new page with web part zone under the module and the ULR in the element.xml should be Pages.  Deploy your solution. Add your web parts in your custom page. Open the same page in designer, now you can find the spsswc:ResultScriptWebPart tag. <spsswc:ResultScriptWebPart runat="server"  DataProviderJSON ="{&quot;QueryGroupName&quot;:&quot;Default&quot;,&quot;QueryPropertiesTemplateUrl&quot;:&quot;querygroup://webroot/Pages/Dummysearch.aspx?groupname=Default&quot;,&quot;IgnoreQueryPropertiesTemplateUrl&quot;:false,&quot;SourceID&quot;:&quot;5ce35ddf-d563-4d32-b850-c45760c9a3bf&quot;,&quot;SourceName&quot;:&quot;Product Catalog&quot;,&quot;SourceLevel&quot;:&quot;Ssa&quot;,&quot;CollapseSpecification&quot;:&quot;&quot;,&quot;QueryTemplate&quot;:&quot;{searchboxquery}&quot;,&quot;FallbackSort&...
Read more