Skip to main content

Questions tagged [query]

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

Filter by
Sorted by
Tagged with
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"],...
caneta's user avatar
  • 103
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. ...
Jedi's user avatar
  • 23
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&...
klewis's user avatar
  • 1,353
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 ...
mojoriesen's user avatar
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 ...
mojoriesen's user avatar
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 ...
Sigmundur's user avatar
  • 115
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 ...
Leigh's user avatar
  • 1
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 ...
Newb's user avatar
  • 51
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</...
Des's user avatar
  • 1
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 ...
k1dfr0std's user avatar
  • 129
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 ...
Andrei Nechita's user avatar
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; ...
John John's user avatar
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 ...
hellothere's user avatar
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 ...
private7's user avatar
  • 125
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 ...
TiMe's user avatar
  • 1
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 ...
CleverlyDone's user avatar
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 ...
Sylvie's user avatar
  • 185
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 ...
busymonster's user avatar
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 ...
Dewey's user avatar
  • 11
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 ...
Lewkir's user avatar
  • 103
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 ...
nuloPez's user avatar
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?
Harris's user avatar
  • 595
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 ...
Harris's user avatar
  • 595
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>&...
Lance Bitner's user avatar
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 ...
kyle's user avatar
  • 1
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 ...
f_gulay's user avatar
  • 651
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?
Mark's user avatar
  • 1
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" ...
colonel_claypoo's user avatar
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: ...
San Juo's user avatar
  • 31
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 ...
Albert Balasch's user avatar
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
Abdul Karim Dorman's user avatar
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 ...
Midwestsusan's user avatar
0 votes
2 answers
392 views

Query Text KQL not able to filter Expires of Announcements

I am trying to make an Highlighted content with Custom Query. The content type is Announcement and the filter should be when the Expires field is empty or has a date >=Today. I struggle with the ...
susan's user avatar
  • 2,678
0 votes
1 answer
1k views

Calculated column which checks to see if a value in that row is in another list

I'm trying to figure out the sharepoint equivalent to the following SQL statement: UPDATE List1, List2 SET List1.Field2 = List2.Field2 WHERE List1.Field1 = List2.Field1; Or the Excel version: =...
Kyle Quigley's user avatar
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 `...
Jos Vissen's user avatar
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 + "'&...
ElBiasto's user avatar
1 vote
1 answer
75 views

multiple libraries, is it possible to retreive in CSWP or similar the files checked out?

In a multiple libraries scenario (400+ in the same site) of files with a content type, I would like to retrieve the elements that are checked out to someone (not a specific person). I am trying to ...
susan's user avatar
  • 2,678
0 votes
1 answer
107 views

Why does the query to the Sharepoint API search on the internet explorer not work?

I am using the api search to make a query and get the value of a refinablestring. A basic example of the query I am doing is the following. https://mysite.sharepoint.com/_api/search/query?querytext='...
Manuel's user avatar
  • 13
0 votes
0 answers
206 views

SharePoint threshold limit Not working for indexed Columns

I am Facing A issue with SharePoint Rest Query Requestype Column is indexed , single Line of text , Has Three types of only (Values and Count) Credit- 3787 One Off - 13019 Reccuring - 6202 I am ...
prajwal rao's user avatar
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 ...
AlanShearer's user avatar
0 votes
1 answer
636 views

Enterprise Search Query Rules not affecting results

I am trying to have certain documents be listed first in search results for my company's SharePoint site (not Online). To do this, I am creating a new query rule, removing search conditions, and "...
st_9's user avatar
  • 3
2 votes
1 answer
73 views

Q: Avoid SharePoint 2016 search to match URL

Is there any way to not match users' keywords to pages' URL? If users try to search using domain name, the whole site will be returned in result. Example: (Content of http://abc-sharepoint/text.txt)...
HardcoreGamer's user avatar
1 vote
1 answer
75 views

REST API to Upload a File inside a Folder (if folder not available create the folder)

I want to Upload a file inside a folder using the REST API. Also if the Folder which I have passed is not there then we need to create the folder and then upload the file. Is this really achievable? ...
Badri Prasad's user avatar
0 votes
1 answer
40 views

SharePoint - Change List View Threshold Dynamically CodeBehind

My current SP List View exceeds the threshold limit set in SP Central Admin: Changing the limit from SPCA is not an option for me as it impacts the performance of other sites. Question: How can I ...
gymcode's user avatar
  • 51
0 votes
1 answer
104 views

Content Search Webpart missing "new" Items from List Query

I've created a Content Search WebPart on my SharePoint 2016 site page, and it's missing items from the list which have the "new" tag on them, meaning they were newly created. The following is what my ...
veggiedude's user avatar
0 votes
1 answer
100 views

Please tell, can we filter data on SharePoint Hyperlink Description but not URL using sharepoint query [closed]

Please tell is there any way or workaround we can filter on hyperlink "Description" using sharepoint query. I know we can filter listview rendering using JSlink and hide rows but problem is when user ...
Asif's user avatar
  • 15
1 vote
1 answer
59 views

Why is Last Modified and Modified having different data?

I am trying to retrieve data using the JSOM model, and trying to figure out the last modified date of a SharePoint List Item, Its really strange when I am trying to retrieve the Last Modfied Date ...
Murtuza Husain's user avatar
0 votes
0 answers
75 views

Query from a script editor

I need to use a script editor to display list data. The content query web part will display the data the exact way I need to have it display but I need to use a script editor web part on my site - is ...
Anngela's user avatar
  • 23
0 votes
1 answer
316 views

Display Query String filter in page

I have query string filter like: Lists/DIIS/Master%20List.aspx?Modality=CT. I would like to display Modality=CT somewhere on the page (not the title since I hide the title). Is there a way to use ...
marco's user avatar
  • 47
0 votes
1 answer
21 views

Get a result of a predefined query by one click?

In my SharePoint site, I see a search box at the top of navigation bar left side of the page. I want to avoid manually typing frequently-used query strings (e.g. filename:meeting). Instead, I want to ...
iai's user avatar
  • 1

1
2 3 4 5
7