Tagged Questions
1
vote
0answers
73 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
0answers
55 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:
...
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
1answer
355 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
| ...
2
votes
0answers
177 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 ...
1
vote
2answers
196 views
CAML Query for Values Not “In” (with sufficiently different title to let me post the question)
I have the following CAML query:
<Where>
<In>
<FieldRef Name='ObjectID' />
<Values>
<Value Type='Integer'>71</Value>
<Value ...
0
votes
1answer
50 views
CAML search ignoring diacritics
A rather strange request has appeared from our client, who wants to be able to search a SharePoint 2010 list for items (based on a string column) while ignoring diacritics.
A quick example, assuming ...
0
votes
0answers
890 views
Join With Camlquery for Lookup Column Field
there are 3 List on My Scenario :
1) Tasks : Columns like this :
(Column Name) Title
--------------------------
TitleTest
TitleTest2
2) List1 : Column ...
0
votes
1answer
204 views
how to query greatest ID of each value in a Sharepoint list?
I have a list with two columns (ID,Value).
I want grouped list with value columns then select greatest Id of it.
ID | Value
1 | 101
2 | 305
3 | 102
4 | 101
5 | 305
6 | 101
Result :
ID ...
0
votes
1answer
184 views
SQL Not IN equivalent in CAML
I have two list(subject, subjectcategory).
subject(ID,Title,CategoryId)
subjectcategory(ID,Title)
I want to create a CAML query for SharePoint that does something like this
SELECT ID, Title
...
5
votes
3answers
542 views
sharepoint caml is fast - how?
We all know that Caml is faster than using linq, since linq internally gets translated to caml.
But can anyone explain how caml is best to do sharepoint queries or how it is fast or what makes it ...
3
votes
2answers
3k views
Filtering items in a view using a CAML query
I'm having trouble querying SharePoint in such a way, as to combine a view results with my own CAML query inside a WCF service. It seems GetItems ignores my query, and just returns all the items in ...
0
votes
0answers
126 views
How to create charts with custom filters about sensitive data using JS without using external APIs?
I need to create charts out of business data which comes out of SharePoint lists in SharePoint 2010. The solution needs the ability to easily filter the data by custom queries, just like the SPJS ...
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 ...
2
votes
4answers
632 views
where clause is ignored when query list
I have a CAML query which returns lists by a lookup field.
here is the query
<Query>
<Where>
<Eq>
<FieldRef ...
0
votes
1answer
466 views
Caml query returning multiple lists
Trying to load a list from library containing two files. The following code when tested in CamlBuilder it is returning single row according to the filename selected. But in the program it is returning ...
0
votes
1answer
363 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 ...
0
votes
1answer
445 views
SPQuery works on ListViewByQuery but not with GetItems
In one of my webparts, I have a ListViewByQuery displaying some elements (or all) of a specified list. The SPQuery is built dynamically depending on the search fields.
Here is how I build the ...
2
votes
1answer
1k views
How to make a CAML Query union?
I have a webpart with several CAML Querys that look like this:
SPSiteDataQuery qry = new SPSiteDataQuery();
qry.Lists = "<Lists ServerTemplate='104' Hidden='TRUE' />";
qry.Webs = "<Webs ...
1
vote
1answer
140 views
Is it possible to find out what template was used to create a site using the SOAP service?
I am connecting to a SharePoint 2010 server(which I don't control) using the SOAP service (.asmx)
I need a list of sites which were created using a certain template.
Is it possible to create a CAML ...
1
vote
1answer
628 views
CAML Query for getting all files underneath a folder with treepath
I tried the U2U Caml Query Builder but I think it doesn't use the Recursive-Attribute the right way.
I'm trying to build a query for getting all files underneath a folder (there a several folders ...
0
votes
3answers
2k views
How to select MAX field in CAML query
RowLimit seems not working. I'm using it in CAML query to run a SSRSreport. I have to pick the Max date for each user. i sorted the user as descending and set the RowLimit element as 1. But that does ...
