method for querying list data

learn more… | top users | synonyms

0
votes
1answer
585 views

CAML query where date field is greater than another date field

Is it possible to write a CAML query that uses another field as the Value part of the filter? For example in SQL it would look like this: WHERE Field1 > Field2 This was by best guess but it is not ...
0
votes
0answers
94 views

Order all day events on a calendar

I have a calendar list with a choice called "Category" with items A,B,C,D. I want to sort the all day events that are shown based on the selected category. I tried to set the Orderby using the below ...
0
votes
1answer
50 views

element for tomorrow CAML

I have a calendar and am wanting to find all the events that have been put into calendar for tomorrow. Is there an element like <today/> for tomorrow? Basically how can I get it so it only ...
0
votes
1answer
69 views

Create CAML query with have a value field with SharePoint column-SharePoint 2010

I have a SharePoint list. It has two columns Start date and End date. I need to query and get data if (start date + 7 days> End date). Through CAML builder its not possible to have a SharePoint column ...
0
votes
1answer
415 views

get last item in caml query

I've an issue with caml query. I'm trying to get the last item created this year but still have only one item while i'm having 4 in my list and remover I execute this in an event receiver itemAdding ...
2
votes
2answers
10k 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 ...
0
votes
1answer
1k views

CAML query managed metadata field using the TermGuid

I have a dropdownlist which I populate with the names and IDs of a bunch of terms from my term store. When I then select a term in the dropdownlist an autopostback happens. When this postback happens ...
0
votes
1answer
166 views

Retrieve all lists and libraries Sharepoint Online

I'm trying to retrieve all lists from my online tenant from Visual Studio. After much fumbling and unsuccessful attempts with: ListItemCollection listItemCollection = oList.GetItems(query); and ...
1
vote
0answers
36 views

AllItems customization

I have a custom list definition where I have defined a view with BaseViewID = 1 (AllItems.aspx) <View BaseViewID="1" Type="HTML" WebPartZoneID="Main" ...
1
vote
2answers
747 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 ...
1
vote
2answers
3k views

How to apply CAML in SharePoint view

I'm using SharePoint client object model and trying to query specific view but not getting the correct method to do so. Here is my code, using SP = Microsoft.SharePoint.Client; using ...
1
vote
4answers
3k views

Filter list data using SPServices, CAML Query, and dropdown list

I'm trying to create a table using SPServices to fetch the data, and filter it using CAML Query and a drop down list. I would like to create three conditions: A. If no item from the list is selected, ...
1
vote
2answers
547 views

CAML query multiple values javascript

When I run the following query I get an error: <View><Query><Where> <Or><Eq><FieldRef Name='ID'/><Value Type='Number'>164</Value></Eq> ...
4
votes
2answers
10k 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
4answers
68 views

whats wrong with my query CAML

$caml = '<Where><AND><Neq><FieldRef Name="marking" /> <Value Type="Text">Off-S</Value></Neq><Neq><FieldRef Name="marking" /> <Value ...
2
votes
4answers
6k views

CAML Query Filtering with OffsetDays

I'd like to set up a CAML query in a Data View Web Part (DVWP) that works like this: If a date is not specified on the Query String, then show me items created in the last 30 days If a date is ...
0
votes
2answers
48 views

Ordering CAML results

Follow up to this question: CAML is ordering by content type even though not specified I have the following query: <Where> <And> <Or> <Eq> ...
2
votes
2answers
7k views

How to write CAML Query with more than 3 AND Condition

I have search and see the way how to write CAML Query with 3 AND conditions. However, I am not sure how to write CAML Query with more than 3 AND conditions may be with 4 or 5 AND conditions. Can any ...
0
votes
2answers
86 views

CAML query for returning a single field

I'm trying to get a single field from a list. The list has columns like this: Office365Account - Type: Person Email Address - Type: Email Manager - Type: Person Basically what I want ...
0
votes
1answer
41 views

Query List with large number of items to perform aggregation

I have a scenario where there is one list with 3 columns : Col1, Col2, Col3 For each value of Col1 there would be 100 unique Col2 values. And for each Col2 values there would be 1000 unique Col3 ...
1
vote
1answer
56 views

caml query issue A or B

I have an issue with caml or query problem: <Where> <Or> <Eq> <FieldRef Name='Editor'/><Value Type='User'>x</Value> </Eq> <Eq> ...
1
vote
0answers
48 views

Query returns fewer fields depending on credentials

I inherited some code that reads in all the files from a Document Library for processing. The existing production library is a standard library bound to an InfoPath form. A new version of this library ...
0
votes
3answers
55 views

do you see anything unusual with this CAML

I am looking for list items where workflow status equal "Error Occurred". I have the following code and it's working fine. However, there are 124,000 items in my list and the code goes through each ...
0
votes
1answer
387 views

Using UpdateListItems for multiple items?

I would like to use UpdateListItems or something similar to allow my users to pass in some variable (e.g., a name) so I can use a caml query to find all items where SomeUserField = 'John B Smith' and ...
6
votes
5answers
25k views

How to get current user with javascript?

I have a list . I want select items of list with a special quary.(get items that created with current user). Then get count of items. I use this code for get current user : function Initialize() { ...
1
vote
1answer
2k views

Lookup field value in CAML, Client Object Model

I am using the .NET Client Object Model from a website to access data in a SharePoint list. One of the fields I am trying to access is a lookup field. How do I get the text for the lookup field using ...
0
votes
1answer
125 views

CAML query where to get all items

I am going to implement a search query. I have 2 inputs user can give value or leave as empty. If user leave both input as empty and Search,,all items must populated. here I have static SP CAML query ...
0
votes
1answer
100 views

Performance : Caml query taking long time to load or something else

I have a CAML query which provides a result, if a SPfolder exists or not. When i do the item.Count it takes around 2sec for the line to execute . What is going wrong and taking long time to execute ...
2
votes
1answer
2k views

date filter of today in rest api

I have a caml query filter for one of my date-time field. <Leq> <FieldRef Name ='StartDate1' /> <Value Type ='DateTime'> <Today /> </Value> </Leq> Is ...
0
votes
1answer
1k views

Get grouped items by “Group by” and applied pagination

I use "Group by" CAML element to group items and also want to applied pagination(10 first grouped items) to SPQuery. But SPList.GetItems(spquery) returned 10 items without grouping them. My code is as ...
0
votes
1answer
561 views

Join three Lists in CAML

Suppose that we have three tables(Three Lists in SharePoint).The relations between tables are described by the following image. I want to translate the following query to CAML query: select c.* ...
1
vote
2answers
438 views

Why does my console output contain html tags for some field values?

I created a custom list which contains different field values e.g. Text Choice Note Currency Peoplepicker Using the following code I print the field values to console: List mealList = ...
0
votes
3answers
458 views

What does the Author property mean in the query service?

I'm using the query search services of SharePoint and I'm not able to find in the MS documentation if the Author property matches the Created By, Modified By or both (or something else :)). Any ...
0
votes
1answer
457 views

SP2013 - CQWP query override for tasks assigned to me

I'm using a CQWP, and I need to add more than three filters. The filters I want are: Status is not equal to Completed Status is not equal to Deferred Due date is less than Today Assigned To is equal ...
1
vote
5answers
797 views

Translating a SQL query to CAML query

I am new to CAML query and as much as I have expected it to be simple like SQL I have found it quite frustrating to deal with. I have a simple query SQL query I am trying to translate into CAML but do ...
0
votes
2answers
654 views

Filter List for DateTime using CAML against Calculated Field

In WSS 3.0, I have a list with a Calculated Field, 'MaxDate'. It gets the greater of two other dates, Notional Date and Override Date. I am trying (and failing) to build a CAML query to get all items ...
0
votes
1answer
866 views

SQL Not IN equivalent in CAML

I have two list(subject, subjectcategory). subject(ID,Title,CategoryId) subjectcategory(ID,Title) I want to create a CAML query for SharePoint that does something like this SELECT ID, Title ...
3
votes
2answers
2k views

SP 2010 - Client object model (javascript) - How to use get_listItemCollectionPosition for paging?

This is my code: When I call the function to get the items, it fails (doesn't go to the fail function, it goes into the success function but crashes when I try to get the position object), and I get ...
0
votes
2answers
592 views

How to use XmlDefinitionLink & CAML to reuse View definitions in multiple XsltListViewWebPart controls?

This is what I want to achieve (in SharePoint 2010): A custom page containing 2 XsltListViewWebPart Both of them rendering the same list data, but with different XSLT definition for display I ...
1
vote
2answers
248 views

Timer Job throws Field types not installed correctly Exception when querying a list

Hi Guys I have this situation: A timer job queries a list and gets items from it. The 2 queries are: <Where> <And> <And> <Leq> ...
0
votes
3answers
5k views

Use CAML query based on ID to retrieve a file name?

With jquery and spservices, I use getSelectedItems to retrieve the IDs of a few documents. Can I have a loop which goes through a caml query for each of those IDs to retrieve the file name ...
0
votes
2answers
621 views

CAML Query returning null

I'm very new to sharepoint and have the following query on my Shared Documents. It is returning null for all three documents I have. I'm wondering where to check in database to see if values are null ...
1
vote
1answer
13k views

How to reterive list item values using CAML query?

I have one Date and time column and text colum. I need to retrieve list item value based on this both column using CAML query.. For ex: Columname---> Date value for date would be-6/1/2013 and ...
1
vote
0answers
113 views

Manage files with no checked in version - CAML query

I am using Office 365. We have a document library containing more than 12000+ documents, with a number of folders and subfolders. I need to find a way to get all document which have no checked in ...
2
votes
3answers
444 views

Need a way to identify files which have no checked in version

I wrote a script that traverses a collection, it's document libraries and gets a list of all files. I'm trying to find all the documents which do not have a checked in version and require a user to go ...
4
votes
3answers
14k views

How to build a CAML query with where clause

I have this CAML below and i'm tring to do something like this. Where username ='username' and id = 'id' <Query> <Where> <And> <Eq> ...
0
votes
1answer
283 views

CSOM query certain date

I have a list that has an end date in. Is there anyway to filter out the dates that are passed todays date? function retrieveCurrentListProperties() { clientContext = new ...
1
vote
2answers
1k views

CAML query not filtering results

Can someone tell me why the following CAML query is not filtering results? It's returning files that do not contain "/Internal/Bug 594" in their FileRef value. Thanks. <View ...
2
votes
2answers
246 views

2010: How to query user profiles for custom properties?

Our sharepoint user profiles are configured to have two additional AD synchronized, public custom properties, EmployeeID and CostCenter. I need to read a list of users with the same CostCenter as the ...
4
votes
3answers
2k views

Is there a way to get Folder object from ListItem one?

This is my first post, so I'd like to say hello to everyone. I'm trying to get Folder object by its path in SharePoint 2010 client application using Client Side Object Model (.Net 4.0). I need to ...