method for querying list data

learn more… | top users | synonyms

2
votes
1answer
233 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
34 views

CAML Query with both and & or logics

How do I build a CAML query for this condition, Status = "Current" (or) Status = "Outgoing" (and) Log Status = "Not Submitted" ...
1
vote
1answer
165 views

Problem with Caml Query

I need to put this code: <View>"; <Query>"; <Where>"; <Eq>"; <FieldRef Name='PublicY' />"; ...
1
vote
1answer
863 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 ...
1
vote
1answer
259 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 += ...
1
vote
1answer
1k 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 ...
1
vote
1answer
291 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
456 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 ...
2
votes
0answers
13 views

Why a pair of FieldRef must be specified for a Join?

I'm writing a small js library to abstract away the annoyance and complexity of creating a CAML query. In that regard, can you explain the significance of both FieldRef elements within a Join, when ...
2
votes
0answers
58 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
240 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
7 views

Camlquery: Getting items from top root folder of list

I know how to get items from a folder inside a list (example below) CamlQuery caml = new CamlQuery(); caml.FolderServerRelativeUrl = "/folder/path"; But how do you get the items from just the top ...
1
vote
0answers
27 views

How to make CQWP retrieve 4 most recent Items in the whole site collection?

I'm a little stuck with one of m Content Query Web Part: On my homepage, i would like to display the 4 most recent items added to my site collection in a Content Query Webpart called "What's new?" So ...
1
vote
0answers
15 views

How to query Range

Right now my code is is Equals in the query how can i prevent for example that if i book 2014-12-01 01:00 to 2014-12-02 01:00 This is a hole day, that no one else can for example book the same time ...
1
vote
0answers
33 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" ...
1
vote
0answers
47 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 ...
1
vote
0answers
95 views

Manage files with no checked in version - CAML query

I am using Office 365. We have a document library containing more than 12000+ documents, with a number of folders and subfolders. I need to find a way to get all document which have no checked in ...
1
vote
0answers
59 views

Is there a setting on SPField that would prevent it from being included in a CAML query?

I'm trying to build a CAML query for a managed metadata column. I'm following the guidelines provided here by Microsoft. Essentially they say to query for the term's Wssid. No problem, I can do ...
1
vote
0answers
868 views

How to query the list using CAML Query to List's multi allow user field?

I have a list in which there is one column which is of type People or Group with multi allow. I have created Item Adding event receiver in which I am checking the entered people value is already ...
1
vote
0answers
621 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 ...
1
vote
0answers
155 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 ...
1
vote
0answers
44 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 ...
1
vote
0answers
123 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
234 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 ...
1
vote
0answers
165 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
120 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
1k 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
104 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
11 views

retrieving user name in Jquery datatable and caml query

Hi I am on SharePoint 2010 version , I have created a list with createdby, createdDate and Employee name as columns in it. I am having a text box and a button when I enter employee name and click ...
0
votes
0answers
36 views

CAML Query for getting folder contents based on folder parameters

I have the following folder structure. Folder1 attr1="cat1" >> file1 attr2="subcat1" >> file2 attr2="subcat2" Folder2 attr1="cat2" >> file3 attr2="subcat1" >> file4 ...
0
votes
0answers
34 views

CAML query reporting services, date field

I am using reporting service to query (with CAML) a list on SharePoint. The list has an external content type, my problem is that just the Date field is not rendered fine. This is my result: ...
0
votes
0answers
70 views

Caml LookupId and LookupValue

I need to get the LookupId value and the lookup text value by CAML. With this query I get the ID but I can not get the value text anymore. <RSSharePointList ...
0
votes
0answers
169 views

How to iterate list items from two list using where in powershell script

I have two list from where i want to collect common items. I am not able to make use of $caml in my script. My script: Add-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue ...
0
votes
0answers
37 views

How to retrieve the ISO/original value of a DateTime column in a list using CAML?

I'm using SharePoint Foundation 2013 and I want to retrieve the data in my DateTime column. Is there a way to retrieve the original/raw values or ISO values of a DateTime column using CAML query? ...
0
votes
0answers
17 views

Child node alphabetical order caml query sharepoint

qry.Query = "" + ParentNode.Text + "" + ""; I am using above caml for sorting child node. But not working . please let me know where i am doing wrong. ...
0
votes
0answers
74 views

Caml Query to retive the List items based on the category

List Name Social Column name Category(Choice Field),Values(Text ) Category values modified ................................................ Facebook sameple update ...
0
votes
0answers
46 views

Issue with CAML where clause in predefined elements view

I have the following CAML query in a view elements.xml file: <Query> <Where> <And> <DateRangesOverlap> <FieldRef ...
0
votes
0answers
41 views

camlquery to get only the items

I've a large document library with folders, i'd like having all the items except the folders. for now i use this where columns is a list of all internal name from the list CamlQuery q = ...
0
votes
0answers
117 views

Bind GridView using CAML query JOIN

I want to show data from 3 lists in gridview, using CAML query join. I have multiline fields in 2 of these lists. As per my knowledge these multiline fields cant be included in CAML Query JOIN. FYI, ...
0
votes
0answers
43 views

Convert LINQ query to CAML

Please anybody help to convert below LINQ code to CAML:- var objPendingRequest = from reqHeader in objResourceAllocation.RequestHeader.ScopeToFolder("", true).ToList() join reqDetail in ...
0
votes
0answers
112 views

CAML query on site to get all items modified after a date

I'd like to know a way or if it's possible to get all items modified from a date in a site. Now for having this, I've a client script because i'm in sandbox solution, I've to loop on each list of the ...
0
votes
0answers
118 views

SP2010: Displaying CAML query results in XsltListViewWebPart

How can I get my CAML query to call the results on a XsltListViewWebPart in SP2010? Before I continue, 3rd party codes are not supported in the environment I'm working with and this particular page of ...
0
votes
0answers
21 views

Requete CamlQuery

My question is to check if my CAML query query is good or not. I want to get items from a list by the email of the current user.
0
votes
0answers
76 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
0answers
48 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 ...
0
votes
0answers
127 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
0answers
66 views

Get SPListItem by title is very slow

I want to get a SPListItem by title. I´m using a caml query to filter the list (Around 1000 items). There is only 1 item with the title in the list. My problem is now that the performance is really ...
0
votes
0answers
194 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
0answers
40 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
155 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. ...