34
This is related how instance of SPListItem is being created. Actually in both cases new item is added to the collection of items in list, in first case new item is added explicitly, in the second one implicitly.
The point is, that for initializing collection of items in list is used the same method GetItems but with different queries.
SPList.Items.Add()...
18
Assuming that you already have a reference to the list item (called "item" in the following code sample), you must first get a reference to the list field and then use the GetFieldValue method to read the actual value.
SPFieldUser userField= (SPFieldUser)item.ParentList.Fields.GetFieldByInternalName(internalName);
var fieldValue = ((SPFieldUserValue)...
16
You can also use SPQuery and a CAML query, like below. I also agree with what Dave Wise said about PortalSiteMapProvider class.
SPQuery query = new SPQuery();
query.Query = "<Where><Eq><FieldRef Name=\"Title\" /><Value Type=\"Text\">YourTitle</Value></Eq></Where>";
query.RowLimit = 1;
query.ViewFields = "";
...
13
You load multiple items. A conflict occurs. Collect all items you need and call "load". After you call load for all items, then run context.executeQueryAsync.
Save your selected items as a global variable (this.items):
function showTitles(urlColumnName) {
var context = new SP.ClientContext.get_current();
var web = context.get_web();
var lists = web....
13
Try this (Excerpt from here):
function getListItem(url, listname, id, complete, failure) {
// Getting our list items
$.ajax({
url: url + "/_api/web/lists/getbytitle('" + listname + "')/items(" + id + ")",
method: "GET",
headers: { "Accept": "application/json; odata=verbose" },
success: function (data) {
// ...
12
A simple solution is to just validate the fields on submit by adding a validation rule in the list settings.
Go to List Settings
Open Validation settings under the General Settings area
In the formula add your formula, I think it will be like this in your scenario:
=OR(IF(ISBLANK(TargetPage),NOT(ISBLANK(ExternalURL))),IF(ISBLANK(ExternalURL),NOT(ISBLANK(...
12
The ItemCount function could be applied to List resource, for example:
/_api/web/lists/getbytitle('<list title>')/ItemCount
but not to ListItemCollection resource
You could consider the following options of getting items count for list items:
Option 1
How to return items count from json result:
var endpointUrl = _spPageContextInfo....
11
If you use linq to object, you always retrieve ALL records from DB. It is not good if you have got a lot of data. To reduce records you can use CAML query:
SPQuery query = new SPQuery();
query.Query = "<Where>" +
"<Eq>" +
"<FieldRef Name=\"FileLeafRef\"/>" +
"<...
10
private IEnumerable<string> GetAttachmentUrls(SPListItem item)
{
return from string fileName in item.Attachments
orderby fileName
select SPUrlUtility.CombineUrl(item.Attachments.UrlPrefix, fileName);
}
10
I found answer for my question.
private string GetAttachmentUrls(SPListItem oItem)
{
string path = string.Empty;
try
{
path = (from string file in oItem.Attachments
orderby file
select SPUrlUtility.CombineUrl(oItem.Attachments.UrlPrefix, file)).FirstOrDefault(...
9
AS PER MSDN
SPList.ItemCount:
The value of the ItemCount property includes folders within a document library, as well as files within subfolders. The value of the Count property of the SPListCollection class does not include folders.
SPListItemCollection.Count:
Gets the number of list items in the collection, excluding folders.
BUT
Although it's ...
8
If fetching of item["ID"] instead of 'Title' works AND If you are using the SPQuery object. Then, include the columns that you want to fetch in the ViewFields property of SPQuery. This will resolve your issue.
Reference: http://discoverlars.wordpress.com/2012/01/24/argumentexception-value-does-not-fall-within-the-expected-range-error-using-fields-on-...
7
We might have to manipulate/update the data without changing the Modified or Modified By fields to meet the business needs and also retaining the document/Item status without incrementing the version is also important aspect to be considered. In such cases SystemUpdate() method of SPListItem can be leveraged.
This basically updates the content database with ...
answered May 12 '15 at 11:08
Sivakumar Piratheeban
1,9685 gold badges33 silver badges54 bronze badges
7
Use below code to get User name:
new SPFieldLookupValue(properties.ListItem["Staff Member"].ToString()).LookupValue;
For User ID:
new SPFieldLookupValue(properties.ListItem["Staff Member"].ToString()).LookupId;
6
The PortalSiteMapProvider is the fastest way to access content and you should be able to do what you need with that.
6
You can use the SPWeb GetFile method to retrive the SPFile located at a specified url. Try something like this:
SPFile file = SPContext.Current.Web.GetFile(string.Format("{0}/{1}", x, y));
6
You can retrieve the value by using item.Properties["Name"] instead. We ran into the same problem and while I wasn't able to find a root cause this worked as a fix.
6
SharePoint does not provide a method of restarting a workflow. You can however cancel a running workflow and start it again. A good example of canceling a running workflow can be found here: http://blog.brianfarnhill.com/2008/10/how-to-cancel-a-workflow-programmatically
The snippit of code below will start your workflow.
private static void StartWorkflow(...
6
The objects you get from $list.Folders are SPListItems not SPFolders so the ListItems property gives the Lists ListItemCollection not something for the folder.
To get the SPFolder you have to access $folder.Folder.
If what you're working with is a document library, then it's easy just access $folder.Folder.Files and you'll get the files in the SPFolder, ...
6
Make sure that the column you include in the where clause is defined as an indexed column in SharePoint. You can check by going to the list you're querying and into List -> Settings -> Indexed Columns. It's not applicable in your CAML query, but if you have more than one 'where', ensuring the first where hits an indexed column can increase efficiency.
...
6
get the item in SPlistitem and then get value from it.
For ex =
Splistitem item = list.getitembyid(1);
var x = item.ID;
6
In SharePoint ID is a counter and always incremental. Even though you delete item, it is never going to occupy the blank ID. It always keeps on incrementing.
Also list.Items always return SPListItemCollection. But when you delete the item from List, the index of Item keeps on changing. For example, you had 10 items in list list.Items[9] will give you the ...
5
Did you try the solution mentioned over on this post?
Activating and deactivating publishing feature breaks SP2010 wikis?
I don't know if it will work for you, but it might be worth a try.
I didn't have any success with that previous answer though and went the other way and delved into the bowels of SharePoint and found that even though I was re-...
5
You can use:
if (bool.Parse(item["ShowTitle"].ToString()) == true)
or
if (item["ShowTitle"].ToString() == true.ToString())
5
You need to use the $expand option in your query string.
siteUrl + "/_api/lists/getbytitle('" + listName + "')/items?$select=NameOfLookup/FieldYouWant&$expand=NameOfLookup/NameOfFieldYouWant"
So yours would be:
"/_api/lists/getbytitle('" + listName + "')/items?$select=$expand=status_x0028_test_x0029/Title&$expand=status_x0028_test_x0029/Title
...
5
You can use SharePoint web services.
Below is the snippet I copied from https://stackoverflow.com/questions/22450717/add-and-update-single-item-in-sharepoint-list-via-vba
Sub Add_Item(ListName As String, SharepointUrl As String, ValueVar As String, FieldNameVar As String)
Dim objXMLHTTP As MSXML2.XMLHTTP
Dim strListNameOrGuid As String
Dim strBatchXml As ...
5
When you query /_api/web/Lists/getbytitle(\'Items\') basically it returns SPList object. That object as ItemCount property.
The value of the ItemCount property includes folders within a list/document library, as well as items/files within subfolders.
For filtering we need to apply filter on Items so query /_api/web/Lists/getbytitle(\'Items\')/items?$filter=...
5
Using SPList.Items property is bad practice. Each time the property is accessed, it requests all items with all fields from database. Instead you should always use SPList.GetItems().
SPList.GetItems(params string[]) - you can use it to load only the fields that you need. As far as I remember it'll only return items in the root folder of the list.
SPList....
5
I never use the SPListItem.Url property, as list items don't really have a user browsable URL. They only have an ID, and the list that contains them has a display form (list forms may also change over time).
The URL of an item is used internally by SharePoint but is never shown/used by the users.
So, I always use code such as:
Uri webUri = new Uri(web.Url)...
5
Yes, this is possible in SharePoint 2013.
You can follow the below steps:
Go to the list where you want to assign item level permissions.
Select the Item in which you have to provide the permissions.
Then click on the ellipses -> Advanced -> Shared With and a new pop up will appear.
In the pop up, click on the Advanced button.
The permission groups for ...
Only top voted, non community-wiki answers of a minimum length are eligible
