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.
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>\
...
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
15 views
ProcessBatchUpdate has no effect
I have an application I am working on that uses an Event receiver to propagate metadata to a document library. I am trying to use SPWeb.ProcessBatchUpdate to copy the metadata back.
my code looks like ...
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 ...
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
35 views
Need help with getting List Item counts
I have a custom list created that tracks project status by stages. I need to present the same in a chart format. Below is the list information.
Columns
*Project Name
*Development(Phase1)
...
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 ...
0
votes
0answers
15 views
sp2010 CAML In clause and soap and external list?
This is a simple yes/no, mainly as a sanity check: Does the "available as of SP2010" CAML In clause work with SOAP and external lists?
Some background: I've got an external list pulling data via BDC ...
0
votes
0answers
15 views
How to define custom CAML for a Personal View?
Using SharePoint 2010 (no idea how this affects 2007 or 2013), I often use Personal Views for administrative purposes, partly for "security through obscurity," mostly to keep the UI uncluttered for my ...
0
votes
1answer
157 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 = ...
1
vote
3answers
127 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>
...
0
votes
2answers
82 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
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" ...
0
votes
1answer
54 views
Search for specific folder in library with CAML
I'm looking for a way to search for folder which name starts of 'Foo' using caml query in list. How can I narrow results to return only folders?
0
votes
1answer
42 views
How are columns in SharePoint connected to CAML with regards to data submission?
I am trying to make an alteration to an infopath form that was created to submit data to sharepoint. I added a dropdown box and want to submit that data to sharepoint. The submission has been ...
1
vote
0answers
80 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>
...
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
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 ...
0
votes
1answer
91 views
Appropriate List permissions and read/write using visual webpart
I am learning SharePoint and just learned how to develop Visual Webparts and read data through CAML and write data also. I have a portal where I have one site collection and under that site collection ...
0
votes
1answer
287 views
CAML Query in Powershell Issues
I have a powershell script that I am running that executes a caml query to get some list items. The problem I am having is that whenever I execute this query in CAML Builder I am only getting 3 ...
0
votes
1answer
105 views
Adding the other fields in addtional to lookup field in CAML
I have a custom field definition in VS2010 that contains a lookup field (Title). All is well and I can use the Title ref to add items in the SharePoint list UI. in the instance UI, I can also check ...
2
votes
2answers
703 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
150 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?
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), ...
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 ...
0
votes
0answers
403 views
CAML Query for sub folder documents javascript
I'm trying to query for documents in a specified sub folder of a document library. Using U2U CAML builder, I can generate the query and return successfully within it.
However, when I run the query ...
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 ...
0
votes
0answers
30 views
Update successor-listitem when predecessors are finished
In SharePoint there's a list with lots of items. Every item has an ID, some other columns and a lookup-field 'PredecessorOf' (with the ID) to another item. So for example I have this:
I have a page ...
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 ...
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 =
@" ...
0
votes
0answers
90 views
display caml results in sharepoint document library
i want to search in document library using caml and display caml results in same document library instead of any grid or HTML.
i wrote the code to get records from document library, but i am not able ...
0
votes
0answers
222 views
Build CAML query by value from ClientPeoplePicker
I use these lines of code:
<SharePoint:ClientPeoplePicker ID="clpUser" runat="server" UseLocalSuggestionCache="True"/>
JS:
var peoplePicker = ...
2
votes
1answer
909 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.
...
0
votes
1answer
25 views
Longest practical filter for an alert
Environment: SP2010 Enterprise SP1, Server/SQL 2008 R2, VS2012
When building alerts through object model, what is the longest or most complex CAML filter that can be applied to them? Can they be as ...
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 ...
2
votes
1answer
199 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 ...
0
votes
0answers
908 views
How to use CAML IN clause with MultiLookup field? [closed]
After making a long research I'd like to share the solution for executing a CAML query using IN operator dynamically based on a multi lookup field by workflow without any additional coding. Generally ...
1
vote
3answers
533 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
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
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 ...
0
votes
1answer
148 views
How tu change a date format in CAML
I have got a wrong format of date to a CAML. I have got (yyyy-mm-dd) and must to be understand by CAML to the format(dd-mm-yyyy), how could I done this. Please help me. I tried by ...
0
votes
1answer
50 views
How to add id CAML grouping?
I write this code, and I try to group by Ascending or Descending.
<Query>
<Where>
<Neq>
<FieldRef Name='Nazwisko' />
<Value Type='Note'>" ...
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
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 ...
0
votes
1answer
394 views
How to check DateTime condition in CAML Query?
I want to fetch the records from List which are created in Last 5 minutes.
I have written following code, but its not working. giving me error.
<Geq><FieldRef Name='CreatedDate' />
...
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 ...
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 ...
0
votes
1answer
352 views
Caml Join Field Type
I'm having trouble using the Join via Caml.
In a way, I'm having trouble working with 1 field, that is "new window" that the field type is boolean.
My code looks like this:
SPQuery oQuery = new ...
0
votes
1answer
77 views
SP2010 and Report Builder
I have an SSRS report integrated with SP 2010, the data in the report is loaded from a SP list. The current issue that I am facing is not being able to read minimum and maximum date time field for the ...
