method for querying list data

learn more… | top users | synonyms

2
votes
0answers
862 views

IsNull not working in CAML query for indexed fields

So for example I have field 'TestField' which is indexed. How can I caml for items where 'TestField' value is null? My example down here will fail and won't find what I am querying for. <Where> ...
0
votes
1answer
498 views

SPServices - GetListItems - formatting results

I am using SPServices in Sharepoint 2013 to get some results from cutom list named "navigator" presented here: and for this purpose I am using code: <script type="text/javascript" ...
0
votes
1answer
122 views

Need help using powershell to create list items

I based my code from this example it stated it had the ability to create list items with attachments from existing list items in a new list. I liked this example because I would like to archive old ...
0
votes
1answer
307 views

SPServices GetListItems GroupBy

I am using the SPService, the method GetListItems. I need to groupBy the result (distinct). This is my code: var CamlQuery = '<Query><GroupBy Collapse="TRUE"><FieldRef Name="nameA" ...
0
votes
1answer
77 views

Need help with CAML Query

This is my first time using CAML Query. I have a query builder which I can test with. I'm trying to create a query that will look for a specific string of text in the "Title" column, and find the ...
0
votes
0answers
20 views

Requete CamlQuery

My question is to check if my CAML query query is good or not. I want to get items from a list by the email of the current user.
2
votes
2answers
384 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
2answers
359 views

CAML query returns all items instead of one

I am querying a list to return only items matching a certain title, but the query returns all items. It seems I built or execute the query the wrong way: /* SP is an alias for ...
0
votes
1answer
51 views

SPQUERY returns null value

Hi im using sp query to retrieve the items and using projectproperty.Title to get the web name dynamically ,but I got empty value in this data table. q.ViewFields = "<FieldRef ...
0
votes
2answers
35 views

Like 'String*' in CAML

How can I write LIKE 'String*' in CAML? I must create a query to display the folder structure.
0
votes
1answer
56 views

SP Caml Query Date Range

I Have a List Called Alerts with two columns as Start Date and End Date I am Trying to generate a CAML Query that retrives only cloumns for which alerts should display within that DATE range compare ...
0
votes
3answers
3k views

Current User Task using CAML Qurey

Here's my query to get current user task using CAML but it's not working SPUser me = web.CurrentUser; SPList list = web.Lists["Tasks"]; SPQuery qurey = new SPQuery(); qurey.Query = @" ...
1
vote
3answers
192 views

CAML query rertieve all items from a SharePoint list

I have a JavaScript piece of code that I use to retrieve list item from SharePoint by selected options from drop-down list. Depending the selection it would assign a value to a CAMLQuery variable. ...
0
votes
1answer
371 views

CAML strip or remove HTML tags in custom AlertTemplates.xml

is there any way to remove the html tags for text in CAML? I have made a custom alert template when sending e-mails that uses a field that looks like this: <'GetVar Name="DisplayName#{Field}" ...
0
votes
1answer
219 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
44 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
33 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
63 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
179 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
6k 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
404 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
96 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
29 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" ...
2
votes
1answer
135 views

Adding 2 Caml queries in same executeQueryAsync

Is it possible to use two different queries to get to different lists and use them in the same executeQueryAsync() Something like this : var camlQuery = new SP.CamlQuery(); ...
1
vote
2answers
584 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
2k 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 ...
0
votes
0answers
38 views

Calender List events filter today

I have a calender list and various types of events like simple , all day , daily,monthly and yearly recurrence , recurrence with all day. I have to filter them to today. I have created a custom ...
1
vote
4answers
1k 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, ...
0
votes
2answers
253 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> ...
3
votes
2answers
8k 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; ...
0
votes
4answers
52 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
5k 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
36 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
4k 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
75 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
35 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 ...
0
votes
1answer
44 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
38 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
37 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
162 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 ...
5
votes
5answers
19k 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() { ...
0
votes
0answers
32 views

How could I union three list into one view using caml in sharepoint 2013?

I want to create a new view to union the other lists, like SQL query "union all". I have found SPView.Joins but I cannot find syntax like SPView.Unions. How should I write my CAML query in my new ...
9
votes
2answers
11k views

Where can i download the U2U CAML query Builder for Sharepoint 2010?

I have try to download form below links. But the site is not opening. http://www.u2u.be/res/Tools/files/CamlBuilderSetupv4.0.0.0.zip . http://www.u2u.be/res/tools/camlquerybuilder.aspx ...
1
vote
1answer
1k 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
90 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
62 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 ...
1
vote
1answer
1k 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
0answers
97 views

Query for recurrent events with combined <And> operator

I can query a calendar for its events including the recurrent ones. But I can't get it work to further filter the result set by applying logical operators. For example the list Calendar has a ...
0
votes
1answer
561 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
322 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.* ...