Skip to main content

Questions tagged [query]

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

Filter by
Sorted by
Tagged with
1 vote
1 answer
2k views

Check a property is not null in search rest api

I write this query for search user in a site. /_api/search/query?querytext='*'&sourceid='b09a7990-05ea-4af9-81ef-edfab16c4e31' I want to add a filter that the result must contains WorkEmail. I ...
0 votes
1 answer
1k views

Search for content type under multiple paths

In SharePoint 2013 on premise, I have a search page with a search box where it is possible to search for items of a specific content type under a specific site. This works as expected. path:"http://...
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: <...
0 votes
3 answers
2k views

How to count number of days from SharePoint list?

How to count number of days between two dates from SharePoint list using CAML query/JavaScript? Thanks
1 vote
1 answer
2k views

Query list in designer workflow

I have created a approval workflow using SharePoint Designer workflow. I want to query the task list to get the task with minimum due date for the current task approver. Below is the scenario : I ...
0 votes
1 answer
2k views

Use multiple words in a result search query

I have made a result query with a few managed properties. We can now search for the metadata columns which works fine. I can't use multiple words in the search for the title column. Here is my query `...
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 ...
0 votes
2 answers
2k views

Content Search WebPart: query Date and Time field

I have calendar list, Now trying to query items which are greater than Today. so first I have created new managed property with name EventDate and mapped the crawled property ows_EventDate with type ...
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 ...
2 votes
2 answers
2k views

hosting an iqy file on a sharepoint

I want to export a list from sharepoint into excel. I can do this export easy with an iqy file. Once I have this iqy file (which by default is saved in my temporary area but I will save it to my ...
0 votes
1 answer
1k views

Can I reach the lookup column's data with CAML query?

I want to reach the list's data. There is lookup column. I am using CAML query. But when I create a query with CAML, I am seeing look up columns like Microsoft.SharePoint.Client.FieldLookupValue[].I ...
0 votes
1 answer
3k views

Recursive CAML query

I would like to search items between two dates in a DocumentLibrary. The query find the files at root just right. However the query doesn't seem to be considering files in folders. Here is my attempt ...
0 votes
1 answer
2k views

Sharepoint API search for string with special characters

I try to search for a string like: 1001ˌtestcompanyˌtestcity with the SharePoint Online search query: var url = encodeURI("/_api/search/query?querytext='" + this.searchstring + "'&...
0 votes
0 answers
34 views

Graph search query: total results differs between pages

I'm encountering this issue: calling the POST /v1.0/search/query Graph API, with the following body: { "requests": [ { "entityTypes": ["listItem"],...
0 votes
0 answers
22 views

Sharepoint API Fetching 3 times? Instead of 1

I have been facing this issue whereby my sharepoint api is fetching more than once. The function is only being called once BUT it fetches more than once..? Which causes some issue for the displays. ...
0 votes
2 answers
75 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&...
0 votes
1 answer
21 views

Manage Query Rules is missing from the Admin Console

In the More Features section of the SP Admin Console there used to be Query Rules. We have some created specific to our intranet site collection. I'm a SharePoint Admin and have always managed them ...
0 votes
0 answers
7 views

Manage Query Rules is missing from the Admin Console

In the More Features section of the SP Admin Console there used to be Query Rules. We have some created specific to our intranet site collection. I'm a SharePoint Admin and have always managed them ...
0 votes
0 answers
41 views

Group delta response with 'select member' returns null for members

I am trying to sync members of a 365 Group but in the delta query I am getting null value in members. I am following the guide from Microsoft here. To quote from that guide: "..such as when users ...
1 vote
2 answers
143 views

How to create query rule group and move the query rule to that group?

I have created 3query rules in SharePoint 2013. I need to create query rule group using powershell and and define the ordering . anyone give me the better idea to create query rule group using ...
0 votes
0 answers
18 views

How can I reach the path link in the details sidebar when the activity constantly refreshes?

Dont really know how to expand on the title, but im querying excel files in a sharepoint folder. Someone has changed the name of the files which has broken the links, so I am restablishing them. When ...
1 vote
1 answer
81 views

SharePoint 2019 content search Query

I am currently attempting to only pull the Yes from the column in a list . I only want items that are set to yes in the list to be pulled the column is already in my search scheme and managed ...
1 vote
2 answers
4k views

Pulling data from multiple excel files hosted on Sharepoint

I have a load of excel files (consistent format, but with different content) that I would like to pull data from into one master file. All source files are saved on Sharepoint in one folder, and the ...
0 votes
2 answers
2k views

Inside the PnP Modern Search Result web part what is the differecne beween Query Text and Refinement filters

I added the PnP Modern Search web part from this link @ https://github.com/microsoft-search/pnp-modern-search/releases . and inside the "PnP - Search Results"web part, i have 2 sections; ...
0 votes
1 answer
52 views

CAML Query IN operator not returning the desired results. If I change one Choice column, it stops to appear!

I've a query that goes like this: <In> <FieldRef Name='Industry'/> <Values> <Value Type='Text'>Insurance</...
1 vote
1 answer
793 views

Where can one find a full list of SharePoint URL Query options?

If I am asking a duplicate for this, please let me know and I'll gladly peruse that question. I'm looking for a full list of all the different options available for SharePoint queries (note - not ...
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}...
0 votes
1 answer
748 views

SharePoint Search Issue: Wildcard after one letter throws error

Summary: On an SP2019 environment, "test a*" search query throws an Unknown error while "test t*" query works just fine. Tested from both SP default search page and from Search ...
1 vote
0 answers
172 views

Search keyword query not working as expected when searching for item that contains - in it

I have mapped a column to RefinableString01 which I am using to search for an item. When searching for RefinableString01="test" It will bring back the result. but when I search for ...
1 vote
1 answer
60 views

Why does this code works? Calling executeQuery without Load [CSOM]

First question: Why we don't need ctx.Load(web) before defining the List? I see that we use web object in defining the List Second question: Why are we not calling ctx.Load() before ExecuteQuery ...
1 vote
3 answers
3k views

SP2019 search is not working

Created brand new SharePoint 2019 Farm using AutoSpInstaller. In Central Administration, all Search services are showing green. But Search is not giving any results. ULS log shows below messages: ...
0 votes
0 answers
1k views

w3wp.exe Search QueryProcessing All query processing components are in 'Failed' status

Thanks to Corona, the cheapest worker and absolute Sharepoint newbie can now get angry with a customer problem. I am grateful for absolutely ANY help. Unfortunately, I'm slowly really desperate. For ...
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 "...
1 vote
0 answers
170 views

OData query to get a field values by column position in the list

So I want an OData query that allows me to get the field and its values by position in the viewable list. In the above picture, for example, I want the values in the "Title" column but that ...
0 votes
1 answer
822 views

powershell query row limits for SharePoint online

I am not a super scripter, but I have a requirement run a search query over a site with multiple libraries. The query is for all documents where a specific string (someone's name) appears. I have 2 ...
0 votes
1 answer
878 views

SharePoint search query: display people from a specific AD group

I want to display all members / users who are in the Active Directory group "Marketing". What do I have to add / change to the following query so that I don't see all users, but only those ...
0 votes
1 answer
45 views

Is there a way to use refiners to call a "standard" search result page from a custom query?

Semi-novice here. When one sees people using FilterField1 and FilterValue1, they are executing a query against a library, with the user seeing the results in the standard library view. Is there a ...
0 votes
1 answer
20 views

Results source not displaying items from Teams site

We have a 3rd party intranet which uses SharePoint Online as it's back end, this is where our documents are stored. We have been using a library in a cassic SharePoint site to store documents ...
0 votes
1 answer
323 views

SharePoint Online Managed Properties Documentation

I'm trying to figure out how to limit a SharePoint Online people search to only people that are part of a certain Office365 security group and was going to attempt to do that by querying managed ...
0 votes
2 answers
158 views

Search Query Rules not showing in Central Admin

I have created few Search Query Rules from different site collections. I was trying to edit them from CA and I cant see none of them. Any reason?
0 votes
0 answers
31 views

Search Query Result

Since few weeks ago I have an issue with my Search Query Rules. The issue I have is I can't access the Search Query Rules from Site Collection, however I can access from Central Admin. I only created ...
1 vote
1 answer
106 views

CAMLQuery is not rendering title item from the list

Here is the list (please note 'Full Name' column has been changed to 'FullName' since I took this shot: Here is the CAMLQuery: $(document).ready(function() { var camlQuery = "<View>&...
0 votes
1 answer
666 views

How to suppress Excel Services query warning in Sharepoint online?

I am using Excel Services to display items from an Excel workbook that has a query connection for its data. Each time I load the Sharepoint page, the Excel Services web parts ask if I want to run the ...
0 votes
1 answer
71 views

How do I create a search query by column name in Manage Result Sources?

I have a document library. And I wrote a query in the search that brought only the documents in this list. But in addition, I want a column-bound search in this list. **There is a document library as ...
0 votes
1 answer
164 views

SharePoint Online Highlighted Content Query Text Grouping

Using the SharePoint Online Highlighted Content web part, is there a way to group the files using the query text and KQL?
0 votes
0 answers
1k views

Unable to select nested array in JSON object with Microsoft Graph

Given the following Graph call response of https://graph.microsoft.com/beta/sites/root:/sites/[siteTitle]:/lists/[listId]/Columns, how can I only return/select down to the array "choices" ...
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 ...
1 vote
1 answer
255 views

args is undefined on executeQueryAsync query failed

I'm trying to make a JavaScript query on SharePoint 2010 via the following code. On query success I got no problem, but if query fails I get "args is undefined". All examples I see works same way I ...
0 votes
1 answer
566 views

CAML Query and statement not working

I've been working on this query for a while now and I can't get it to return any rows. It was working before I added in the content between and added the and statement. camlQuery.set_viewXml("<...
1 vote
0 answers
341 views

Infopath form load rule set value filter not working

This is driving me crazy. Super user here (not IT). I have an infopath form tied to populate a sharepoint list. On a field in my form, I have a drop down list. I want to populate that drop down ...

1
2 3 4 5
7