method for querying list data

learn more… | top users | synonyms

1
vote
1answer
588 views

SPServices Autocomplete and dynamic CAML query

I have two Text filter web parts (Project and Customer Name) with Apply Filters button for one list. There is a SPServices.SPAutocomplete on each and it works great. Now, I want to show the values in ...
0
votes
2answers
31 views

Like 'String*' in CAML

How can I write LIKE 'String*' in CAML? I must create a query to display the folder structure.
0
votes
1answer
16 views

SP Caml Query Date Range

I Have a List Called Alerts with two columns as Start Date and End Date I am Trying to generate a CAML Query that retrives only cloumns for which alerts should display within that DATE range compare ...
0
votes
3answers
2k views

Current User Task using CAML Qurey

Here's my query to get current user task using CAML but it's not working SPUser me = web.CurrentUser; SPList list = web.Lists["Tasks"]; SPQuery qurey = new SPQuery(); qurey.Query = @" ...
0
votes
3answers
44 views

CAML query rertieve all items from a SharePoint list

I have a JavaScript piece of code that I use to retrieve list item from SharePoint by selected options from drop-down list. Depending the selection it would assign a value to a CAMLQuery variable. ...
1
vote
1answer
353 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
479 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
1answer
349 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}" ...
0
votes
1answer
21 views

CAML query where date field is greater than another date field

Is it possible to write a CAML query that uses another field as the Value part of the filter? For example in SQL it would look like this: WHERE Field1 > Field2 This was by best guess but it is not ...
0
votes
0answers
10 views

Order all day events on a calendar

I have a calendar list with a choice called "Category" with items A,B,C,D. I want to sort the all day events that are shown based on the selected category. I tried to set the Orderby using the below ...
0
votes
1answer
20 views

element for tomorrow CAML

I have a calendar and am wanting to find all the events that have been put into calendar for tomorrow. Is there an element like <today/> for tomorrow? Basically how can I get it so it only ...
0
votes
1answer
33 views

Create CAML query with have a value field with SharePoint column-SharePoint 2010

I have a SharePoint list. It has two columns Start date and End date. I need to query and get data if (start date + 7 days> End date). Through CAML builder its not possible to have a SharePoint column ...
0
votes
1answer
323 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
32 views

get last item in caml query

I've an issue with caml query. I'm trying to get the last item created this year but still have only one item while i'm having 4 in my list and remover I execute this in an event receiver itemAdding ...
2
votes
2answers
4k views

CAML query on Sharepoint List without duplicates

How can I retrieve all elements in a List ignoring duplicate entries So if List A contains: Employee A Employee A Employee B Employee B Employee C Employee D Employee E I want to get ...
0
votes
1answer
467 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
38 views

CAML query managed metadata field using the TermGuid

I have a dropdownlist which I populate with the names and IDs of a bunch of terms from my term store. When I then select a term in the dropdownlist an autopostback happens. When this postback happens ...
0
votes
1answer
36 views

Retrieve all lists and libraries Sharepoint Online

I'm trying to retrieve all lists from my online tenant from Visual Studio. After much fumbling and unsuccessful attempts with: ListItemCollection listItemCollection = oList.GetItems(query); and ...
1
vote
0answers
21 views

AllItems customization

I have a custom list definition where I have defined a view with BaseViewID = 1 (AllItems.aspx) <View BaseViewID="1" Type="HTML" WebPartZoneID="Main" ...
2
votes
1answer
68 views

Adding 2 Caml queries in same executeQueryAsync

Is it possible to use two different queries to get to different lists and use them in the same executeQueryAsync() Something like this : var camlQuery = new SP.CamlQuery(); ...
1
vote
2answers
442 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
905 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
0answers
20 views

Calender List events filter today

I have a calender list and various types of events like simple , all day , daily,monthly and yearly recurrence , recurrence with all day. I have to filter them to today. I have created a custom ...
1
vote
4answers
245 views

Filter list data using SPServices, CAML Query, and dropdown list

I'm trying to create a table using SPServices to fetch the data, and filter it using CAML Query and a drop down list. I would like to create three conditions: A. If no item from the list is selected, ...
0
votes
2answers
76 views

CAML query multiple values javascript

When I run the following query I get an error: <View><Query><Where> <Or><Eq><FieldRef Name='ID'/><Value Type='Number'>164</Value></Eq> ...
3
votes
2answers
7k 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; ...
0
votes
4answers
48 views

whats wrong with my query CAML

$caml = '<Where><AND><Neq><FieldRef Name="marking" /> <Value Type="Text">Off-S</Value></Neq><Neq><FieldRef Name="marking" /> <Value ...
2
votes
4answers
4k 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 ...
0
votes
2answers
33 views

Ordering CAML results

Follow up to this question: CAML is ordering by content type even though not specified I have the following query: <Where> <And> <Or> <Eq> ...
1
vote
2answers
3k views

How to write CAML Query with more than 3 AND Condition

I have search and see the way how to write CAML Query with 3 AND conditions. However, I am not sure how to write CAML Query with more than 3 AND conditions may be with 4 or 5 AND conditions. Can any ...
0
votes
2answers
55 views

CAML query for returning a single field

I'm trying to get a single field from a list. The list has columns like this: Office365Account - Type: Person Email Address - Type: Email Manager - Type: Person Basically what I want ...
0
votes
1answer
30 views

Query List with large number of items to perform aggregation

I have a scenario where there is one list with 3 columns : Col1, Col2, Col3 For each value of Col1 there would be 100 unique Col2 values. And for each Col2 values there would be 1000 unique Col3 ...
0
votes
1answer
38 views

caml query issue A or B

I have an issue with caml or query problem: <Where> <Or> <Eq> <FieldRef Name='Editor'/><Value Type='User'>x</Value> </Eq> <Eq> ...
1
vote
0answers
28 views

Query returns fewer fields depending on credentials

I inherited some code that reads in all the files from a Document Library for processing. The existing production library is a standard library bound to an InfoPath form. A new version of this library ...
0
votes
3answers
30 views

do you see anything unusual with this CAML

I am looking for list items where workflow status equal "Error Occurred". I have the following code and it's working fine. However, there are 124,000 items in my list and the code goes through each ...
0
votes
1answer
41 views

Using UpdateListItems for multiple items?

I would like to use UpdateListItems or something similar to allow my users to pass in some variable (e.g., a name) so I can use a caml query to find all items where SomeUserField = 'John B Smith' and ...
4
votes
5answers
16k views

How to get current user with javascript?

I have a list . I want select items of list with a special quary.(get items that created with current user). Then get count of items. I use this code for get current user : function Initialize() { ...
0
votes
0answers
18 views

How could I union three list into one view using caml in sharepoint 2013?

I want to create a new view to union the other lists, like SQL query "union all". I have found SPView.Joins but I cannot find syntax like SPView.Unions. How should I write my CAML query in my new ...
9
votes
2answers
8k 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 ...
1
vote
1answer
890 views

Lookup field value in CAML, 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
1answer
62 views

CAML query where to get all items

I am going to implement a search query. I have 2 inputs user can give value or leave as empty. If user leave both input as empty and Search,,all items must populated. here I have static SP CAML query ...
0
votes
1answer
44 views

Performance : Caml query taking long time to load or something else

I have a CAML query which provides a result, if a SPfolder exists or not. When i do the item.Count it takes around 2sec for the line to execute . What is going wrong and taking long time to execute ...
0
votes
1answer
121 views

date filter of today in rest api

I have a caml query filter for one of my date-time field. <Leq> <FieldRef Name ='StartDate1' /> <Value Type ='DateTime'> <Today /> </Value> </Leq> Is ...
0
votes
0answers
48 views

Query for recurrent events with combined <And> operator

I can query a calendar for its events including the recurrent ones. But I can't get it work to further filter the result set by applying logical operators. For example the list Calendar has a ...
0
votes
1answer
134 views

Get grouped items by “Group by” and applied pagination

I use "Group by" CAML element to group items and also want to applied pagination(10 first grouped items) to SPQuery. But SPList.GetItems(spquery) returned 10 items without grouping them. My code is as ...
0
votes
1answer
135 views

Join three Lists in CAML

Suppose that we have three tables(Three Lists in SharePoint).The relations between tables are described by the following image. I want to translate the following query to CAML query: select c.* ...
1
vote
2answers
70 views

Why does my console output contain html tags for some field values?

I created a custom list which contains different field values e.g. Text Choice Note Currency Peoplepicker Using the following code I print the field values to console: List mealList = ...
0
votes
3answers
65 views

What does the Author property mean in the query service?

I'm using the query search services of SharePoint and I'm not able to find in the MS documentation if the Author property matches the Created By, Modified By or both (or something else :)). Any ...
0
votes
1answer
106 views

SP2013 - CQWP query override for tasks assigned to me

I'm using a CQWP, and I need to add more than three filters. The filters I want are: Status is not equal to Completed Status is not equal to Deferred Due date is less than Today Assigned To is equal ...
1
vote
5answers
114 views

Translating a SQL query to CAML query

I am new to CAML query and as much as I have expected it to be simple like SQL I have found it quite frustrating to deal with. I have a simple query SQL query I am trying to translate into CAML but do ...