method for querying list data
0
votes
1answer
22 views
Client Object Model
I am using the .NET Client Object Model from a website to access data in a SharePoint list. One of the fields I am trying to access is a lookup field. How do I get the text for the lookup field using ...
0
votes
0answers
22 views
Filter SharePoint documents based on a Tag filter using the Client Object Model
I am successfully fetching SharePoint documents using a CAML query via the Client Object Model. I would now like to add list of tags as a filter to this query, so that only documents tagged with ...
1
vote
0answers
43 views
How to filter a list view by SP group membership (CAML, JS, anything)
I have a list. I need to filter the list view in SharePoint to show items:
created by someone in current user's group
show all to admin group
I am using Infopath for the list's form view, and ...
3
votes
2answers
43 views
Caml query with unicode charachter
the caml query bellow don't return the correct result :
<Where><Eq><FieldRef Name='ParentLink' /><Value Type='Text'>ⵜⴰⵎⴰⵡⴰⵙⵜ</Value></Eq> </Where>
i ...
0
votes
0answers
19 views
SharePoint 2013 custom TimerJob gets no results from list but same code as a console program returns results
Can anyone provide any ideas on why the below query returns nothing when inside a custom timer job. But when run from a console program it returns results. Note, both console program and OWSTimer.exe ...
0
votes
2answers
33 views
Unable to return items under folder using CAML
I have a folder in the default "Images" library under my site, called Menu Icons:
/PublishingImages/Menu Icons
I want to retrieve only the images under this folder, and not all images under the root ...
0
votes
1answer
29 views
caml query on lists connected by lookup columns
I want to use CAML to query two lists that are connected by a lookup column. If I set the lookup column in List 1 to connect to the Title column of List 2, can I do a CAML query that joins them? Or do ...
2
votes
1answer
39 views
CAML Query throwing error
Pretty new to CAML queries, but trying to query a list based on Status = Completed and a date range.
It is throwing the following error "Unexpected Error: One or more field types are not installed ...
0
votes
0answers
18 views
Anyway to know if a List View will breach the Threshold in the near future? (SP2010)
I understand why the LVT is there, how it works and so on, I also get how to order the fields in views to get the query under the threshold.
However, is there a simple way to evaluate a list and its ...
2
votes
1answer
39 views
CAML Query Custom Ordering
I have looked around a bit, but have not found any reference to this particular issue. Is it possible to specify a custom ordering in a CAML query? What I mean by this is, say I have a list with a ...
2
votes
0answers
32 views
CAML query join and sort by column of projected fields
I am trying to execute the following query:
query.Query =<Where>
<IsNotNull>
<FieldRef Name='Product' />
</IsNotNull>
</Where>
<OrderBy>
<FieldRef ...
1
vote
0answers
30 views
CQWP bind sorting with query string
Is there a way to use PageQueryString in CQWP to control the sort order and sort by behavior?
I am trying to implement this kind of sortable and filterable table with pagination:
Would it be ...
0
votes
1answer
31 views
CAML query many-to-many relationship
I have a case where a customer can have many contacts and a contact can be assigned to many customers.
Currently I have a page for each customer, on load I get all the contacts (a publishing page for ...
1
vote
3answers
126 views
Get field value from item in SPListItemCollection
I am confused with SPQuery. How can I use it to get listitem values. Let's say I have a list "Cinema" with 20 columns but i only want 4.
Film ID
Film Name
Film Type
Film Review
How can i get all ...
3
votes
1answer
55 views
Needed help to build caml Query with multiple <And>
I am getting a query from list view by view.Query i got the following
<QUERY>
<GroupBy Collapse="TRUE" GroupLimit="100"><FieldRef Name="AlertGrp" /></GroupBy>
...
7
votes
2answers
171 views
Can a CAML query find all documents that were ever modified by a specific user?
I'm trying to list all documents that were (ever) modified by a specific user, using a CAML query like this one:
var query = new CamlQuery{ ViewXml =
"<View Scope='Recursive'>" +
...
1
vote
2answers
38 views
CAML query to retrive data from 3 lists present in three different site
I have a parent site X, and three child site A, B and C.
There is a list by the name "MyList" in all the list sites.
I want a CAML Query to retrieve the latest ten records,from "MyList"(now ten ...
1
vote
2answers
59 views
Building CAML query with AND and Order by Clause
Hi I am trying to build a query using caml query builder - Below is the query (The query = get the values only whose address = 1234st AND LastName = Doe) - I believe the placement of AND operator is ...
6
votes
1answer
1k views
Where can i download the U2U CAML query Builder for Sharepoint 2010?
I have try to download form below links. But the site is not opening.
http://www.u2u.be/res/Tools/files/CamlBuilderSetupv4.0.0.0.zip .
http://www.u2u.be/res/tools/camlquerybuilder.aspx
...
0
votes
1answer
568 views
How to reterive list item values using CAML query?
I have one Date and time column and text colum. I need to retrieve list item value based on this both column using CAML query..
For ex:
Columname---> Date value for date would be-6/1/2013 and ...
2
votes
2answers
88 views
moving list items from wss 3.0 to foundation 2010 using lists.asmx
I'm trying to use Lists.UpdateListItems to move items from a list in WSS 3.0 to a list in SharePoint Foundation 2010. The original list contains several items. The target list does not contain any ...
1
vote
1answer
116 views
SP2010 JSOM: updating with CAML where clause
So I learned and have used the following to update a list item by ID using Javascript Client Object Model:
function updateItem(passedID) {
var ctx = new SP.ClientContext.get_current();
var myList = ...
1
vote
0answers
18 views
SP2010 - Visual Web Part - Storing metadata in folders in document libraries
I want to store a number to folders to enforce ordering.
I noticed these three pages
http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spfolder.getproperty.aspx
...
0
votes
1answer
30 views
SP 2010 Visual Webpart - How to get all documents in a folder and sort them by caml query?
I am making a visual web part for sharepoint 2010. I have a SPFolder object and I want to get all items in it, but I want to sort it by a specific field. I want to do this by CAML query instead of ...
0
votes
1answer
45 views
CAML query to select users IDs
I'm trying to select users ids from custom tasks lists. All users are in one SP Group and I need to collect users Ids that doesn't have tasks.
query.Query = string.Format("<And><Membership ...
1
vote
1answer
53 views
sharepoint 2010 - How to get document ID using spservices sql search query?
Using spservices to make search requests, I am building the query like this:
var queryText;
queryText = "<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'>";
queryText += ...
2
votes
1answer
321 views
Get List Items using ECMAscript CAML query
Hi can anyone show me how can I retieve list items based on 2 fields using ECMAscript CAML? I have a list where I have uid as number and city as text.
I want to retrieve all items where uid = 100 and ...
3
votes
1answer
123 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>
...
1
vote
3answers
184 views
Dynamically hide column list item if the field is empty
I have a series of fields that I would like NOT to appear in my list dispForm.aspx. So when a user creates a new list item if these fields are unpopulated the do not appear DispForm.aspx but I still ...
2
votes
2answers
298 views
Why is this CAML Query returning all items regardless of the <Where> element definition?
I'm trying to retrieve a list of items where a specific field matches a specific value. There is likely going to be multiple items returned when the query is successful.
Here's what my CAML query ...
0
votes
0answers
64 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
0answers
23 views
Put a break in javascript function
Hi I have 10 sharepoint lists.structure,column name,data type all are same.
I need to check whether a particular item is found in any list then do some action using ecmascript.
var ...
0
votes
0answers
40 views
SPServices Search - select first x items using sql type query?
I am using the SPServices library to make search requests in Sharepoint 2010 using this code:
queryText = "<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'>";
queryText += ...
1
vote
2answers
70 views
How to write a caml query that filters by .pdf or folders?
How can I write a CAML query (for javascript ecma) that filters by only pdf documents or folders in sharepoint 2010?
(this is for document libraries)
Thanks.
0
votes
1answer
31 views
How to set a search scope in SPServices search function?
I am doing a search using this code:
var queryText;
queryText = "<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'>";
queryText += "<Query>";
queryText += ...
0
votes
1answer
87 views
Filter List for DateTime using CAML against Calculated Field
In WSS 3.0, I have a list with a Calculated Field, 'MaxDate'. It gets the greater of two other dates, Notional Date and Override Date.
I am trying (and failing) to build a CAML query to get all items ...
1
vote
1answer
86 views
How to filter by only pdf files in querypacket?
In a query packet used in SPServices to do searches on Sharepoint 2010 using jquery, I want to filter the results to only .pdf documents.
How can I do that? The below shows all types of files...
...
3
votes
1answer
215 views
SP2010 JSOM Client Object Model: How to get all documents in libraries including all folders recursively
I have seen a lot of examples and questions about this out there but nothing I have found has helped me accomplish this. I need to be able to grab all the names of the documents within a given ...
0
votes
1answer
59 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
82 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
2answers
372 views
SP 2010 - Client object model (javascript) - How to use get_listItemCollectionPosition for paging?
This is my code:
When I call the function to get the items, it fails (doesn't go to the fail function, it goes into the success function but crashes when I try to get the position object), and I get ...
1
vote
1answer
173 views
How to get only the first x items starting at position y from a list, using CAML query?
In sharepoint 2010 client object model in javascript, I want to create a caml query, that can download items from a list. I have this part working, but I want to download only x items, not the whole ...
0
votes
1answer
530 views
How to get caml query to return list items created by the current user?
I want a caml query that only retrieves items created by the user currently logged in. I tried this
specifier = "<Eq><FieldRef Name='AssignedTo'/><Value ...
1
vote
0answers
130 views
Help converting XmlNode to DataSet/DataTable, from SharePoint Web Services, Lists.asmx
This is my first post here, but used this site a lot :)
My question is how I can convert an XmlNode, obtained through the Lists.asmx SharePoint web service, to a DataSet / DataTable. The reason I ...
0
votes
2answers
255 views
How to check checkboxes in caml query?
In SharePoint 2010 client object model (JavaScript), I am using this caml query to download list items.
There is a column called 'Office' and in it, there are several check boxes (i.e. its a ...
0
votes
2answers
260 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 ...
1
vote
0answers
53 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 ...
2
votes
2answers
187 views
Caml query to get the next event from calendar
I'm facing a problem building a caml query for the calendar list.
Here is my caml query
SPQuery query = new SPQuery();
StringBuilder sb = new StringBuilder();
...
3
votes
0answers
109 views
CAML Query on a Lookup Field that points to a Calculated Field throws Exception
I wrote some CAML Queries to get data from a List that has lookups on another List. All is working fine as long as I do not reference a Lookup Field which points to a Calculated Field.
I tried ...
0
votes
1answer
34 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 ...
