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

0
votes
1answer
64 views

GetFieldByDisplayName error in CAML query

I'm developing a web-part for SharePoint 2010. I've to sort a SPGridView so I use SortExpression. I execute a CAML query in this way and then I bind data to SPGridView: SPQuery query = ...
0
votes
1answer
134 views

Caml query for date range not working [duplicate]

HI am trying to use CAML query to pull the data of list based on date range and I am unable to pull the data with the query i am using. I have column name as 'created' and which is for both fromDate ...
1
vote
2answers
199 views

CAML query daterange not working

I am trying to retrieve list items using date range based on date column. It implicit both 'Fromdate' and 'Todate'.My CAML query is also querying on two other conditions as well. I am using the below ...
0
votes
0answers
220 views

Filtered lookup using SPServices

I have 3 lists: Schools, Interactions, Contacts In the new form for a Interaction item I have a lookup field displaying a long list of contacts, however I need to filter this list to only display ...
0
votes
1answer
61 views

CAML Query and using non user credentials

I have 2 sites for 2 different groups. One group has access to site1 and one group has site2. Each group does not have access to the others site. I have a query however that needs to access each ...
1
vote
2answers
491 views

Multiple CAML query to filter Data list view

My Custom list have four columns(Doc ID, Created by, Assigned To, Assigned date). I want to filter the data in Data list view. In my page there are 4 text boxes and a Button is there for the user ...
5
votes
3answers
782 views

Change sort order in returned ItemsCollection

I am fetching a collection of items from a list using a CAML query. The returned items are then populated in my custom HMTL table. There is, however, another HTML table for which I need the same ...
1
vote
0answers
54 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 Get Property Set Property Add Property And I want to know if it's possible to use these to add a number to the ...
1
vote
1answer
392 views

sharepoint 2010 - How to get document ID using spservices sql search query?

Using spservices to make search requests, I am building the query like this: var queryText; queryText = "<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'>"; queryText += "<...
0
votes
1answer
302 views

CSOM Join with CAML query raise exception

I am trying to retrieve all Customer Contracts which Customer Master has Procurement Relevant = True I used CSOM to communicate with SharePoint 2010 to retrieve list items and used CAML query to ...
0
votes
0answers
445 views

Sharepoint CAML query to select all items that user have shared with it

I secure my sharepoint list using share with, it is done by sharepoint event receiver that share the current added item with all people who could interact with that item. It works well, but when I use ...
1
vote
2answers
1k views

DateRangesOverlap always returns all results

I have a problem with SPQuery and DataRangesOverlap. In my calendar there are three events that don't happen today. In SPQuery.query I want to exclude these events. Unfortunately all events are ...
0
votes
1answer
309 views

Concatenating a javascript variable into a camlQuery

I have a caml query that I'm concatenating with a javascript variable of type string. It queries the column names 'Audience' and returns the first 3 ordered by the newest. The variable subsite gets ...
2
votes
1answer
380 views

Using where clause in caml query

I want to select all items from a list where Title is equal to logInUser (which is current login user name). In my code I have created : var logInUser = context1.get_web().get_currentUser(); But ...
4
votes
2answers
928 views

Camlquery: Getting items from top root folder of list

I know how to get items from a folder inside a list (example below) CamlQuery caml = new CamlQuery(); caml.FolderServerRelativeUrl = "/folder/path"; But how do you get the items from just the top ...
-1
votes
2answers
161 views

CAML query to show _moderationstatus

I am trying to show list items in a publishing page and I am getting all column values except for Approval Status column which should show text as values is showing integers like 0 for Approved ...
1
vote
2answers
360 views

Element “Query” is invalid (GetListItems)

I'm calling GetListItems via spservices, and specifying the CAMLQuery field to be the following value: <Where> <Or> <Contains><FieldRef Name='ows_Title'/><Value Type='...
1
vote
1answer
359 views

Get SPListItem Managed Metadata Field Value

I'm having trouble getting the values of a Managed Metadata Field in a SharePoint List. Basically, what I want to do is given a string (ex. "Category"), it will find all the list items that match ...
0
votes
1answer
175 views

how to write caml query to count item created in each month

I need to write CAML query to count items created in each month.It should give me a count of items created in particular month.
0
votes
2answers
197 views

Update filed values based on conditions

i have document library in sharepoint 2010 and i want to update a field values based on some conditions . I need that every parentid has some documents and i want to update those prosessnos which ...
0
votes
1answer
381 views

CAML query to get data for SSRS from SharePoint list

I am writing CAML query to get data from sharepoint list <RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <ListName&...
0
votes
0answers
226 views

CAML Query for getting folder contents based on folder parameters

I have the following folder structure. Folder1 attr1="cat1" >> file1 attr2="subcat1" >> file2 attr2="subcat2" Folder2 attr1="cat2" >> file3 attr2="subcat1" >> file4 attr2="...
0
votes
1answer
26 views

Search from multiple list in caml querry

I want to search data from multiple tables using CAML query.
2
votes
3answers
2k views

How to get a old version of list item?

I need to get all field values of an specific version. It is possible by sharepoint hosted app (javascript)? I need to create a custom version history page of itens. If there is a caml query ...
0
votes
2answers
420 views

Escaping the ampersand '&' in camlQueryOptions using SPServices when getting items from a folder

I've tried escaping the ampersand using <![CDATA[]], html encoded characters but it doesn't return any results. My query looks like CAMLQueryOptions : "<QueryOptions><Folder>...
0
votes
1answer
543 views

Add filter and pagination to CAML query

I'm developing a visual web part for Sharepoint 2010. I would display all documents from a specific DL, but this DL contains more than 7000 items. So I would like to add a pagination (show only 20 ...
0
votes
1answer
531 views

Using In Operator in SharePoint 2010 Caml Query

I am using the IN Operator in SharePoint 2010 CAML query to get my desired set of results, however, the filter criteria doesn't seem to work and returns all records instead of the filtered set. Here'...
0
votes
5answers
547 views

How to perform/retrieve a CAML Query in SharePoint Designer

I have a standard CAML query (see below) that I would like to perform in SharePoint designer. How do I take this CAML query and retrieve it's data. Also where do I declare the list to run it against &...
0
votes
1answer
131 views

CAML - Understanding when to use Eq, Geg and Value

With the following CAML query: camlQuery.set_viewXml('<View><Query><Where><Geq><FieldRef Name=\'ID\'/>' + '<Value Type=\'Number\'>1</Value></Geq></...
0
votes
1answer
459 views

Is it possible to write a CAML query that will update or insert an entry based on its existence?

I'm working with Sharepoint using CSOM and Javascript. I need to cache usage statistics in a List with one entry per user, updating values in a user's list entry when they interact with the site in a ...
0
votes
1answer
253 views

SharePoint 2013: JavaScript Object Model - Caml Query where list item is selected

How could I use a caml query to only get the list items that are selected using the JavaScript Object Model? <Where> <Eq> <FieldRef Name= ??? /> <Value Type="Integer"...
0
votes
1answer
954 views

How to consolidate JS for CAML queries with multiple filters?

I'm very new at the entire JS/SPServices concept (and JS as a whole) and I'm trying to slim down the amount of JS needed for a few HTML pages. I have several unordered lists on the HTML page that I ...
1
vote
0answers
21 views

Why a pair of FieldRef must be specified for a Join?

I'm writing a small js library to abstract away the annoyance and complexity of creating a CAML query. In that regard, can you explain the significance of both FieldRef elements within a Join, when ...
1
vote
2answers
452 views

GetListItems not returning empty fields even when using ViewFields

I am using the GetListItems web service to query a list. I am passing the viewFields property to return certain fields: var viewFields = XElement.Parse(@" <ViewFields> <FieldRef Name='...
0
votes
3answers
2k views

Is it possible to have CAML Join without Lookup Columns?

I am new to SharePoint. I am developing a web-part in that I am trying to join two list. I have a same web-part in that lists were join using LINQ query. But it takes more time to fetch the data. So ...
-1
votes
1answer
62 views

JSOM function not getting called

I have two functions in my js file. Each function is used to fetch data from list. The first function is called as: jQuery(document).ready(function () { SP.SOD.executeFunc('sp.js', 'SP.ClientContext',...
1
vote
1answer
164 views

Query the Author column using login “domain\user”

I need to query a SharePoint list and specifically the Author column with a given login in the form "domain\username". I read that I must switch the column's "Show Field" property to "Account", but ...
2
votes
2answers
440 views

JSOM Anonymously CAML query list items

I am attempting to query a list using CAML via JSOM and am getting the error message The method "GetItems" of the type "List" with id "{GUID}" is blocked by the administrator on the server. I have set ...
0
votes
3answers
1k views

Filter by projected field in CAML - is it possible?

I have a Dealers list with the following structure: ID | Title | DealerCode and DealerLetters list with lookup column (referencing to the Title field): ID | Title | RegistrationNumber | ...
2
votes
0answers
72 views

How to make CQWP retrieve 4 most recent Items in the whole site collection?

I'm a little stuck with one of m Content Query Web Part: On my homepage, i would like to display the 4 most recent items added to my site collection in a Content Query Webpart called "What's new?" So ...
0
votes
1answer
232 views

How to write Join 4 lists using CAML Query (CSOM)

I have four lists in my site. I need to get data from all these lists in CSOM (Provider hosted app). All these lists are connected linearly (one to one). List 1 -> List 2 -> List 3 -> List 4. for eg ...
0
votes
2answers
86 views

CAML Query to Return all rows

I am having Sql Query like // sTitle is my input string string sTitle='something'; Select Title From EmployeeList WHERE Title like '%sTitle%' or 0=sTitle OrderBy Title Desc; How do i Build it in ...
0
votes
1answer
466 views

CAML query datetime - publishingstartdate

I'm trying to get a CAML query working with dates - specifically PublishingStartDate and PublishingExpirationDate. When scheduling an item, there is the option to select 'immediately' and 'never' ...
0
votes
3answers
876 views

Caml Query to find items with different values in two fields?

In a list, I have two managed metadata columns (let's say Tax1 and Tax2). I'm trying to find all items where values in Tax1 and Tax2 are different. I'm using this query: <Where> <Neq&...
1
vote
1answer
341 views

Caml query when Title field contains Plus (+) sign

This CAML query is not working if Title field contains Plus (+) Sign. My query is : function createSACQuery(Title) { var qry = new SP.CamlQuery(); qry.set_viewXml('<View Scope="...
0
votes
1answer
82 views

Why using Decimal in this CAML Query is not returning correct records?

I have the following table: DoubleNumber ------------- 10.50 44.77 88.90 I am using the following CAML Query: query.Query = "<Where><Contains><FieldRef Name=\"DoubleNumber\"/><...
0
votes
2answers
213 views

What is wrong with the following Caml query

I have the following table with columns: Editor | _UIVersionString | Title | LookupNumber | Author a | b | Title1| 100;800 | admin I use the following query caml <Or&...
9
votes
2answers
16k 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> <...
6
votes
4answers
8k 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)
1
vote
3answers
1k views

Hard code group name into CAML query

I am trying to hard code a user group into a CAML query's where clause. The reason is so that I can apply additional criteria when the user is in one group, and something else if they are in another ...