2
votes
1answer
201 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" ...
2
votes
2answers
2k 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 ...
0
votes
1answer
150 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 ...
0
votes
1answer
195 views

The multi-part identifier “t16.nvarchar1” could not be bound

MOSS2007 with SP3. I have a list with many items. From code I get items using simple criteria. (give me all products that have DeliveryDate between in a specific time interval and the field Customer ...
1
vote
1answer
418 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 ...
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 ...
1
vote
1answer
599 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? ...
0
votes
1answer
747 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 = ...
0
votes
1answer
240 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 ...
1
vote
1answer
464 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' ...
0
votes
1answer
99 views

Retrieving lists from sharepoint site

I am trying to retrieve lists from a sharepoint site. I know how to do it using web services. However, the requirement is that I need to use Xelement GetList and the output should have PropertiesXML ...
2
votes
1answer
924 views

Nested CAML Querie results in exception “ Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries”

All, I am trying to mimic SQL"IN" operation using CAML. Lets take a scenario where we need fetch all the ListItems with ID within a list of IDs. The target list is realy large ( 50k records) ...
0
votes
2answers
602 views

CAML statement for “top x rows” out there?

Let's say I'm querying a big list but only need a subset of the rows for demo purposes. What's the easiest way to say "Top 100 Rows" or similar in CAML? Can't seem to find a statement out there. ...
2
votes
2answers
1k views

CAML query get listitems between a specified Row Index Boundary

Is it possible to get listitems between a specified Row Index Boundary from a list using CAML Ex: if there are 10000 records I would like to fetch records between 201 - 250
0
votes
1answer
797 views

How come GetListItems filtering on a field's equality to a value fetches this field's value as undefined/null

I think I found a bug. Please share if you know more about it. I use GetListItems operation to fetch items to display on an ajaxified form. Just an hour ago everything was fine, but now when I query ...
0
votes
3answers
2k views

How to replicate a query join in CAML

In SharePoint 2007, if I had 2 lists with a master/detail type relationship (via a lookup column) how would I best implement a search query across these 2 lists (for a custom search and results page). ...