method for querying list data

learn more… | top users | synonyms

0
votes
1answer
2k views

How to get folder structure including items from list, without using webservices

I have a list containing folders and items. The folders are a custom content type based on folders, with some extra columns like URL and some Yes/No Checks. One contenttype can contain n items and ...
0
votes
2answers
696 views

Logical OR CAML Query not working

I have a query that I've written like this: <Where> <Or> <Neq><FieldRef Name='Status'></FieldRef><Value Type='Text'>Created</Neq> ...
2
votes
2answers
4k views

CAML error: “One or more field types are not installed properly.”

I'm using the U2U CAML Query Builder tool and no matter what I do, I can't create a query. It keeps generating the error: One or more field types are not installed properly. Go to the list settings ...
0
votes
5answers
6k views

Jquery to get list items from sharepoint list

I have a work from my time to use jquery with sharepoint. I have written the code to get list items. When I run in IE it dosen't show any errors to me, but I am not getting the results. Can any one ...
5
votes
1answer
2k views

Need help with CAML in CQWP

I tried to implement a CQWP web part that could show me all the checked-out files following this guide: ...
2
votes
1answer
2k 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
181 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 ...
2
votes
4answers
6k views

How to check if a folder exists in a list?

I have the following code: SPFolder oFolder = myList.RootFolder.SubFolders[folderName]; if (oFolder == null) { Console.WriteLine("FOLDER NOT FOUND"); ...
0
votes
1answer
1k views

User Information List Add item programmatically

I'm using a CAML batch file to add items to a list using SharePoint List Web Service on my InfoPath form. The batch file is like this: <?xml version="1.0" encoding="UTF-8" ?> <Batch> ...
0
votes
1answer
2k views

How to get Highest ID using CAML and JQuery

I am using a web service and am trying to return the highest ID number from the Posts list with viewname {B9212691-1AF1-41AF-9DA7-6073ADDB091B}. So far I have the following. <script ...
1
vote
1answer
431 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
798 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 ...
4
votes
4answers
805 views

CAML query error when creating SPQuery query

I have this CAML query var query = new SPQuery{ Query = string.Format(@"<Where> <Or> <Or> <Or> ...
0
votes
2answers
3k views

Pass a standard list view a CAML query, is this possible?

I have a standard list in Sharepoint 2010. The list has a standard view, but technically the view could even be custom built. Is it possible for me to pass through a CAML query from a web part I've ...
1
vote
1answer
549 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 ...
2
votes
3answers
3k views

Querying for Approved (Published) List Item Data

My scenario: I have a page layout that has a user control on it. This user control queries data contained in other pages within the site collection to show a summary of related information. Anonymous ...
0
votes
3answers
3k 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 ...
0
votes
1answer
373 views

External CT Related Lists - Examples - CAML - LINQ to SharePoint

I'm trying to return related data via External Content Types. I was wondering which is better to use, CAML queries or LINQ to SharePoint? I'm fine with writing CAML queries besides the relating part ...
3
votes
3answers
745 views

SharePoint 2010 equivalent to SQL Profiler?

Is there a way to view the CAML that is running on a SharePoint 2010 installation? A bit like how you can monitor SQL running on a database with MS-SQL Server - is this possible with CAML and ...
1
vote
3answers
879 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 ...
7
votes
2answers
3k views

Can I order by Content Type in a CAML query?

Is it possible to order by content type in a CAML query? I seem to always get the same result no matter what I do with the Order by. Ordering by ID instead works perfectly. query.Query = @" ...
0
votes
1answer
2k views

CAML get list by view name

I'm making an Ajax call to the Lists web service to retrieve some items. I'd like to return results only from a specific view. Can I do that through CAML? I have this so far - which the attribute ...
6
votes
2answers
8k views

CAML Query with Date Range

I'm writing an SPSiteDataQuery and I am having issues with the Query property. I need to return all results where the Record_x0020_Yr_x0020_End_x0020_Date is between 12/31 of the current year and 90 ...
3
votes
1answer
4k views

How do I query a list using CAML and SPQuery?

I have a SPList but I don't need to go through everything in that list. I need to establish a CAML query so I can limit the list items. Then, go thru each item from the query result and do something. ...
5
votes
2answers
909 views

Problem with CAML SPQuery ItemChildCount result

I know that this query works fine SPQuery query = new SPQuery(); query.Query = "<OrderBy><FieldRef Name='ItemChildCount' Ascending='FALSE' /></OrderBy>"; But my ...
1
vote
1answer
1k 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
2answers
5k views

Create CAML SPQuery to order by ItemChildCount in descending order

How do I create a CAML query to display all items on the list order by ItemChildCount? Somewhat like this: Select * from table order by itemChildCount descending
2
votes
4answers
2k 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?
2
votes
2answers
3k views

What does the GetListItems query option IncludeMandatoryColumns do?

I found myself working with the Lists.GetListItems method fairly often. Unfortunately, I have never understood what the IncludeMandatoryColumns query option actually does. The documentation seems to ...
8
votes
4answers
3k views

SharePoint 2010 CAML Query fails when indexed columns used

I have an SPQuery that has been working fine until my list hit 500 items: q.Query = "<Where><Eq><FieldRef Name='DefectID' /><Value Type='Counter'>" + DefectID + ...
2
votes
3answers
2k views

Problem using viewFields to return more fields

Do I have to put a prefix of ows before retrieving fields? because I am trying to obtain additional fields and not being able to? soapEnv += "<listName>My SP List</listName>"; ...
2
votes
2answers
447 views

DefaultValue for CAML Variables

I have a question sort of related to this post. The default value of the CAML variable UserID is the CurrentUserName. Can that be set to different properties or is that fixed? For example, could ...
3
votes
2answers
5k views

GetListItems Lists.asmx and Meta Data Columns

I'm trying to use the GetListItems web service in MOSS 2007 to return all the columns and rows in custom SharePoint list. I don't need to filter any of the data, so I've left the QueryOptions and ...
0
votes
1answer
498 views

PreSaveAction and CAMLQuery

I'm cross posting this from Stump the Panel for some more visibility from a wider developer base. I'm trying to create a script I'll eventually adapt into a PreSaveAction, but I'm running into a ...
1
vote
1answer
618 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
1k 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
2answers
3k views

Caml Query for Order By List for web service call not ordering

I'm calling web service List.asmx using Jquery and getting results using this but its not ordering by DisplayOrder. This is the caml query. <soapenv:Envelope ...
2
votes
2answers
1k views

How do I test if I will be able to execute a query (does the site exist)

When I run a (CAML based query) executeQuery against Sharepoint, sometimes the site does not exist (it is created by a workflow process which may not have run). When this happens, I get a ...
7
votes
1answer
1k views

Why is my CAML query working in CAML Builder but not in the application?

I have a CAML query that queries a calendar list and I want it to return all the items in the list with an EventDate of today or later, ordered in ascending order. The CAML query I'm using is this: ...
1
vote
1answer
683 views

Can I get the list of files for two or more directories?

My current query is below and works adequately enough. The sharepoint developer is creating a workflow that will look at files in the "Documents" folder, and if it certain flags are set, the ...
5
votes
5answers
1k views

When I execute a CAML query, how do I know what ListItem details I can include?

I was querying a SharePoint library, trying to retrieve some file attributes. Apparently some things like FileType and Date are not supported, even though those fields are listed as a built in field. ...
3
votes
6answers
5k views

How to query using CAML when a value has < in the value

I'm using SPServices to query a list, using CAML, and the column I'm searching (Title) have values that contains < and >. Is there anyway I can use CAML to find these values? It seems that I'm ...
4
votes
1answer
629 views

Problems with customizing Ribbon for webparts with “Summary Toolbar”

I have a problem with customizing Ribbon for webparts with "Summary Toolbar". I add the button through CAML code. (Generated by SPSF, but shouldn't matter) My buttons shows up when viewing the list ...
7
votes
1answer
5k views

CAML query builder that supports inner joins?

I'm Looking for a query builder that can assist me in creating CAML queries that will contain inner joins. Does anything like this exist? Update: To ask my question more clearly, I am looking for a ...
0
votes
1answer
756 views

CAML >> Keep getting “one or more fields are not installed properly”

when I debug i can see URL is valid (like below). Shared Documents is tie a to custom content type. string fileURL = "Shared Documents/Marketing Folder/Sales_Report.txt"; oQuery.Query = ...
4
votes
1answer
5k views

CAML query with more than multiple AND/OR generates SPException “One or more field types are not installed properly. Go to the list settings page to delete these fields.”

I need to build a CAML query at runtime based on user input. The CAML query could be as simple as <Where> <Eq> <FieldRef Name="Status" /> <Value ...
0
votes
1answer
264 views

CAML > get item by it's URL

Should this CAML be working. (I tried it with u2u and it does not display the URL column.) I get this error. {System.ApplicationException} = {"One or more field types are not installed properly. Go to ...
2
votes
3answers
1k views

CAML Query Maximum Size

I am running a sharepoint caml query where I want to check that a field on an item is equal to one of many values. I do this dynamically and may wish to check against many hundreds of values. I found ...
0
votes
1answer
326 views

caml query help

I'm building a webpart that queries an sp list. my list contains two fields (title, tip). title = is a single text line and tip = a yes/no check box currently in my code, i am calling all items in ...
1
vote
1answer
500 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' ...