An XML-based language that is used to build and customize Web sites based on SharePoint Team Services from Microsoft.

learn more… | top users | synonyms

3
votes
2answers
13k 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 ...
11
votes
5answers
36k 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
44 views

Bug in Updating SharePoint list via javascript

here is My code : console.log(query); camlQuery.set_viewXml(query); collListItem = oList.getItems(camlQuery); clientContext.load(collListItem); clientContext.executeQueryAsync(function (sender, args) ...
0
votes
0answers
21 views

Error in updating batch list item

Here is my code: var clientContext = SP.ClientContext.get_current(); var oList = clientContext.get_web().get_lists().getByTitle('FlexMasterList'); var oListItem; var i=1; var j=0; for(i=1;i<...
0
votes
1answer
45 views

CAML Query is not filtering anything when using a Person or Group type column

I'm trying to get a list count based on the CAML query below, but it keeps returning zero. It should return the number of projects assigned to a designer (person or group type column) which their ...
0
votes
2answers
1k views

How to change a date format in CAML

I got a wrong date format to a CAML. I have got (yyyy-mm-dd) and must to be understand by CAML to the format(dd-mm-yyyy), how can I do this. I tried by String.Format("{0:yyyy-mm-dd}", dateISO1);, but ...
7
votes
4answers
37k 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 ...
2
votes
1answer
20 views

Caml Query between data-times?

I want to query all items within 7 days and I have the following code which is working perfectly: DateTime startDate = new DateTime(DateTime.Today.Year, DateTime.Today.Month, DateTime.Today.Day); ...
1
vote
1answer
15 views

DateTime error with Caml Query?

I have created a column in SharePoint named Data e skadimit të kontrates and I am trying to query this column with the following query: queryMuaj.Query = @"<Where><Eq> &...
1
vote
2answers
36 views

How to query with 3 Conditions? CAML QUERY

I have the first query: queryMuaj.Query = "<OrderBy>" + "<FieldRef Name ='testb' Ascending = 'TRUE'/>" + "</OrderBy>" + ...
0
votes
1answer
41 views

How can you get results from a SharePoint document library (with folder and child items) in a SSRS report?

I have a SSRS report that uses a SharePoint document library as a data source. The issue is that the list has folder and in those folders are child items. The dataset is only returning items from the ...
3
votes
4answers
14k views

Using Date offset in CAML query

In SharePoint 2010, Inned to get items from a list based on a condition. Considering one of the fields to be 'EventDate' of type DateTime, the condition is: (EventDate - 60 Days) <= Today <= (...
3
votes
4answers
115 views

SP - CodError with CAML query,

I want go get last record field value from my SPList with CAML query. Really code working but gives me following ERROR... My Code: void ddCarNumber_TextChanged(object sender, EventArgs e) { try ...
0
votes
1answer
642 views

ExecuteQueryAsync not following through to the success/failure function, javascript

I've got a function that checks if a list item (setting) is true and then changes the setting which it does correctly but doesn't execute the second ExecuteQueryAsync functions. In debugging it jumps ...
0
votes
0answers
18 views

Right way to query a Taxonomy field

I have a SP 2013 site. It is connected to Managed Metadata Service. I have some custom lists and there is a Site Column which is connected to one of the Term Sets. This site column is used in many ...
0
votes
2answers
668 views

Sp Services and calendar list

I have a SP Service call which uses GetListItems from a calendar list in SharePoint. I'm using it with the FullCalendar plugin. The events render fine that is not my question, my question is this: Is ...
1
vote
4answers
202 views

How to query with 2 conditions? CamlQuery

I have the following 2 queries: first one is this- 1) @"<Where> <Eq> <FieldRef Name='ReportsTo' /> <Value Type='Text'>" + reportsTo + @"</Value> </Eq> &...
2
votes
1answer
1k views

SPServices Autocomplete and dynamic CAML query

I have two Text filter web parts (Project and Customer Name) with Apply Filters button for one list. There is a SPServices.SPAutocomplete on each and it works great. Now, I want to show the values in ...
2
votes
1answer
2k views

ProjectedFields working in SPQuery but not in the View

I've three lists: Competitions, Works and WorksVotes, linked to each other through Lookup fields. WorksVotes list has Lookup field to Works list, and Works list has Lookup field to Competitions list. ...
-1
votes
1answer
43 views

Caml query with more than 2 or conditions [closed]

var fieldName; var listFields; var CmalQuery; $(document).ready(function () { $('#btnSearch').on('click', function () { txtValue = $('#txtSearch').val(); ...
0
votes
1answer
31 views

What is the limit of nested OR's in a CAML Query?? For each Version?

I'm needing to know what the exact nested CAML Query limits are for each version of Sharepoint? Also are these limits the same for using the IN,INCLUDES Operators with 2010+ ??? Thanks in advance ...
0
votes
5answers
10k views

Jquery to get list items from SharePoint list

I have a work from my time to use jQuery with SharePoint . I have written the code to get list items. When I run in IE it doesn't show any errors to me, but I am not getting the results. Can any one ...
0
votes
1answer
45 views

Display Person's Documents in People Search Results Display Template

All, I am building a people results display template that needs to include a link to an individual's CV in a document library. I've used a SPServices Getlistitem to query the list, but I can't get ...
0
votes
3answers
53 views

Making an dynamic <And><Or> Caml Query

I am Trying to write an Dynamic Caml Query. I did it like This: CamlQuery qry = new CamlQuery(); string qryStatus = ""; string qryCategory = ""; foreach (RiskStatus sta in ...
1
vote
1answer
43 views

How to convert Linq expression representation to CAML query

I have some code to get the fields of a List with some Criteria. Web web = context.Web; List list = web.Lists.GetByTitle("Employees"); FieldCollection fieldCol = list.Fields; context.Load(fieldCol, ...
13
votes
4answers
21k 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 http://www....
1
vote
1answer
866 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.* ...
0
votes
1answer
35 views

CAML to query a recurrent event - SP 2010

I´m using SP CAML Query Helper Online fot getting all the elements of a recurrent event but it only get the general recurrent event. there is possible to get all the days of this recurrent event in ...
4
votes
1answer
37 views

How to return a List<File>, stored in a DocumentSet, based on the Current ListItem?

I have 2 ListItems, each has a DocumentSet with 2 documents each. I'm attempting to download only those Documents attached to the current ListItem. This is my first time working with documentSets. ...
0
votes
0answers
39 views

Show all events ([today]) in Listview including “Recurring events”

I need a calender, which I can filter for events that take place [today]. The recurring events are not showing, when filtering for [today] and StartDate. Is it possible to have such a view with CAML ...
0
votes
1answer
32 views

CAML Query Validator

Is it possible to validate a CAML query (to check whether it is correctly formed or not) before executing it in SharePoint? Otherwise, while executing the CAML query, it gives weird errors, which don'...
0
votes
2answers
26 views

CAML get child folders count

I want to query all folders from a document library and I am using following query <Where> <Eq> <FieldRef Name="ContentType" /> <Value Type="Text">Folder</Value>...
2
votes
5answers
9k 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
1answer
25 views

caml query pass username dynamically in sharepoint hosted app

In my hosted app I have one text field which contains username. I have write following query in lists schema.xml <View> <Query> <Where> <Contains> ...
1
vote
1answer
57 views

Retrieve the Item ID from the Task List Related Item column

Using JSOM, I getting all the task details which are not started. Using CAML query i got all the column values including related item column from Task list var relateditm = $(this).attr("...
2
votes
2answers
120 views

CAML query to filter Datetime

I have to filter data with respect to a field named CreatedDate having type datetime. In input I'm just giving date (not time), I want to fetch all records with respect to specific date (ignoring ...
1
vote
1answer
40 views

caml query for text field(Title field) contains username in SharePoint hosted app

In my hosted app I have one text field which contains username. I want to apply filter on a view which on filtering gives me data related to current user. <Field ID="{fa564e0f-0c70-4ab9-b863-...
1
vote
1answer
47 views

Iterating SPList.GetItems(SPQuery) very slow and times out

I have a SharePoint 2013 Custom List. It has 3 MMS columns, 3 User Columns and 3 or 4 DateTime columns and a Choice Column and 1 or 2 columns of type Text. This list currently has around 2000 items. I ...
2
votes
3answers
921 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 ...
1
vote
2answers
2k views

How to get List Item from sharepoint list based on ItemID

Dynamically I am adding RadGrid to the page. I need to retrieve list item from the SharePoint list. Say I have 10000 items in the list using SPQuery, I will get filtered records as 2000 items. Here is ...
5
votes
3answers
3k views

How to get caml query to return list items created by the current user?

I want a caml query that only retrieves items created by the user currently logged in. I tried this specifier = "<Eq><FieldRef Name='AssignedTo'/><Value Type='Integer'><UserID/&...
0
votes
1answer
38 views

Convert CAML queries to OData Filters

Is it possible to convert complex CAML query to OData filters so that I can use them in REST APIs? Some CAML queries have nested condition and multiple values to be passed in IN operator. Also, ...
0
votes
0answers
20 views

Make this code to Asynchronous to Synchronous call in Javascript using for loop [duplicate]

I am having values in result[15452,33616] when using for loop ,The for loop for i=0 it takes the value of result[0]=15452 ,it is not going to async function.The loop continuing ,after loop over only ...
-1
votes
2answers
65 views

executeQueryAsync function calling not working using for loop

I am having values in result[15452,33616] when using for loop ,the async function taking only last array value (e.g-33616) and fetching the data for that pushing to another array and final push into ...
0
votes
1answer
21 views

Can't make a caml query works for a boolean

I try to take the elemtens in a list where the field "Mise à jour parc" is set to "No" with the boolean type. My field 'Mise à jour parc" has for db name for sharepoint "...
2
votes
2answers
105 views

Calendar List - CAML Query Next Two Events

I need to create a CAML query to obtain the following two events from a SharePoint 2010 calendar: To consider: There may be recurring events And exceptions to events The purpose is to show in a ...
1
vote
1answer
101 views

Keep the same ID on an item copied from another list

Environment : Foundation 2010 I have two helpdesk lists. In List A, the user create the item and an ID is automatically assigned. My workflow is used to copy that item in the list B. However IDs are ...
0
votes
1answer
58 views

Can't get filename of document with REST api/CAML query

Using the rest api to retrieve information about my documents. The documents use managed metadata which isn't expanded correctly when using the stand REST api. So I found this fix which uses REST with ...
0
votes
0answers
25 views

Get Blog Posts By Category (Filter blog post by PostCategoryId)

I Am trying to get filter blog post by category but get an error I suspect its because I am not using the PostCategoryId internal name? but i dont know how to find what this internal name is ...
9
votes
5answers
38k 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 ...