A precise request for information retrieval with database and information systems.

learn more… | top users | synonyms

11
votes
6answers
16k views

How to query Sharepoint 2010 lists with sql?

I think it has to be a common task. We have some applications on sharepoint and we need to prepare reports with data from these applications. It would be great if we could use Reporting Services. We ...
5
votes
3answers
2k views

How to query multiple document libraries?

I need to query multiple document libraries and get a particular item's ID by matching the queried barcode value. I need the ID to update the metadata for that item using web services. All the ...
5
votes
2answers
3k views

Get all Files from sub folder of a certain content type

my problem is I have a document library with sub folders. Also the document library got more than one content type. Is there a way to create a CAML or LINQ query to get all files of a certain content ...
5
votes
1answer
2k views

Is it possible to return only the count of the query?

Is there any way to return only the count of the rows from a Sharepoint query? I would like to get only the count of the result returned by sharepoint query.
4
votes
4answers
4k views

Multiple Values in CAML query from Array? SharePoint 2010 using jQuery/SPServices

So if I use SPServices to GetListItems with CAMLQuery, is it possible to insert multiple values inside Value Type='Number'> here I would like to evaluate things throught a flow in my page, add to an ...
4
votes
3answers
2k views

How to get visible SPField's for a specific list view

I am trying to enumerate a list based on a selected view - basically, programmatically doing what is visually shown when viewing a list. I will be using this to output a file, so I am first getting ...
4
votes
1answer
493 views

Error using javascript to retrieve a SharePoint list's items

I am trying to use this method to query items of a column of a list in my SP site via javascript (the reason I am doing this is to display that info on the page by modifying the html tags in the DOM), ...
4
votes
1answer
317 views

Errors executing bulk query when updating a Sharepoint Linked List from Access

I have a Sharepoint list that is a Linked List with MS Access (2010). It has just under 5,000 items (4,864), thus meaning it avoids the reduction in functionality lists of greater than 5,000 items ...
3
votes
4answers
927 views

What is the recommended way to query data on a Sharepoint site?

Say if I need to retrieve list items for batch processing, how would I be recommended to retrieve the data? Maybe Powershell or a SQL Server query?
3
votes
2answers
720 views

Jumping to a specific page within a SharePoint List

I was wondering what people think the best way is to jump to a specific page within a sharepoint list, taking into account performance considerations. eg: 1) List with 1000 items in it 2) Each page ...
3
votes
2answers
186 views

View SQL Queries/times for page request

SharePoint 2010 has the fancy new developer dashboard where you can view the SQL queries made and how long they took to determine bottlenecks etc. I am not a SQL Sysadmin so I cannot use SQL profiler ...
2
votes
2answers
65 views

Where can I find a list of fields that can be retrieved when running a sharepoint query?

An SPSiteDataQuery. So far I have: ... query.ViewFields = @"<FieldRef Name=""Title"" /><FieldRef Name=""Author"" />"; ... I just happened to get these two FieldRef's right (purely ...
2
votes
1answer
6k views

Querying a simple list with a 'User' column, using CAML

I'm having some trouble getting a CAML Query working against a very simple list. My custom list has the fields: Person : User Date : Date Amount : Lookup My query looks like this: <Query> ...
2
votes
2answers
47 views

Querying against a note field with the REST API 2013

I'm getting the error The field 'OtherInfo' of type 'Note' cannot be used in the query filter expression whenever I run a query like this: ...
2
votes
1answer
72 views

QueryManager to find all documents modifed by current user

I'm creating a webpart which derives from Microsoft.Office.Server.Search.WebControls.CoreResultsWebPart and the purpose of this webpart is to find all documents modified by current user. I've figured ...
2
votes
1answer
67 views

KQL for date range

I've a managed property datetime and i try to use a search for having the result in range. The issue is that i don't know how to format the date myManageProperty=01/02/2014..17/02/2014 but i don't ...
2
votes
1answer
110 views

Dynamic Content Editor Text File

I would like to have the text file associated with my content editor change based upon the query string. ?division=Name Content Editor link: /site assets/[QueryStringResult].txt
2
votes
1answer
561 views

Send current user's parameter to External Content Type

Is it possible to send the current user's username as a parameter for my External Content Type query? I am on SharePoint 2010 Standard.
2
votes
0answers
135 views

XsltListViewWebPart Custom Filtering on Query String with paging

We are working on a solution to use custom query and paging inside a XsltListViewWebPart. This work,s but the paging does not work: var doc = new XmlDocument(); ...
2
votes
1answer
49 views

creating CAML queries in a 32 bit environment?

I'm currently developing with SharePoint on my 32 bit computer. While I'm able to make simple changes with designer on my PC I'm aware that using visual studio to make changes (CAML queries) without ...
2
votes
0answers
219 views

Sorting in Search.asmx querypacket

I have this querypacket to query Search.asmx service, and get back the results, stored in queryXML object, I can retrieve data successfully, but I can't figure out how to sort this data on any field I ...
1
vote
2answers
119 views

Why does SPList.GetItems(string fields[]) return more fields than specified?

I'm using SPList.GetItems(string fields[]) to obtain only specific item fields from a document library: SPListItemCollection items = list.GetItems("UniqueId", "Name"); However, iterating the items ...
1
vote
2answers
87 views

How to raise character limit in FQL Query?

as stated in the msdn, the maximum length of a FQL Query is set to 2048 characters (SharePoint 2010). Is there any way to raise this limit?
1
vote
1answer
1k views

How to use Content Query by query string parameters

I need my Content Query Web Part to show some content which depends on a Value of a property. Now I had no problem doing it "statically", putting in the properties the filter like: Column is equal to ...
1
vote
2answers
66 views

How can I get the correct SPFieldUserValue to use SPSiteDataQuery to aggregate tasks for a certain user?

I'm trying to gather all the tasks of a certain content type for a certain user. To accomplish this I'm using a SPSiteDataQuery which looks like this: string where = String.Format(@"<Where> ...
1
vote
2answers
41 views

Get all values of a specific column of a specific content type

I have a custom content type. In this content type, I have a text column (Mycolumn). In a site collection, I have several instances of list bound to this content type. Is there a way to retrieve all ...
1
vote
2answers
3k views

query a sharepoint 2010 list from excel vba to retrieve a specific record

I have created a SharePoint 2010 list with 2 relevant columns: - Identification Key - Version Number I want to be able to query this SharePoint list from Excel VBA - passing the Identification Key to ...
1
vote
2answers
1k views

How can I query all of the items which are inside a folder, which is in turn inside a document library?

I am trying to use Powershell to query my Sharepoint site so I can get a list of items to use as input in my migration script. I have a document library (Site Assets), which has a folder (Calendar ...
1
vote
2answers
33 views

Your query is malformed with a date in where clause

I'm trying to query SharePoint using jQuery and SPServices. When I run the code below, I get the error Your query is malformed. Please rephrase your query. var searchq = ...
1
vote
2answers
65 views

Query External Data using BCS

I'm using SharePoint 2013 and I'm developing a webpart that has to query an external data and show the results. I cannot create external list due to the fact that my external table has more than ...
1
vote
1answer
51 views

Combining 1 item from 2 SharePoint lists

I have SPList A which has the columns: Title, Description, Category. and SPList B which has the following columns: Column1, Column2, Category. I want to make one object for items with the same ...
1
vote
1answer
176 views

Appending Google Analytics query string to outbound links in SharePoint 2010

I am looking to append Google Analytics query strings to outbound links but SharePoint 2010 strips it out when you save the page. Is there a way to add those or do I have to use javascript to append ...
1
vote
1answer
731 views

How do I convert CAML to use in the CQWP?

I have the following CAML query which returns checked out files. <Query><Where><Eq><FieldRef Name="CheckoutUser" /><Value ...
1
vote
1answer
259 views

Get all webs with certain property value

If I have a certain number of webs within my site collection, and those web have set some property, eg. web.Properties["foo"] = "bar". I'd like to get list of all the webs which have property foo set ...
1
vote
3answers
2k views

Page a list via A-Z

So I am trying to create an a to z directory from a list of items which should be an easy task and it is really, however, I am trying to find the most efficient way of doing it. So I was thinking use ...
1
vote
2answers
622 views

Selecting single user from User Information List

I've got a problem with not being able to select a single list item from the User Information List, I have used U2U CAMLbuilder to build a query that extracts an entry with the ID = 1 When run in the ...
1
vote
1answer
933 views

External List Error : The query against the database caused an error

I got an SQL Server 2008 R2 and a SharePoint Server. I have put up a BCS between the two servers. Reading data through a External List. This worked fine yesterday. But to day I got this error: The ...
1
vote
1answer
38 views

Caml query after modified choices

I have a column with an internal name of: PublicY with 2 choices: Yes/No, the query works but if I change the choice name to Ja/Nej the code will not query the results, why? I have tried to change the ...
1
vote
0answers
21 views

MySites URL - use another query paramater other than accountname? GUID? | SP 2013

Is it possible to use a different query parameter other than accountname for Mysites? For example, can we use the GUID to link a person to the person.aspx page? The problem is that because the ...
1
vote
0answers
34 views

sorting with querymanager

i see a function orderBy but i don't understand how it works and if it's the correct solution. i'd like know the way to sort the results from querymanager or maybe do this in kql? and then are there ...
1
vote
0answers
66 views

Sharepoint 2013 Search File Share result source exclusion

I'm using the query builder to try and get the results excluded containing the string "archive" The content source is a file share, not a web page. This is one of the hundred query transform ...
1
vote
0answers
27 views

DataView Webpart Folders

Is there a way to pass the root folder parameter to a page that the DataView webpart consumes? If I have a page, test.aspx with a DVWP on it, it will show all my documents and folders in a list. If I ...
1
vote
1answer
109 views

Switching Search Results Sort Order if Keyword Term Exists

We have a Course Listing based on results surfaced by a Search Results Web Part that is configured to use a specific Results Source. The web part serves a dual purpose in that by default it should ...
1
vote
1answer
254 views

Choice field not allowing save on choice field value changes

I have a SharePoint 2010 List with a simple Choice column called "RequestType" with values like New Hire, Job Change, Equipment Request, etc. I can add the new records and select any option, but ...
1
vote
2answers
519 views

Using a Dynamic Redirect in SharePoint

Here is the situation: I have two libraries, one housing current documents, and another which serves as an archive. I have a workflow which sends the owner a link to their document. The problem is ...
1
vote
1answer
162 views

Compare Date to constant using ACE.OLEDB.12 in Excel VBA [closed]

After a lot of searching, trial and error, I finally managed to come up with an Excel VBA procedure that will return date from a SharePoint list. The query works fine if I do not qualify the Select ...
1
vote
1answer
119 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
0answers
110 views

Multiple Column Lookup field from Access to Sharepoint

I have two fields called "Tool ID" and "Tool Name" in my main "Tools" table in Access. "Tool ID" is set as the primary key, in that it gives each tool a unique autogenerated number. When I ...
1
vote
3answers
1k views

Web service based CAML query breaks 5,000 item limit

I have a CAML query of the form shown below which is called via the Sharepoint web service interface to search the entire Sharepoint site containing 600,000 documents looking for documents: ...
1
vote
1answer
212 views

Filter query by site property

I have set a crawled property at the site level using $site.IndexPropertyKey.Add() and $site.Properties.Add() I set the value of that property to "somevalue" I full crawled. I mapped it to a managed ...