Collaborative Application Markup Language (CAML) is an XML-based language that is used in Microsoft SharePoint Foundation to define the fields and views that are used in sites and lists.
4
votes
4answers
2k views
Multiple Values in CAML query from Array? SharePoint 2010 using jQuery/SPServices
So if I use SPServices to GetListItems with CAMLQuery, is it possible to insert multiple values inside Value Type='Number'> here
I would like to evaluate things throught a flow in my page, add to an ...
4
votes
2answers
2k views
CAML vs LINQ vs SQL
So
LINQ is a front end to CAML so of course CAML is faster, and CAML is a front end to SQL so of course SQL is faster.
However what would be a good test to see where and when to use each of these on ...
4
votes
1answer
206 views
Error using javascript to retrieve a SharePoint list's items
I am trying to use this method to query items of a column of a list in my SP site via javascript (the reason I am doing this is to display that info on the page by modifying the html tags in the DOM), ...
2
votes
1answer
44 views
CAML Query where X =(A && B && C && D)
CAML makes me sad some days. Can someone point me in the right direction for the syntax in regards to a CAML query that would evaluate where X= A&B&C&D. My nesting is all off i'm assuming.
...
2
votes
2answers
454 views
CAML query to retrieve the second set of three list items from the announcements list?
The CAML query to pull say 3 items based off of the following requirements seems pretty starightforward:
Title is not null
Expires(Expiry Date) is greater than or equal to Today
Order Created in ...
2
votes
1answer
27 views
is querying a perticular folder faster?
I have a folder in document library
if I get the folder from folder collection of the document library and only query the items inside that folder will it work faster then querying a whole library ...
2
votes
2answers
255 views
SPQuery works on libraries under the list view threshold, but not over
So I am building a webpart which enumerates all doclibs in the current web, grabbing all checked out files and listing them in a table, allowing a user to apply some required metadata and check in ...
2
votes
2answers
217 views
CAML Query behaving differently in CAML Builder and Code
Based on feedback from my earlier question, I have constructed a query using the excellent CAML Builder tool:
<Where>
<Or>
<Membership Type='CurrentUserGroups'>
<FieldRef ...
2
votes
1answer
200 views
CAML Query OrderBy ignoring non set values
I'm currently writing some CAML Query for a QueryOverride in one of my Content Query Web Parts as I'm in need of multiple "Sort by" fields.
My issue is that one of the additional fields that I need ...
2
votes
2answers
711 views
Multiple fields to same list in join (CAML)
Current situation:
=============
In my example, I've got 2 custom lists:
Accounts
Addresses
In the "Accounts"-list I've created 2 lookup columns to the "Addresses"-list
Address1
Address2
When ...
2
votes
1answer
152 views
Caml Query - skip X first results
Let's assume I have list with 100 items. Is it possible to write CAML query to get 5 items, but skip 10 items from the beggining? Something like LIMIT and OFFSET in SQL?
2
votes
2answers
132 views
How to Add a ListItem?
I am able to add an item to a list using the CAML below. Now I need to modify it to make sure I can add an attachment as well. What is the syntax to add an attachment?
<?xml version="1.0" ...
2
votes
0answers
66 views
How to find out whether or not a list is hidden without writing code (SP2010)?
Does anyone know if there is a way of telling (without writing any code) whether or not a list is "hidden"?
I have a CAML query which contains the following and I'd like to eliminate the possibility ...
2
votes
1answer
915 views
How to retrieve items from document libraries using client context without performance lag
I need to retrieve items/list items from SharePoint 2010 document library and display it in a list ListView using C#. I have used following CAML query to retrieve list items and its properties.
...
2
votes
1answer
174 views
Add content type from sandboxed solution to list definition (farm solution) does not work
I'm using a sandboxed solution from a 3rd party vendor which contains some site columns and a site content type.
I want to add this content type to my document library definition in CAML.
But when I ...
1
vote
1answer
32 views
Can I sort CAML queries by multiple fields?
I have the following query:
<query> \
<Query> \
<Where><Eq><FieldRef Name='FSObjType'/><Value Type='Lookup'>0</Value></Eq></Where>\
...
1
vote
2answers
252 views
Error in CAML Query with multiple “AND”
When I run the following query I get an error:
<Where>
<And>
<Eq>
<FieldRef Name="IssueLOB" LookupId="TRUE" />
<Value ...
1
vote
3answers
2k 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 ...
1
vote
1answer
62 views
extend caml token ?
is there an hook or interface or whatever that could be used for extending token functionality of sharepoint? For example [Me] token is insufficient for me and I would like to for example develop my ...
1
vote
3answers
535 views
how to query multiple lists using CAML
I have requestID, date column in 4 different lists. I want to build a webpart which shows user requests of different types therefore i need to query multiple lists with column requestID and date.
How ...
1
vote
3answers
170 views
Using a variable in alert filter (CAML/C#)
Environment: SP2010 Enterprise, VS2012
I've been using C# to programmatically create alerts for various users and implementing the alert.Filter property to assign filters that point to specific ...
1
vote
1answer
777 views
CAML Query to pull list items only if their approved?
Although the solution seems relatively strightforward it doesnt seem to work.
Here is my CAML query to pull all items from a list that have been approved through the OOTB Sharepoint Approval ...
1
vote
1answer
3k views
Querying a simple list with a 'User' column, using CAML
I'm having some trouble getting a CAML Query working against a very simple list.
My custom list has the fields:
Person : User
Date : Date
Amount : Lookup
My query looks like this:
<Query>
...
1
vote
1answer
93 views
CAML Query results every time 0 items
I try to filter items in the list by using caml.
The List contains elements that matches the Filter.
The code:
enter code here
SPQuery qry = new SPQuery();
qry.Query =
@" ...
1
vote
2answers
412 views
CrossListQueryInfo\SPSiteDataQuery how to skip items with specific WebId?
Customer wants to see 10 news items from all webs on front page.
Also customer wants to specify some news that we should skip.
I am trying to do next thing:
var id =1;
<Neq><FieldRef ...
1
vote
1answer
234 views
Using the value from a lookup column, obtained with REST, as a dataview parameter
I was wondering if you could help me with something.
I have a list called Site Configuration. One of the columns is called Package Level (Package_x0020_Level) and is a lookup that looks at the ...
1
vote
1answer
295 views
Caml for “multi lookup has no values” condition
I need to get items from my list where multiLookup field contains value (for example, value is 42) or has no values.
First part is simple:
<Eq>
<FieldRef Name='mlookup' LookupId='true' ...
1
vote
1answer
519 views
How do I convert CAML to use in the CQWP?
I have the following CAML query which returns checked out files.
<Query><Where><Eq><FieldRef Name="CheckoutUser" /><Value ...
1
vote
2answers
123 views
Provision a file through a module (CAML) and choose its Content Type
How do you provision a file through a module (CAML) and choose its Content Type? Is it even possible? The normal behavior for a new item is to get the default content type.
1
vote
0answers
27 views
Sharepoint Webservice not filtering Data
Working Version
Issue: I am querying SharePoint using SP CAML Query Helper. Using SPCQH I am able to retrieve one order. The query works.
Once I add the query to my Biztalk solution the query below ...
1
vote
3answers
128 views
Web service based CAML query breaks 5,000 item limit
I have a CAML query of the form shown below which is called via the Sharepoint web service interface to search the entire Sharepoint site containing 600,000 documents looking for documents:
...
1
vote
1answer
86 views
SharePoint 2007 List as Datasource for SSRS 2005 - Query invalid and formating SharePoint Dates?
I have this XML query that pulls all entries and fields from a SharePoint list.
<Query>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
...
1
vote
1answer
44 views
Can we query and fetch data from LIST between different subsites using CAML Query.?
Have LIST created under one site, can the same LIST be used to fetch data from other site using CAML Query.?
eg:
Consider a LIST "xxx" created under SitePages/AAA/Lists/
Can i access the LIST "xxx" ...
1
vote
0answers
81 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>
...
1
vote
0answers
67 views
How to check value from other sharepoint list?
I have two custom lists in SharePoint 2010 (Absent Request and Employee Leave Balance) with these columns:
Absent Request List: Absent Type, Approver, Start Date, End Date, Absent Reason
Employee ...
1
vote
1answer
157 views
Open in new tab document link item from document library
I have a document link item that points to a URL. This item is inside a document library.
Is there a way to make this item open to a new page?
I opened the aspx file it creates, but I am unsure how ...
1
vote
1answer
420 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 ...
1
vote
2answers
204 views
CAML Query List by months
I was wondering if i have 3 random dates.
11/12/2012
9/24/2011
12/29/2008,
I'd like to have
September
9/24/2011
November
11/12/2012
December
12/29/2008
instead of using the query to sort by ...
1
vote
1answer
116 views
grabbing a column from a list
I'm having an issue when I'm trying to grab a column I made in the tasks list (it's a lookup column). for some reason when i'm try to access it with javascript i always get an exception that it isn't ...
1
vote
2answers
619 views
Query for retrieving managed metadata column where the column values are a subset of a list of values
In CAML, if I have a managed metadata column with multiple values, you can determine if one of a list of values is in the column using the following query (where the order of the Values/FieldRef ...
1
vote
1answer
348 views
SP2010: Strange behavior querying on taxonomy field
I need to query a document library to get items associated with some taxonomy terms, or items with specific documentId (site collection scoped feature, not the integer ID of the item), but the whole ...
1
vote
0answers
48 views
Calendar repeating alert
I have a sharepoint calendar which I would like to send out alerts for recurring appointments.
All the appointments are on a monthly basis, e.g. every 3rd of the month.
I have a reminder web part ...
1
vote
2answers
184 views
When using Sharepoint Client Model I get error : The 'Contains' member cannot be used in the expression
When using 'Contains' in Linq query:
var camlQuery = new CamlQuery();
var listItems = list.GetItems(camlQuery);
var itemQuery = listItems.Where(i => ...
1
vote
0answers
109 views
Sharepoint - caml join with numbers
I have done a join in Caml with my list (example list A) to another list (example list B)
One of the fields in list B is a number of 2 decimal places.
However, in the view it is displaying lots of ...
0
votes
2answers
58 views
CAML Query Issue A or B and C
I'm trying to write a CAML query with the following parameters and I'm not having much luck.
It should be simple enough but I can't figure it out.
WHERE (X) EQUALS (A or B) And C
I'm hoping someone ...
0
votes
2answers
328 views
DVWP CrossList Paging Does Not Work
I've build a Data View Web Part with SharePoint Designer 2010, using SPDataSource and DataSourceMode="CrossList". The DVWP works great, but when I add paging, it adds the paging placeholder and the ...
0
votes
2answers
709 views
CAML query returning everything?
I am busy messing around with lists and CAML queries:
SPQuery query = new SPQuery();
SPList list;
SPListItemCollection collection;
query = new SPQuery();
query.Query = ...
0
votes
1answer
12 views
Is there in CAML any equivalent of SQL query Prepare
I'm looking for any equivalent of SQL query Prepare in CAML. Could You help me.I need optymalization in CAML.
0
votes
1answer
41 views
SharePoint 2013: Creating Site Columns using CAML
I had a SharePoint solution which is working perfectly in SharePoint 2007 and SharePoint 2010.
The solution contained Site Columns that were created using CAML (XML Files). Further I created a ...
0
votes
1answer
164 views
CAML Query to get Lookup field value
I've written an autohosted-app to show a few data that are in a list.
To get the data in the list, I use this piece of code with a CAML Query.
using (var clientContext = ...
