method for querying list data
1
vote
0answers
25 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
2answers
41 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
0answers
22 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
1answer
18 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 ...
0
votes
1answer
87 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
42 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 ...
0
votes
1answer
18 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
2answers
66 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
votes
0answers
17 views
Join 2 list with 2 columns [closed]
I have list1 (projectname(PK),submittedDate,a1,a2)
and list2 (projectname(FK),submittedDate,b1,b2)
I wanna join like this: list1.projectname = list1.submittedDate
and list2.submittedDate = ...
0
votes
1answer
30 views
How to create field with formula using CAML XML
Suppose I need a DateTime field that shows the current date + 30 days
0
votes
3answers
33 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
38 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
50 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
3answers
88 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
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>
...