method for querying list data
1
vote
1answer
768 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 ...
1
vote
4answers
4k views
get all document from all folder and subfolder from document library sharepoint 2010
I want to retrieve all documents from folder to it's subfolder and so on using client object model.Please help me.
1
vote
3answers
930 views
The <today/> tag not working in my CAML Query?
I am trying to retrieve the 5 most upcoming (with respect to expiry date) announcement list item "Title's".The query partly works but what it fails to do is include and display todays announcements as ...
1
vote
1answer
2k views
CAML Query to filter a list item based on comparing item[“Title”] to ascx label.text control?
"<Where><Eq><FieldRef Name='Title' /><Value Type='Text'>'Label1.Text'</Value> </Eq></Where>";
I have not run this and checked yet, simply because I ...
1
vote
1answer
244 views
SPQuery doesn't return all rows
I don't know why i only get one row as per below:
When they are 2 rows to be returned.
Am i missing something using SpQuery?
Thanks in Advance
string siteUrl = ...
1
vote
1answer
522 views
How to Retrieve Numeric Column value from SharePoint List
In the SharePoint list I am having the numeric column and the value is like this
123,456,789,012,346,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000.
I am using SPQuery to retrieve items ...
1
vote
2answers
892 views
How to get List Item from sharepoint list based on ItemID
Dynamically I am adding radgrid to the page. I need to retrieve list item from the SharePoint list. Say I have 10000 items in the list using SPQuery, I will get filtered records as 2000 items. Here ...
1
vote
2answers
326 views
How to order all day events on a calendar
I have a calendar list with a choice called "Category" with items A,B,C,D. I want to sort the all day events that are shown based on the selected category. I tried to set the Orderby
...
1
vote
1answer
443 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
3answers
757 views
Showing the current user's tasks in a Content Editor Web Part using JQuery
I have been searching this site for an answer but I have been unable to find anything that will work.
I have been trouble pulling the tasks of the current user from a subsite. I am using SharePoint ...
1
vote
1answer
684 views
Using SPMetal to read data from sharepoint 2010
I've just started to look at using spmetal with SP 2010 to read data from document libraries:
http://msdn.microsoft.com/en-us/library/ee538255.aspx
I'm curious as to how I can ensure that I only ...
1
vote
2answers
65 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 ...
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 =
@" ...
1
vote
2answers
223 views
SPQuery always returns values
I am trying to check a list for related values but for some reason every item in the list is returned each time. I have seen this issue before and for me its always meant a bad CAML string but I have ...
1
vote
2answers
249 views
CAML OffsetDays
please help if it possible that CAML OffsetDays is not working in DvWP?
I use the following CAML within a DVWP:
<View><Query>
<Where><And>
<Lt>
<FieldRef ...
1
vote
2answers
408 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 ...
1
vote
1answer
91 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
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
...
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
1answer
299 views
CAML query and jQuery to retrieve last item's fields
I want to get list item fields where its the last item that the same user created.
Then I want to populate the newform.aspx with some of these items.
I'm mainly stuck with the query and how to write ...
1
vote
2answers
779 views
CAML Query to retrieve First Name using Email Id of users in Sharepoint
I am creating a custom workflow which gets activated whenever some data is entered in a particular list. One of the field in this list is a column for Email ID of the a user( not necessarily the ...
1
vote
1answer
224 views
FilterDefinition CamlQuery
I working with custom AlertTemplate. I only want to send an Alert if field "Beställare" or "Agent" contains my UserId I Have tried with this query, but I always get an Alert when something chanches.
...
1
vote
1answer
276 views
Are CAML queries a proper way to do a full text search
Let's assume that enterprise and fast search are not an option.
Are CAML queries (with CONTAINS operator) a proper way to do a full text search in fields of a publishing page? Or is that for any ...
1
vote
1answer
346 views
Can the CAML Query in A View be modified to use the Username or UserId of the currently logged in user?
On a MOSS 2007 Team Site, I used the Web UI to add a View, and used the Web UI to filter it in order to fetch the items where Title equals ACME\Joe.
<Query><OrderBy><FieldRef ...
1
vote
1answer
513 views
CAML Query for two reference fields that point to the same SharepointID
I've got a SP2007 list (List A) with two reference-fiels (Column 1; Column 2) that reference items from a different list (List B). For some Opalis automation I need a CAML Query that gives me the ...
1
vote
4answers
1k views
CAML query to find a value that does not begin with
I want to build a CAML query to search for all title fields that do NOT begin with a certain value:
something like this: Where Title NOT BeginsWith 'myvalue'.
How can i do that in my CAML query?
1
vote
1answer
507 views
Does an indexed column need crawling?
I am new to SharePoint and was struggling to get this particular information. Please could anyone explain:
Will configuring the shared service provider to crawl the content make CAML queries faster?
...
1
vote
1answer
919 views
How to get checked out SPListItem for current user by file name using CAML query?
I use SharePoint 2010 RTM and now I'm trying to get SPListItem, which was checked out by current user, using code like this:
query.Query = "<OrderBy>" +
...
1
vote
1answer
346 views
CAML Query get elements with most recent created date
I'm trying to get the elements with the most new created date using CAML query in sharepoint 2007.
I can do it using:
"<OrderBy><FieldRef Name='Created' Ascending='False' ...
1
vote
1answer
427 views
CAML or C#: Change the URL of “Edit Item” of Custom List item
How can I change the target URL of "Edit Item" option of a custom list in CAML or .net?
1
vote
2answers
576 views
CAML Returning Tomorrow's Value when filtering Today
I have the following CAML query for SP2003
SPQuery qry = new SPQuery();
qry.ExpandRecurrence = true;
qry.CalendarDate = DateTime.Now.Date;
qry.Query = ...
1
vote
1answer
2k views
How to retrieve User Information List data
I would like to filter a list based upon a user group that the user may belong to and a specific value found in the User Information List for that user.
I tried doing this with CAML in SharePoint ...
1
vote
2answers
820 views
Hard code group name into CAML query
I am trying to hard code a user group into a CAML query's where clause. The reason is so that I can apply additional criteria when the user is in one group, and something else if they are in another ...
1
vote
1answer
1k views
Sharepoint 2010: Full text plus faceted search over an External Content List using Search Services (or possibly FAST)
I have an External List over a products table in our database. I want to be able to build a search form over it via a full text search; in addition to being able to filter down on properties on my ...
1
vote
0answers
31 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 ...
1
vote
0answers
31 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 ...
1
vote
1answer
43 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" ...
1
vote
0answers
80 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>
...
1
vote
1answer
56 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="">
...
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 ...
1
vote
1answer
361 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
| ...
1
vote
0answers
90 views
filtered lookup: query filter
I have a task to make a small helpdesk app :)
I have a "SITE 1" where I made a custom list "APPS" with a list of applications and other custom list "MODULES" with a list of application modules from ...
1
vote
1answer
416 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
202 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
0answers
209 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 ...
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
214 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>
...
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())
{
...
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.
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 ...
