method for querying list data
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>
...
1
vote
1answer
204 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 ...
0
votes
1answer
1k views
CAML query for null lookup field values
I have a problem with filtering list items using CALM
I Have this list: Code - Text, Name - Text, Link - Text, Order No - Number, Parent - Lookup to this List.
I want to filter all items where Parent ...
0
votes
1answer
1k views
Getting items from rows 4-8 in a Sharepoint list using CAML query?
Here is the code Im using to retrieve the first 4 most upcoming announcements from the OOTB announcements list in sharepoint:
How do I modify this to retrieve the next 4 (5,6,7 and 8) most upcoming ...
0
votes
3answers
536 views
how to check CamlQuery results
.I am running below query against a sharepoint list.
How to check the results of below Camlquery? cPop is set with value 'AboutUs'.
Result is always zero records although list has valid matching ...
5
votes
3answers
542 views
sharepoint caml is fast - how?
We all know that Caml is faster than using linq, since linq internally gets translated to caml.
But can anyone explain how caml is best to do sharepoint queries or how it is fast or what makes it ...
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>
...
3
votes
2answers
3k views
Filtering items in a view using a CAML query
I'm having trouble querying SharePoint in such a way, as to combine a view results with my own CAML query inside a WCF service. It seems GetItems ignores my query, and just returns all the items in ...
2
votes
1answer
4k views
SPService GetListItems with CAML : can't get example to work
enter code hereI am using an example I found on codeplex of SPServices with CamlQuery to try to get list item values with where clause on the ID. For whatever reason this doesn't seem to work for me; ...
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 ...
0
votes
0answers
126 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 ...
1
vote
1answer
765 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 ...
2
votes
2answers
451 views
CAML query to retrieve the second set of three list items from the announcements list?
The CAML query to pull say 3 items based off of the following requirements seems pretty starightforward:
Title is not null
Expires(Expiry Date) is greater than or equal to Today
Order Created in ...
3
votes
1answer
429 views
Using part of date in CAML query
I want to create new view for my list. The list contains a column called Year, which is a number and contains, as name suggests, year. Eg.:
2012
2011
2010
2009
I would like create a view, where I ...
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 ...
1
vote
1answer
298 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
3answers
2k views
CAML Query Filtering with OffsetDays
I'd like to set up a CAML query in a Data View Web Part (DVWP) that works like this:
If a date is not specified on the Query String, then show me items
created in the last 30 days
If a date is ...
2
votes
2answers
3k views
Using Date offset in CAML query
In SharePoint 2010, Inned to get items from a list based on a condition. Considering one of the fields to be 'EventDate' of type DateTime, the condition is:
(EventDate - 60 Days) <= Today <= ...
0
votes
2answers
2k views
SPQuery for Selecting/Excluding Hidden columns from a SPlist
I am trying to take a DataTable containing ID and other columns which are not hidden.
I am doing this for a generic list which contains any number/type of columns. so I don't know the field names ...
1
vote
1answer
294 views
How to check if a record doesn't exist in another list
I have listA
and another ListB
When i a user views an item in ListB there is a custom button that the user clicks.
Now when the user clicks the button i insert some rows into ListA which are:
...
0
votes
0answers
72 views
CAML : How to Join Two List in CAML Query? [duplicate]
Possible Duplicate:
How can I Create a join between two sharepoint custom list using CAML Query?
I have been asked this question in interviews a lot and I am still trying to figure out what ...
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 ...
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 ...
2
votes
1answer
4k views
caml query to get listitem by Name field
I am trying to check if a filename exists in the 'Name' column of Shared Docs Library. I think only CAML could help here. So I made this query
"<Where><Eq><FieldRef Name='Name' ...
0
votes
4answers
1k views
Where can I find a good CAML tutorial?
I am just starting to get my feet wet with SP Foundation 2010, and need to customize some web parts. I am looking for some CAML tutorials that go beyond what's on the MSDN site, and also include the ...
0
votes
1answer
1k views
Is it required to specify the value type in a CAML query?
I was wondering if CAML query Value Types are strongly typed or not. It would save me some time if I didn't have to specify "text" or "date" every time I made a query.
Here is the code I am using, ...
2
votes
4answers
633 views
where clause is ignored when query list
I have a CAML query which returns lists by a lookup field.
here is the query
<Query>
<Where>
<Eq>
<FieldRef ...
0
votes
4answers
180 views
Should I learn CAML? [closed]
I've been spending the last few days studying sharepoint and plan to work with it for a long time - but I've only just heard the word CAML mentioned and seen it's querying in action, is it something ...
0
votes
3answers
3k views
SPServices <today /> not returning correct results
This is the chunch of code that I am working with. I am trying to get only the events (normal/all day/recurring) to show, and it is returning all items for the whole week. Any ideas?
...
1
vote
0answers
469 views
Nintex Workflow Query Lookup Filter not working for User field [closed]
So I have a nintex workflow where a username is extracted from an infopath form via Query XML. Confirmed that it comes out into the user variable (of type person or group) in the format DOMAIN\USER
...
7
votes
3answers
3k views
How to write CAML queries filtering on ModStat (Approved, Rejected) when using Language Packs?
When using content approval the CAML for retrieving (say) just Approved Items is
<Query>
<Where>
<Eq>
<FieldRef Name="_ModerationStatus" />
<Value ...
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.
0
votes
1answer
466 views
Caml query returning multiple lists
Trying to load a list from library containing two files. The following code when tested in CamlBuilder it is returning single row according to the filename selected. But in the program it is returning ...
1
vote
3answers
927 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 ...
0
votes
1answer
354 views
Logical AND ,OR CAML Query not working in External List
I am using ClientContext Class and CAML query to retrieve items from External List in sharepoint 2010.I have built the query with Logical AND Condition in CAML Query like this
string sDataFilter ...
0
votes
1answer
163 views
Filter list based off a set of IDs
I've written a web part that generates several KPIs based off a list given:
- List and column names placed in custom configuration values
- Parameters at run time
Each KPI is composed from a set of ...
2
votes
1answer
595 views
Content Query webpart- CommonViewFields vs ViewFieldsOverride
I'm reading up on the Content Query web part and based on this page, I can't understand the difference between the CommonViewFields property vs the ViewFieldsOverride property. How are they different?
...
1
vote
2answers
1k views
Using the Now() function in CAML Query?
i am trying to get the 3 most upcoming events from the current date and time (The current data and time refers the time everytime my web part loads. Basically it is not a fixed date and picks up the ...
0
votes
2answers
1k views
Populating a simple custom Event Web part that retrieves information from the OOTB calendar web part
I have a requirement to build a Event web part that shows the 5 most upcoming events and a see all link (that links to the OOTB calendar view). Here is a graphical representation:
How exaclty do I ...
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 ...
0
votes
3answers
5k views
CAML Query to retrieve announcement items in descending order based on ID # - Not Working
spQuery.Query = "
<OrderBy> <FieldRef Name='ID' Descending='True'/> </OrderBy>
<Where> <Eq> <FieldRef Name='Title' />
<Value ...
0
votes
1answer
423 views
Rendering IMAGES (attached to announcement list) in my custom web part?
Please bear with me as I am brand new to the whole sharepoint world.
I want to be able to display images that have been attached to OOTB announcement list in a custom visual web part I am trying to ...
1
vote
1answer
2k views
CAML and External List - pass parameter to ReadList (finder) method
I have a Finder method defined on an External Content type (created with Visual Studio). Whan That method receives a parameter. So the method is something like ReadList(string partnerName). I have ...
0
votes
2answers
637 views
Is <QueryOptions> valid in SP.CamlQuery for meeting work space
I'm trying to query all items in a meeting workspace list. I'm trying a query I think should work, but still only returns items specific to the instanceID. Is there a different flavor for client side ...
0
votes
1answer
1k views
How can I pass a Query String variable into the CAML of a jQuery script?
I'm using Marc's SPServices jQuery library - the SPFilterDropDown script - to filter the items in a Lookup multi-select field on a New Item DVWP. It works fine if I stick some static text in there - ...
0
votes
1answer
249 views
How can I test a CAML query using mocking?
I have a CAML query in a class and I'm using unit test to cover my code with some proper test. For the SharePoint classes and stuff, I use TypeMock to mock the SharePoint objects.
I would like to ...
0
votes
1answer
364 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
437 views
SharePoint Object Model: how to query ONLY last major version of data from Publishing Page?
I came into a situation where I wanted to use SharePoint Object Model SPSiteDataQuery to query data from Publishing Page.
However, I dont want the data query based on the permission on current login ...
0
votes
1answer
260 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
165 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 ...
