method for querying list data

learn more… | top users | synonyms

2
votes
5answers
714 views

How to get the nth record using CAML from list

How to get the nth record (lets say 133rd) from the 1000 records (or unknown number of records) by using CAML query.
3
votes
4answers
2k views

Caml query builder Office 365 Sharepoint Online

Does anyone knows where to find a CAML query builder that I can use for Office 365, Sharepoint Online? (if there exists one)
2
votes
1answer
67 views

Event Receiver on SharePoint 2010 - How to query DB and display an error message

I'm an absolute beginner of SharePoint development. I would like to create my first Event Receiver and I'm doing with VS2010 (because I'm on SP 2010). I would like to check if adding a new event in ...
2
votes
2answers
112 views

Looping retrieved Items throws an InvalidCastException

I have some very simple code using the client object model to retrieve a list and all items from that list from a SharePoint 2013 Online site. When the ExecuteQuery() fires, I use Fiddler to view the ...
0
votes
1answer
72 views

Why is my CAML query for my list view not valid: filtering a date and membership of created by

The below query works only for each segement alone. Either: <And> <Geq> <FieldRef Name="Von"/> <Value Type="DateTime">{startdatum}</Value> </Geq> <Leq> ...
0
votes
2answers
919 views

How to check checkboxes in caml query?

In SharePoint 2010 client object model (JavaScript), I am using this caml query to download list items. There is a column called 'Office' and in it, there are several check boxes (i.e. its a ...
0
votes
0answers
42 views

Get SPListItem by title is very slow

I want to get a SPListItem by title. I´m using a caml query to filter the list (Around 1000 items). There is only 1 item with the title in the list. My problem is now that the performance is really ...
0
votes
2answers
5k views

SPListItemCollection Get ItemCount with rowlimit

I am filtering a list in caml SPQuery oQuery = new SPQuery(); oQuery.Query = "<OrderBy><FieldRef Name='FullName' /></OrderBy><Where><Contains><FieldRef ...
0
votes
0answers
26 views

How can i create a custom filter from SPD for a Link List with URL(Description) column

I want to create a Custom View using SPD (XSLT List View Webpart and Custom CAML query). What i want is how can i set condition for a URL Description. As can be seen in image below. Document Code ...
3
votes
1answer
390 views

CrossListQueryCache().GetSiteData(contextWeb) throws NullReferenceException on second query?

I have an auqward problem that's been nagging me on and off for half a years time. It turns out, when I'm finally taking a real shot at it that my query throws a NullReferenceException the second time ...
1
vote
0answers
287 views

How to query the list using CAML Query to List's multi allow user field?

I have a list in which there is one column which is of type People or Group with multi allow. I have created Item Adding event receiver in which I am checking the entered people value is already ...
0
votes
1answer
59 views

Help with complex CAML query

I am wondering if the following CAML query structure is correct: I appreciate your help. <Query> <CalendarDate><Today/></CalendarDate> <Where> <And> ...
0
votes
0answers
187 views

Filter a list view to get items current user can edit only, not read

I have a list where each item has unique permissions that allow all users to "read" the item, but only users in certain Sharepoint Groups can "edit" the item. I would like to give the users a view of ...
2
votes
2answers
3k views

What does the GetListItems query option IncludeMandatoryColumns do?

I found myself working with the Lists.GetListItems method fairly often. Unfortunately, I have never understood what the IncludeMandatoryColumns query option actually does. The documentation seems to ...
5
votes
3answers
257 views

CAML query on external list: access denied by business connectivity services

I am trying to run a CAML query on a BCS list and getting access denied as an error when debugging the code: SPList CMList = web.Lists[Constants.cmlist]; SPQuery query = new SPQuery(); query.Query = ...
2
votes
1answer
331 views

CAML query join and sort by column of projected fields

I am trying to execute the following query: query.Query =<Where> <IsNotNull> <FieldRef Name='Product' /> </IsNotNull> </Where> <OrderBy> <FieldRef ...
0
votes
3answers
77 views
0
votes
0answers
57 views

CAML to find tasks “Assigned To” specific users

I have a task list containing an "Assigned To" SPUser field. Only users in a SharePoint group can be assigned to tasks in this list. I want to iterate through the SharePoint group and find out how ...
3
votes
1answer
146 views

CAML Query works on hardcoded value, but not on variable

I am really new to SharePoint, and I came across an issue that is driving me crazy. I am trying to use CAML Query to get a specific list item. My query works on hard coded condition, but not when I ...
2
votes
1answer
677 views

CAML query limitation of values in IN operator

I have less than 5000 items in my library. I want to get 530 items by ids. So I am using following query. <Where> <In> <FieldRef Name="ID" /> <Values> ...
1
vote
2answers
544 views

Problem with Calendar CAML Query

i have a problem with a CAML Query for a Sharepoint Online(Office365) Calendar. I try to get all Calendar Appointments between two dates. Here is my code: private void getFreeDays() { ...
1
vote
1answer
134 views

Bulk updates to SharePoint Lists

I was recently assigned to make changes to several SharePoint lists that store content for a public facing web site. Due to the SharePoint settings or my VM’s Internet Explorer settings I could not ...
1
vote
2answers
155 views

How to retrieve the login of the user who checked-out a given file

I am currently developping a C# application which has to retrieve some data from a SharePoint website through a CAML request. I successfully get everything I need except one information : the login ...
1
vote
2answers
202 views

CAML In clause - Value does not fall within the expected range

I get a 'Value does not fall within the expected range' error from the following CAML. <Query> <Where> <In> <FieldRef Name="ID"/> <Values> ...
0
votes
3answers
4k views

SPServices <today /> not returning correct results

This is the chunch of code that I am working with. I am trying to get only the events (normal/all day/recurring) to show, and it is returning all items for the whole week. Any ideas? ...
0
votes
2answers
3k views

CAML query on Sharepoint List without duplicates

How can I retrieve all elements in a List ignoring duplicate entries So if List A contains: Employee A Employee A Employee B Employee B Employee C Employee D Employee E I want to get ...
1
vote
1answer
396 views

“Not in” membership caml query

In a custom list definition, I'm building a view with this query : <Where> <Or> <Membership Type="CurrentUserGroups"> <FieldRef ...
1
vote
2answers
969 views

CAML OffsetDays

please help if it possible that CAML OffsetDays is not working in DvWP? I use the following CAML within a DVWP: <View><Query> <Where><And> <Lt> <FieldRef ...
1
vote
1answer
544 views

SP2010 JSOM: updating with CAML where clause

So I learned and have used the following to update a list item by ID using Javascript Client Object Model: function updateItem(passedID) { var ctx = new SP.ClientContext.get_current(); var myList = ...
0
votes
0answers
79 views

Filter SharePoint documents based on a Tag filter using the Client Object Model

I am successfully fetching SharePoint documents using a CAML query via the Client Object Model. I would now like to add list of tags as a filter to this query, so that only documents tagged with ...
1
vote
0answers
387 views

How to filter a list view by SP group membership (CAML, JS, anything)

I have a list. I need to filter the list view in SharePoint to show items: created by someone in current user's group show all to admin group I am using Infopath for the list's form view, and ...
2
votes
4answers
10k views

Get Items Under Folder CAML

I am trying to retrive all items that are under a certin folder, in a document library. this is what i have so far List DocumentsList = clientContext.Web.Lists.GetByTitle(list); CamlQuery camlQuery ...
3
votes
2answers
255 views

Caml query with unicode charachter

the caml query bellow don't return the correct result : <Where><Eq><FieldRef Name='ParentLink' /><Value Type='Text'>ⵜⴰⵎⴰⵡⴰⵙⵜ</Value></Eq> </Where> i ...
0
votes
0answers
129 views

SharePoint 2013 custom TimerJob gets no results from list but same code as a console program returns results

Can anyone provide any ideas on why the below query returns nothing when inside a custom timer job. But when run from a console program it returns results. Note, both console program and OWSTimer.exe ...
2
votes
1answer
202 views

CAML Query Custom Ordering

I have looked around a bit, but have not found any reference to this particular issue. Is it possible to specify a custom ordering in a CAML query? What I mean by this is, say I have a list with a ...
1
vote
2answers
617 views

Unable to return items under folder using CAML

I have a folder in the default "Images" library under my site, called Menu Icons: /PublishingImages/Menu Icons I want to retrieve only the images under this folder, and not all images under the root ...
0
votes
1answer
63 views

caml query on lists connected by lookup columns

I want to use CAML to query two lists that are connected by a lookup column. If I set the lookup column in List 1 to connect to the Title column of List 2, can I do a CAML query that joins them? Or do ...
2
votes
1answer
122 views

CAML Query throwing error

Pretty new to CAML queries, but trying to query a list based on Status = Completed and a date range. It is throwing the following error "Unexpected Error: One or more field types are not installed ...
0
votes
0answers
25 views

Anyway to know if a List View will breach the Threshold in the near future? (SP2010)

I understand why the LVT is there, how it works and so on, I also get how to order the fields in views to get the query under the threshold. However, is there a simple way to evaluate a list and its ...
1
vote
0answers
89 views

CQWP bind sorting with query string

Is there a way to use PageQueryString in CQWP to control the sort order and sort by behavior? I am trying to implement this kind of sortable and filterable table with pagination: Would it be ...
0
votes
1answer
116 views

CAML query many-to-many relationship

I have a case where a customer can have many contacts and a contact can be assigned to many customers. Currently I have a page for each customer, on load I get all the contacts (a publishing page for ...
1
vote
3answers
3k views

Get field value from item in SPListItemCollection

I am confused with SPQuery. How can I use it to get listitem values. Let's say I have a list "Cinema" with 20 columns but i only want 4. Film ID Film Name Film Type Film Review How can i get all ...
3
votes
1answer
146 views

Needed help to build caml Query with multiple <And>

I am getting a query from list view by view.Query i got the following <QUERY> <GroupBy Collapse="TRUE" GroupLimit="100"><FieldRef Name="AlertGrp" /></GroupBy> ...
7
votes
2answers
584 views

Can a CAML query find all documents that were ever modified by a specific user?

I'm trying to list all documents that were (ever) modified by a specific user, using a CAML query like this one: var query = new CamlQuery{ ViewXml = "<View Scope='Recursive'>" + ...
1
vote
2answers
302 views

CAML query to retrive data from 3 lists present in three different site

I have a parent site X, and three child site A, B and C. There is a list by the name "MyList" in all the list sites. I want a CAML Query to retrieve the latest ten records,from "MyList"(now ten ...
0
votes
1answer
132 views

CAML query to select users IDs

I'm trying to select users ids from custom tasks lists. All users are in one SP Group and I need to collect users Ids that doesn't have tasks. query.Query = string.Format("<And><Membership ...
2
votes
2answers
109 views

moving list items from wss 3.0 to foundation 2010 using lists.asmx

I'm trying to use Lists.UpdateListItems to move items from a list in WSS 3.0 to a list in SharePoint Foundation 2010. The original list contains several items. The target list does not contain any ...
1
vote
2answers
894 views

Building CAML query with AND and Order by Clause

Hi I am trying to build a query using caml query builder - Below is the query (The query = get the values only whose address = 1234st AND LastName = Doe) - I believe the placement of AND operator is ...
3
votes
2answers
6k views

SPService GetListItems with CAML : can't get example to work

enter code hereI am using an example I found on codeplex of SPServices with CamlQuery to try to get list item values with where clause on the ID. For whatever reason this doesn't seem to work for me; ...
1
vote
0answers
37 views

SP2010 - Visual Web Part - Storing metadata in folders in document libraries

I want to store a number to folders to enforce ordering. I noticed these three pages http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spfolder.getproperty.aspx ...