method for querying list data
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.
0
votes
3answers
35 views
CAML Query: use the value of a property of a lookup
My project consists of two lists:
a list of documents. This list has an SPUser field that determines who is responsible for that document.
a list of projects. This list has a multiple lookup to the ...
1
vote
2answers
1k views
How to apply CAML query on the Calculated Column of the list?
I have a calculated column that stores the calculated date value.
When I apply the CAML query, it does not return any row even if the record exists.
Can any one please guide me on this topic>
...
0
votes
2answers
43 views
How to get display name from created by field in sharepoint client object model?
In my sharepoint javascript code, I am retrieving items from a list in my SP 2010 environment. I used a camel query to download specific fields. One of the fields was created by (person who created ...
0
votes
2answers
337 views
Problem with Calendar CAML Query
i have a problem with a CAML Query for a Sharepoint Online(Office365) Calendar. I try to get all Calendar Appointments between two dates. Here is my code:
private void getFreeDays()
{
...
0
votes
2answers
252 views
caml-query Sharepoint[2010]: CAML select several records, same ID
I have a list where IDs are not unique.
How can I make a CAML Query for this list so I can get all values for a particular ID
This is my list:
ID Customer LOB PeriodOne PeriodTwo ...
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 ...
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
2answers
181 views
SharePoint list query efficiency
I'm trying to build a very high performance application on top of SharePoint 2010. One thing I'm having a hard time deciding is if I should make 2 list queries (1 small and 1 large) or if I should ...
2
votes
1answer
75 views
Help Return Lists With With No List Items
This is my first time posting and I'm looking for some help, so hopefully someone has an answer. I used the search, but didn't find anything.
I created a custom list definition, and content type ...
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 ...
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" ...
1
vote
1answer
57 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
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
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 ...
1
vote
1answer
206 views
CAML query - examine Contents column used in freetext predicate
In my query I use the freetext predicate:
and freetext(Contents, 'my search string')
I'm getting some unexpected results from this search, namely the documents contain no relevant content, yet are ...
1
vote
1answer
1k views
COM exception while querying document library
I have a need to get collection of SPLitsItem currently viewed to user. My solution is a ribbon button which calls custom application page in LAYOUTS via javascript in custom action.
Application page ...
0
votes
1answer
19 views
Problem with multiple text filters
I have a custom list that has a text filter connected to allow the user to filter one of the list columns. I now need to add a second XOR text filter to allow the user to filter on a different column ...
0
votes
1answer
281 views
Multiple CAML query to filter Data list view
My Custom list have four columns(Doc ID, Created by, Assigned To, Assigned date). I want to filter the data in Data list view.
In my page there are 4 text boxes and a Button is there for the user ...
0
votes
1answer
148 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 ...
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
...
0
votes
1answer
175 views
Display ManagedMeta using xslt
I am showing the results of query against a document library within a dataformwebpart. The managed meta data field is named 'Tags'. The output to the page of this column looks like 3;#test;#2;tos ...
0
votes
1answer
368 views
How to use XmlDefinitionLink & CAML to reuse View definitions in multiple XsltListViewWebPart controls?
This is what I want to achieve (in SharePoint 2010):
A custom page containing 2 XsltListViewWebPart
Both of them rendering the same list data, but with different XSLT definition for
display
I ...
0
votes
1answer
261 views
CAML strip or remove HTML tags in custom AlertTemplates.xml
is there any way to remove the html tags for text in CAML? I have made a custom alert template when sending e-mails that uses a field that looks like this:
<'GetVar Name="DisplayName#{Field}" ...
2
votes
0answers
180 views
CrossListQueryCache().GetSiteData(contextWeb) throws NullReferenceException on second query?
I have an auqward problem that's been nagging me on and off for half a years time. It turns out, when I'm finally taking a real shot at it that my query throws a NullReferenceException the second time ...
2
votes
0answers
50 views
How to avoid loosing complex query in a view?
In a custom list definition bound to a custom content type, I attached the out of the box AssignedTo field.
In the schema, I defined a view with this query :
<Query>
<OrderBy>
...
2
votes
0answers
166 views
How to (caml)query a list on metedata in the MetaInfo field
Is it possible to wite a CAML-query to filter documents with certain info in the MetaInfo field? The information is only stored as property in MetaInfo, not in a field of it's own.
Context: I have a ...
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
33 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
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
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
0answers
91 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
0answers
213 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
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
0answers
985 views
ProjectedFields working in SPQuery but not in the View
I've three lists: Competitions, Works and WorksVotes, linked to each other through Lookup fields.
WorksVotes list has Lookup field to Works list, and Works list has Lookup field to Competitions list.
...
1
vote
0answers
84 views
How can i enter User information in the Data element of a list instance
For example...
<Rows>
<Row>
<Field Name="ClassName">Programming 101</Field>
<Field Name="Attendee">Domain\User</Field>
</Row>
</Rows>
...
0
votes
0answers
54 views
CAML Query on External Content Type not honoring the <In> operator
So I've been testing this out for a day or so. For the life of me I cannot get an external list to listen to honor the <In> operator in CAMLQuery. On any other type of list it seems to work ...
0
votes
0answers
58 views
CSOM expand user / people field
I have a "Contact" person field and want to access the expanded properties of the field, name, account and work email.
With REST, you can use $expand and project fields like this:
...
0
votes
0answers
63 views
CAML Designer: Could not load file or assembly 'Microsoft.Sharepoint
I am new to sharepoint, and this community. I have a CAML Designer program (http://karinebosch.wordpress.com/2012/05/12/caml-designer/) that I want to use to run queries on my Sharepoint Online lists.
...
0
votes
0answers
24 views
Need an Algorithm to convert a boolen expression in InFix notation into its CAML format
Need an Algorithm to convert a boolen expression in InFix notation into its CAML format.
The expression may contain parenthesis, and logical operators: {AND, OR, NOT} with Relational operators: {<, ...
0
votes
0answers
314 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 ...
0
votes
0answers
891 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
0answers
298 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
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 ...
0
votes
0answers
127 views
How to create charts with custom filters about sensitive data using JS without using external APIs?
I need to create charts out of business data which comes out of SharePoint lists in SharePoint 2010. The solution needs the ability to easily filter the data by custom queries, just like the SPJS ...
