method for querying list data
1
vote
2answers
401 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 ...
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 ...
0
votes
1answer
389 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
1answer
90 views
Caml accent-sensitive
I wonder if the caml supports accent-sensitive, I'm doing a query and have many records with an accent and realized that these items are not appearing
What can I do in this case?
I can use any search ...
1
vote
2answers
245 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
1answer
156 views
Output powershell caml query to table
This has to be real easy but I just cant find an answer on google that will work in my case. I am running a ps1 file that caml queries a document library. I just want to organize these results into a ...
0
votes
1answer
218 views
Paging caml query results
I have about 1000 items in a custom list. i want to retrieve 10 only from a certain position, (i know how to do this).
I also want to get the total in the list.
How would i do this? (this is for ...
1
vote
2answers
201 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 ...
1
vote
2answers
448 views
what does “ows” means and why people use it before name of a field
I seen at different places if a field has a name "LinkFilename" then while trying to get its value using CAML query or any other way, developers put it as "ows_LinkFilename", can someone explain it to ...
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
81 views
Getting Information About Deleted Item from GetListItemChangesSinceToken
When calling GetListItemChangesSinceToken, and processing deletions, the data returned looks like this;
<Changes ...
0
votes
1answer
90 views
How authentication is done when using a CAML query for SharePoint List in a console application
I am try to develop a console application in Visual Studio which uses CAML query to get data from SharePoint List. The question is, how does the console application authenticates from the SharePoint ...
6
votes
1answer
284 views
How to Combine IN-Opeator with LookupIds in a caml-query?
I want to build a CAML - Query using the IN - Tag. The queried Column is a lookup-field to a Title of another list. When I query using the text-property everything works fine:
<Where>
...
0
votes
1answer
41 views
CAML to get content of referenced list
i got a CAML-Query, which (essentially) pulls the IDs from a lookup field. Then i got another one, which querys the target of the lookup to get the date from that list.
So is there a possibility to ...
0
votes
1answer
199 views
How to get week birtdays
I have a list called profile, and this list contains the Birthday field, is a field of type DateTime.
I created two fields of type calculated, one gets the day, and the other gets the birthday month ...
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 ...
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 ...
7
votes
4answers
740 views
CAML Now Instead of Today - CAML Bug?
I have a CAML query, in which the <Where> node looks like:
<Where>
<Leq>
<FieldRef Name='PublishedDate'/>
<Value Type='DateTime'>
<Today/>
...
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 ...
2
votes
1answer
183 views
Should we use web service lists.asmx over CAML when working with large lists
There is a list that has around 100k items in a SharePoint Site Collection. This site has been customized to serve certain business requirements through visual webparts.
While, regular CRUD ...
1
vote
0answers
208 views
“Not in” membership caml query
In a custom list definition, I'm building a view with this query :
<Where>
<Or>
<Membership Type="CurrentUserGroups">
<FieldRef ...
0
votes
0answers
312 views
SharePoint 2013 - Updating List XML Definition
I have custom list filter web part for SharePoint 2010 lists which I am trying to migrate to SP 2013. It works by modifying the list's XML definition and replacing the query with one the user created ...
1
vote
1answer
256 views
Issue while Fetching recurring items from Sharepoint Calendar
I want to fetch all the items on a particular day. Programmatically the entry is added as recurring event, Now i need to fetch all the instances of recurring event, on each day as per the date ...
1
vote
2answers
211 views
Lists.GetListItems Query for items with a specific author
I am trying to query a list in SharePoint 2007 to get the items of the list that were created by a specified user. Here is my CAML:
<Query>
<Where>
<Eq>
...
0
votes
1answer
260 views
Task list field database location changed from 2007 to 2010
What I've witnessed
I've just noticed something rather annoying with SharePoint following an upgrade from 2007 to 2010.
The task list schema in SharePoint 2007 had the 'Assigned To' field first. ...
1
vote
1answer
275 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())
{
...
0
votes
3answers
1k views
Current User Task using CAML Qurey
Here's my query to get current user task using CAML but it's not working
SPUser me = web.CurrentUser;
SPList list = web.Lists["Tasks"];
SPQuery qurey = new SPQuery();
qurey.Query = @"
...
1
vote
1answer
95 views
I need help with creating CAML
I have a document library MyLib and i need to find specified file in it .
query.Query = @"
<Where>
<Eq>
<FieldRef ...
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
2answers
1k views
Retrieve items from one column in a list using CAML and bind that data to dropdownlist
I want to retrieve a column items from the list. My list contains two columns. I want to retrieve first column items and those items should bind to the drop down list. I am doing this in a web part. I ...
0
votes
2answers
186 views
SQQuery, Dates and Regional Settings
First, some setup: My Site is set to Eastern Time, and the server is located in Eastern Time.
I'm trying to run a query against a list using the created date. I have tried using all variations I can ...
0
votes
0answers
297 views
Caml Joins for multiple lists
I have four lists as explained below
EmpMaster ( Empcode, EmpName, BranchCode )
BranchMaster ( BranchCode, BranchName, BranchHead, ZoneCode)
ZoneMaster ( ZoneCode, ZoneName, ZonalHead)
...
0
votes
1answer
82 views
A column is not appearing in GroupBy option when editing view
I have a document library created from a custom content type (which inherits from Document type). The Document Libraries are created via feature activation using CAML in the Elements and a List ...
0
votes
1answer
411 views
SPServices: How would I add Ascending=False to CAML in GetListItems
How would I use SPServices GetListItems and still be able to add Ascending=False to the CAMLViewFields? I haven't used this for long and I am just wondering if this is possible?
Thanks as always!
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
...
1
vote
2answers
442 views
Simple SPQuery throws error
I am trying to pull populate a lookup field using a lookup value without the lookup ID. I am getting the error: "One or more field types are not installed properly. Go to the list settings page to ...
1
vote
1answer
3k views
How to use GroupBy in CAML query
I have simple list, consisting of 2 columns - Date, Order. Now what I want to do, is to GroupBy Date and count orders. So, for example if I have following items
Date Order
08/10/2012 5
...
2
votes
1answer
437 views
Does an OrderBy CAML query return ONLY the most recent items?
var query = new SPQuery
{
Query = "<OrderBy><FieldRef Name="Created" Ascending="False" /></OrderBy>",
RowLimit = 100
};
Does this return the 100 most recently created items? ...
1
vote
2answers
121 views
Dynamically assemble CAML to call related List Items?
I have good methods in place to get my core List of Posts. Let's say I get the 100 most recent Posts.
I'd like to get all comments related to those posts. Comments have a field called PostID that ...
1
vote
4answers
399 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
1answer
1k views
Get URL of image from Picture Library using CAML
How is it possible to get the URL of an image that is stored in a Picture Library using CAML?
Currently, I've made a CAML Query and run it in the U2U CAML Query Builder, and am seeing values like ...
0
votes
1answer
840 views
Adding IsNotNull and ViewFields in CAML Query
Trying to add IsNotNull parameter and ViewFields paramter but throwing an error. Am I inserting incorrectly or missing something to make sure this executes correctly? Seems like View is bring back all ...
1
vote
1answer
217 views
Get all webs with certain property value
If I have a certain number of webs within my site collection, and those web have set some property, eg. web.Properties["foo"] = "bar". I'd like to get list of all the webs which have property foo set ...
2
votes
2answers
131 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
1answer
870 views
How do I use a variable in CAML query to send approriate email
I have created two list. One is "Storage" the other is "Approvers"
I am able to retrieve all values in the column 'System' in the "Storage" list by iterating through the column list, like so and ...
0
votes
1answer
85 views
CAML Query assistance
I have a query I created using U2U CAML query. I am able to retrieve all the information within the builder, but when I use in VS I am returning everything seems like. Unless while debugging I am ...
0
votes
3answers
388 views
What is the difference between CamlQuery and SPQuery
Maybe a simple question, when to use CamlQuery and when to use SPQuery ?
I think that SPQuery is used inside a WebPart running on the SharePoint server, and that CamlQuery is part of the Client ...
0
votes
0answers
118 views
Creating filter for SPAlert Programatically
We are trying to create SPAlert programatically in Sharepoint 2007 portal, but
we are encountering an issue while creating CAML query for eight parameters to filter.
The e-mail is getting triggered ...
1
vote
2answers
331 views
comparing and modifying items in a list
Ok, so adding to my previous question here - I want to get certain columns from a sharepoint list, then compare values of those columns to items in my own c# list and, if they're different, modify ...
