Tagged Questions
2
votes
1answer
19 views
CAML Query Lookup/Choice Value Type as Text
So, here is some lines of code that i write to retrieve data from Sharepoint list using CAML query.
string qryCaml = string.Format(@"<Where>
<And>
...
0
votes
0answers
20 views
ecmascript check if item exists in lists
I have to check whether _spuserid exists in 10 lists of same structure and columns.
var arrayOfLists=["list1","list2","list3",.......,"list10"];
for(var i=0;i<arrayOfLists.length;i++)
{
var ...
0
votes
1answer
31 views
How to apply CAML in SharePoint view
I'm using SharePoint client object model and trying to query specific view but not getting the correct method to do so. Here is my code,
using SP = Microsoft.SharePoint.Client;
using ...
0
votes
2answers
51 views
foreach loop inside caml query
I have a list of Employee class which has empid and empname as property.
Now I want to construct a caml query IN clause where list column id in empid.
How can I write a foreach loop inside caml ...
0
votes
1answer
27 views
CAML : Cannot complete this action
It seems my following query is failing and throwing "Cannot complete this action".However when I test this query in CAML Query builder it's working fine.
<Where>
<And>
...
1
vote
1answer
404 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
| ...
0
votes
0answers
25 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: {<, ...
1
vote
1answer
282 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())
{
...
0
votes
0answers
900 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
1answer
894 views
How do I use a variable in CAML query to send approriate email
I have created two list. One is "Storage" the other is "Approvers"
I am able to retrieve all values in the column 'System' in the "Storage" list by iterating through the column list, like so and ...
0
votes
1answer
85 views
CAML Query assistance
I have a query I created using U2U CAML query. I am able to retrieve all the information within the builder, but when I use in VS I am returning everything seems like. Unless while debugging I am ...
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 ...
1
vote
1answer
818 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
456 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 ...
1
vote
3answers
967 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
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
6k 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
461 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
2answers
935 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 ...
