Tagged Questions
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
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 ...
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?
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>
...
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
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?
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
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 =
@" ...
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.
...
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 ...
0
votes
0answers
912 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
536 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 ...
0
votes
1answer
149 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 ...
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
395 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 ...
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 ...
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 ...
0
votes
1answer
205 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
187 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
...
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" ...
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 ...
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 ...
1
vote
1answer
778 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 ...
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 ...
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 ...
0
votes
0answers
72 views
CAML : How to Join Two List in CAML Query? [duplicate]
Possible Duplicate:
How can I Create a join between two sharepoint custom list using CAML Query?
I have been asked this question in interviews a lot and I am still trying to figure out what ...
