Questions tagged [query]

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

Filter by
Sorted by
Tagged with
10
votes
2answers
19k 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 ...
1
vote
2answers
12k views

Using CAML Query to Retreive from Multiple Lists

I am creating an applicant tool which contains the following lists: Applicant; Applicant Answers; Job Questionnaire; Job Title The lists are related as follows: Applicant.ID = Applicant Answers....
12
votes
2answers
34k 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> &...
12
votes
1answer
48k views

CAML Query, get item by lookup value, not by ID

I have the value of a lookup column, but I don't have the ID, I want to query items from SharePoint list using the lookup value. How do I achieve that in CAML?
10
votes
1answer
9k 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.
0
votes
1answer
1k views

AllItems View of Query String: can I group using value in query string?

Can I somehow how a query string to show a group of documents within a given library. Not one single item, but the AllItems like view. So within the library I have a grouping type of id value in a ...
13
votes
8answers
52k 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
10k 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 ...
5
votes
3answers
6k 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 ...
4
votes
1answer
4k 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 ...
2
votes
2answers
5k views

REST query not working on list after 5k threshold

The following query works on one site: mysite/_api/lists/getbytitle('Listname')/items?$top=5001&$filter=IndexedCol1 le 'M' and Author/Title eq 'John Doe'&$expand=Author/Title&$select=...
2
votes
3answers
5k 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
335 views

“Find Similar results” Fast search for sharepoint 2010

I trying to implement "find similar results" in fast search for sharepoint 2010. Im using the docvector manage property and similarTo property(KeywordQuery property) for this. I hv to pass the ...
1
vote
3answers
309 views

SharePoint - CAML query where check TextBox for existing “User Name”

I need to make query in SharePoint WebPart with VisualStudio. I have list "Employees" and need to check this list for existing UserName! <tr> <td class="auto-style1">...
5
votes
2answers
6k views

Querytext: blank value for a property

How could I specify in a Querytext that I want all the elements that doesn't have defined a value for a property? For example, let's say that I'm interested in the property CheckoutUserOWSUSER, how ...
3
votes
1answer
3k 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
1k 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(); doc.LoadXml(((XsltListViewWebPart)...
1
vote
2answers
442 views

Managed Property not recognizing in QueryText

I have a KeywordQuery that is sorting using the StartDate (managed propery: StartDateOWSDATE). However it does not recognize StartDate in the QueryText. Error: We didn't understand your search terms. ...
1
vote
2answers
6k views

Query String parameter - Multi FilterMultiValue on different columns

Is there a way to combine FilterMultiValue on different columns? ex ?FilterName=HomeCountry&FilterMultiValue=Norway;Global&FilterName=HostCountry&FilterMultiValue=US;Global I want to ...
0
votes
2answers
794 views

SharePoint List Ping IP Address

We have setup a SharePoint page with a list of our office sites. At the moment we have a column called status so in the event of an infrastructure outage, we manually change the status from Connected ...
0
votes
2answers
4k views

Search results webpart displaying items without search box query

I have ecoutered a strange behavior with search results web part. The scenario is, that we have blank page with some web parts on it. Part of the page is also search box web part and search result web ...