method for querying list data
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
2answers
44 views
How to get display name from created by field in sharepoint client object model?
In my sharepoint javascript code, I am retrieving items from a list in my SP 2010 environment. I used a camel query to download specific fields. One of the fields was created by (person who created ...
0
votes
1answer
369 views
How to use XmlDefinitionLink & CAML to reuse View definitions in multiple XsltListViewWebPart controls?
This is what I want to achieve (in SharePoint 2010):
A custom page containing 2 XsltListViewWebPart
Both of them rendering the same list data, but with different XSLT definition for
display
I ...
1
vote
2answers
71 views
CAML Query works in my VS2010U, but not on anybody else's computer
I have a list with records uniquely identified by project numbers. This is column 5 - Col05 in my list. It works fine when I run the code, and I am getting the expected record. I can also read the ...
2
votes
2answers
52 views
Caml query to get the next event from calendar
I'm facing a problem building a caml query for the calendar list.
Here is my caml query
SPQuery query = new SPQuery();
StringBuilder sb = new StringBuilder();
...
1
vote
1answer
276 views
Expand recurrence and CalendarDate:Event EndDate not autocalculated for recurring events
I have done the following code to save a recurring entry to Calendar List named Bookings.
SPSite site = new SPSite(SPContext.Current.Web.Url);
using (SPWeb web = site.OpenWeb())
{
...
1
vote
1answer
1k views
COM exception while querying document library
I have a need to get collection of SPLitsItem currently viewed to user. My solution is a ribbon button which calls custom application page in LAYOUTS via javascript in custom action.
Application page ...
1
vote
4answers
400 views
How to get the nth record using CAML from list
How to get the nth record (lets say 133rd) from the 1000 records (or unknown number of records) by using CAML query.
0
votes
2answers
2k views
SPListItemCollection Get ItemCount with rowlimit
I am filtering a list in caml
SPQuery oQuery = new SPQuery();
oQuery.Query = "<OrderBy><FieldRef Name='FullName' /></OrderBy><Where><Contains><FieldRef ...
1
vote
0answers
32 views
getting top X items in each folder with a CAML Query
i'm trying to do a visual representation of a document library using javascript and webservices.
basically i want to present the folders in the library, with a preview of the first few files in each ...
2
votes
0answers
180 views
CrossListQueryCache().GetSiteData(contextWeb) throws NullReferenceException on second query?
I have an auqward problem that's been nagging me on and off for half a years time. It turns out, when I'm finally taking a real shot at it that my query throws a NullReferenceException the second time ...
0
votes
1answer
19 views
Problem with multiple text filters
I have a custom list that has a text filter connected to allow the user to filter one of the list columns. I now need to add a second XOR text filter to allow the user to filter on a different column ...
1
vote
0answers
33 views
CAML Query on a Calculated Lookup Field
I wrote some CAML Queries to modify the View of a List and all is working fine as long as I do not reference a Lookup Field which points to a calculated Field.
I tried different types in the value ...
0
votes
2answers
339 views
Problem with Calendar CAML Query
i have a problem with a CAML Query for a Sharepoint Online(Office365) Calendar. I try to get all Calendar Appointments between two dates. Here is my code:
private void getFreeDays()
{
...
1
vote
2answers
1k views
How to apply CAML query on the Calculated Column of the list?
I have a calculated column that stores the calculated date value.
When I apply the CAML query, it does not return any row even if the record exists.
Can any one please guide me on this topic>
...
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 ...
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 = ...
0
votes
1answer
25 views
How to list all alements by CAML to SPGridView
Is it possible to display the listitems retrieved from a CAML query in a SPGridView?
How can I implement it?
0
votes
0answers
63 views
CAML Designer: Could not load file or assembly 'Microsoft.Sharepoint
I am new to sharepoint, and this community. I have a CAML Designer program (http://karinebosch.wordpress.com/2012/05/12/caml-designer/) that I want to use to run queries on my Sharepoint Online lists.
...
0
votes
2answers
83 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 ...
0
votes
1answer
34 views
How to create field with formula using CAML XML
Suppose I need a DateTime field that shows the current date + 30 days
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 ...
0
votes
3answers
35 views
CAML Query: use the value of a property of a lookup
My project consists of two lists:
a list of documents. This list has an SPUser field that determines who is responsible for that document.
a list of projects. This list has a multiple lookup to the ...
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
281 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 ...
0
votes
3answers
114 views
Better way to get a SPListItem by Field
I want to get a SPListItem from a SPList where a field match a value. I have to ways to do it, CAML and LINQ.
My code is:
LINQ
...
SPList list = Web.Lists["MyList"];
SPListItem item = (from ...
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
25 views
CAML : Cannot complete this action
It seems my following query is failing and throwing "Cannot complete this action".However when I test this query in CAML Query builder it's working fine.
<Where>
<And>
...
0
votes
0answers
54 views
CAML Query on External Content Type not honoring the <In> operator
So I've been testing this out for a day or so. For the life of me I cannot get an external list to listen to honor the <In> operator in CAMLQuery. On any other type of list it seems to work ...
0
votes
3answers
253 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
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>
...
0
votes
2answers
140 views
Left Outer Join in SharePoint 2010
I have 2 lists in SharePoint 2010. First List E lists all locations.
In the second list H I use first E list as lookup for Location. Every month users inputs information in list H.
List E has ...
2
votes
3answers
985 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)
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.
...
1
vote
1answer
57 views
CAML batch query - valid XML?
The standard format of a CAML batch query is as follows:
<?xml version="1.0" encoding="UTF-8"?>
<ows:Batch OnError="Continue">
<Method ID="">
...
0
votes
0answers
59 views
CSOM expand user / people field
I have a "Contact" person field and want to access the expanded properties of the field, name, account and work email.
With REST, you can use $expand and project fields like this:
...
2
votes
1answer
163 views
ContentTypes and Site Columns via Visual Studio / CAML Query Updates broken
I've been using CAML queries to do list updates for quite some time, but recently they've stopped working, and I have no idea why. Even an extremely simple query seems to be failing. For example the ...
2
votes
2answers
196 views
Get SPQuery TotalItems from query
I want to get the total number of items that match my Query, BUT also limit the results.
So say I have 100 items in the list.
50 of the 100 items in the list match my query.
I want to only get 10 ...
1
vote
1answer
444 views
How do I select only top level folders using CrossListQueryCache?
I want to select the list of folders (without subfolders, not recursive) of a Document library using CrossListQueryCache.
Everything is working fine except that i am receiving ALL the folders and ...
1
vote
0answers
64 views
Complex CAML, where parameter is null?
I have a page with 2 webparts
One webpart is just a form with a textbox.
2nd webpart is listviewwebpart that filters based on the first webpart input.
However the user wants that when the page is ...
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?
0
votes
1answer
261 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}" ...
2
votes
1answer
75 views
Help Return Lists With With No List Items
This is my first time posting and I'm looking for some help, so hopefully someone has an answer. I used the search, but didn't find anything.
I created a custom list definition, and content type ...
1
vote
1answer
367 views
Search document from document library usin CAML query
I have document library which have folder and sub folder. the folder and sub folder level is more than 5. like as follow :
Document Library
|-> Folder-1
| -> Folder-1-1
| ...
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 ...
2
votes
1answer
917 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.
...
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
3answers
547 views
how to check CamlQuery results
.I am running below query against a sharepoint list.
How to check the results of below Camlquery? cPop is set with value 'AboutUs'.
Result is always zero records although list has valid matching ...
5
votes
5answers
952 views
When I execute a CAML query, how do I know what ListItem details I can include?
I was querying a SharePoint library, trying to retrieve some file attributes. Apparently some things like FileType and Date are not supported, even though those fields are listed as a built in field. ...
0
votes
2answers
171 views
CSOM list query with JOIN, return tree structure
I have two lists, Parent and Child. The Child list has a lookup field called "Parent", which "looks into" the Parent list, using ID column.
Using CSOM I'm joining the lists with this query
...
