Skip to main content

Questions tagged [query]

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

Filter by
Sorted by
Tagged with
10 votes
2 answers
23k 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 ...
Markus S's user avatar
  • 302
14 votes
7 answers
62k 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 ...
agnieszka's user avatar
  • 424
2 votes
2 answers
13k 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....
Adrian's user avatar
  • 121
17 votes
1 answer
70k 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?
SharePoint Freak's user avatar
12 votes
2 answers
41k 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> &...
user avatar
11 votes
1 answer
10k 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.
ahmad mirza's user avatar
7 votes
2 answers
10k 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 ...
yngrdyn's user avatar
  • 918
0 votes
1 answer
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 ...
Justin's user avatar
  • 1,361
6 votes
8 answers
24k views

How to get the ID of a list item with a given GUID in Sharepoint online with REST api?

I tried a request at a url of the following form .../_api/web/Lists/getByTitle('docLib')/items?$select=id,GUID&$top=1&$filter=GUID eq '2779cf8051-381f-4834-93dc-ece6345dde33' and i get "...
Sbiera Bogdan's user avatar
5 votes
3 answers
12k 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 ...
Mattmoo's user avatar
  • 182
5 votes
3 answers
7k 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 ...
sange's user avatar
  • 347
4 votes
1 answer
6k 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 ...
Andrew Martin's user avatar
3 votes
0 answers
4k views

All query processing components are in 'Failed' status

Error logs on Sharepoint 2013 Search Farm: Microsoft.Ceres.InteractionEngine.Component.FlowHandleRegistry : Exceptions occurred when evaluating the flow. Microsoft.Ceres.Evaluation.DataModel....
tudor's user avatar
  • 31
3 votes
1 answer
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.
Rick's user avatar
  • 441
2 votes
2 answers
6k 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=...
Dinerdo's user avatar
  • 769
2 votes
2 answers
5k 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 ...
MahonyCZ13's user avatar
2 votes
4 answers
6k 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: <...
user16549's user avatar
1 vote
1 answer
4k views

Configure Search for a specific Column

I'm creating kind of a knowledge base in SharePoint. I have a list with columns Title, Issue, Solution and Topics. Topics rely on managed metadata from termstore. When People use the search of the ...
Kopfbandage's user avatar
1 vote
2 answers
8k 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 ...
Plexus81's user avatar
  • 2,250
1 vote
1 answer
354 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 ...
user1584578's user avatar
1 vote
2 answers
618 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. ...
tomsmithweb's user avatar
1 vote
3 answers
471 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">...
Goshky's user avatar
  • 2,058
0 votes
2 answers
74 views

Lost listing from contentClass:STS_List_DocumentLibrary

Within SharePoint Online, I have a page that is making use of the "Highlighted content" web part. Here are my settings for it : Custom query is selected The source is set to "This site&...
klewis's user avatar
  • 1,353
0 votes
2 answers
1k 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 ...
surfnode's user avatar
  • 439