Skip to main content

Questions tagged [query]

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

Filter by
Sorted by
Tagged with
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
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
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
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
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
6 votes
1 answer
4k views

Difference between #k= and ?k= in the url

We have a custom JavaScript input box that passing the search term to the search result in a public SharePoint site. When a user log in to the site and search for stuff, everything works great. ...
YogaPanda's user avatar
  • 859
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
6 votes
1 answer
2k views

Exclude 'SharePoint' URL from Search results

We have several documents with 'SharePoint' in the title but our Online URL also has sharepoint (https://***.sharepoint.com/). When users search for sharepoint, it returns all results because all ...
Michael Colbs's user avatar
6 votes
4 answers
1k views

Soap + Rest: Trying to understand differences for selecting fields between the two

I'm working on a Java-Application that integrates with SharePoint. The different SharePoint services are currently requested via the SOAP API. I am now working on an abstraction layer to also ...
Dave's user avatar
  • 191
5 votes
4 answers
13k 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 ...
Justin's user avatar
  • 1,361
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
5 votes
1 answer
11k 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 ...
bender's user avatar
  • 287
5 votes
3 answers
4k 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 ...
Christian P.'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
2 answers
2k views

How to use SPServices search sql query - getting malformed query

I am using the SPServices javascript library to make a search request to sharepoint 2010 search. I am trying this query: queryText = "<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'...
omega's user avatar
  • 2,160
4 votes
2 answers
911 views

People or Group field returning semicolon hash then Name

In querying the properties of a list item, I found that returning the value of a people or group field that the value would be returned in the form 1;#George Grainger Using the code: properties....
George Grainger's user avatar
4 votes
1 answer
2k 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), ...
Alex's user avatar
  • 1,089
4 votes
1 answer
1k 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
Shelly Miner's user avatar
4 votes
1 answer
90 views

Site Search results are the same no matter the query

I am having trouble with the search in SharePoint 2013. The problem : I am running in to is that no matter what I search for in SharePoint, the results page populates that same exact documents in the ...
Jacob Caldwell's user avatar
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
4 votes
2 answers
134 views

Filter list with REST

I'm trying to filter a lookup column on my list using rest this is the column on my list it's a look up (connected to another list) and my rest on the list My query should get all the items that ...
SharonG's user avatar
  • 73
4 votes
3 answers
4k 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 ...
Lukie's user avatar
  • 263
3 votes
4 answers
1k 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?
nfw's user avatar
  • 747
3 votes
1 answer
4k views

Filter Hyperlink field url using SharePoint REST API

I want to filter Hyperlink filed URL using REST API in SharePoint 2013. My URL is like below is working fine https://<siteurl>/_api/Web/Lists/GetByTitle('Pages')/items?$select=NavigateURL/Url ...
Vijay's user avatar
  • 131
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
3 votes
1 answer
5k views

URL query with multiple wildcards

I have a list and I need to do a search on an item given two fields: topic and community. Both fields can have more than one item and they're both text field fields from an infopath form: For ...
Batman's user avatar
  • 1,478
3 votes
2 answers
602 views

Search Results WebPart: Result preview returns more results than actual

I am using the search results webpart to return a list of people in a particular department. I set up the query correctly for the webpart and when I do "Test Query", it returns 8 relevant results in ...
JustAnotherDev's user avatar
3 votes
1 answer
123 views

SP 2013 Search Results web part

I am trying to create an org chart based on a persons department. I am using the Search Results web part in SP 2013 Enterprise. When I build the query I select the "Local People Results (system). I ...
S Turner's user avatar
3 votes
2 answers
1k views

Grabbing a filter value via CEWP code behind

I have employed a Query String Filter to parse a value and send it to a chart web part. now I would like to use this value in a CEWP to provide an explaination/clarification for the chart, but the ...
Hank's user avatar
  • 51
3 votes
1 answer
2k views

How do I prioritize search results to show file names containing keyword appear first?

I have a document library in sharepoint online and I need to have the search results show any documents that have the searched keyword appear in the file name come up first in results, (i.e. if I have ...
Courtez's user avatar
  • 31
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
3 answers
3k views

SharePoint Query Builder unknown error

On a SharePoint 2013 on-premises, we tried to install the August 2015 CU. However, the installation failed and since then, all Content Search web parts show an error if I try to change the query. The ...
Jim's user avatar
  • 31
3 votes
1 answer
968 views

phone number search query

I am writing a query for phone numbers in search so when you input any part of the number it is returned by the search. I tried using this : (MobilePhone:{subjectTerms} OR PhoneNumber: {subjectTerms}...
bimbob's user avatar
  • 471
3 votes
0 answers
599 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 ...
Drew's user avatar
  • 31
3 votes
2 answers
211 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 ...
Russell's user avatar
  • 3,031
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
1 answer
2k views

Rest API filter quote

I am using the SharePoint rest API, I need to quote a string in the filter query. This is my query: ?$filter=MyField eq 'aaa'aaa' How can I search the string " aaa'aaa "? Thanks
Nk SP's user avatar
  • 2,873
2 votes
1 answer
743 views

CAML query filtering is not working

I've googled that it can be in case when query is not well-formed. But I'm verifying it for several hours and didn't find any mistake. Problem is common: query doesn't filters and returns all data. ...
Alex Zhukovskiy's user avatar
2 votes
1 answer
3k views

sharepoint search boolean managed property

I have a managed property isActive which happens to be a Boolean. I am creating a search query and I only want the ones that are active so isActive:true however I am having trouble with the correct ...
jimmywhizz's user avatar
2 votes
4 answers
16k views

Sort content search web part in alpha order by title

I have a content search web part that is displaying a bunch of things from a cross-site publishing catalog. That is working just fine. But I would like to sort the items in alpha order. I would have ...
Rothrock's user avatar
  • 3,010
2 votes
2 answers
88 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 ...
JᴀʏMᴇᴇ's user avatar
2 votes
1 answer
2k views

In a search display template, is there a search property available for the actual text (k=...) in Srch.U or any of the search objects?

I'm trying to add the searched text value to the query string in the url (<a href='...?searchText=[something]'>Title</a>) In the search display templates, I see ctx and Srch objects ...
Dinerdo's user avatar
  • 769
2 votes
2 answers
123 views

Query to a list doesn't work

I want to get the number of comments from the list "Comments" of a blog site. To do that, I have a query with this code: using (SPWeb oWebsite = oSiteCollection.OpenWeb(new Guid(WebId))) ...
Daniel 976034's user avatar
2 votes
2 answers
2k views

Hide 'People named' section in search results

I'm building a custom search page for a document library, I've defined this query for it : {searchboxquery} (contentclass:STS_ListItem OR IsDocument:True) Path:https://pathtolobrary The search is ...
JJD's user avatar
  • 493
2 votes
1 answer
42 views

Importance of .Include in the query

Following this msdn page on SharePoint development I have encountered the following issue that I do not understand. Case scenario: We are trying to retrieve List of all visible Lists that are present ...
Robert J.'s user avatar
  • 195
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
2 votes
1 answer
7k views

How to use the Content Search Web Part to filter on a custom column property?

I am quite new to SharePoint 2013 and I have been working lately with the Content Search Web Part. However I haven't been able to make possible a filtering through a custom column that I have on a ...
user31620's user avatar
2 votes
2 answers
8k 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: http://devServer/majorMatter/_api/Web/Lists/GetByTitle(...
Adeybaby's user avatar
2 votes
1 answer
512 views

Pnp : create a search query

I need a little remembering on pnp.search() queries. I know from a verified source that you can use either query text, SearchQuery Interface or SearchQuery Builder. No worries about that (except that ...
Gaelle's user avatar
  • 592

1
2 3 4 5
7