Skip to main content
5 votes

Filter Hyperlink field url using SharePoint REST API

This is the limitation of REST API Filter that it cannot filter the Hyperlink fields. So whats the workaround? You can use CAML with REST to achieve what you want. The CAML query will be like: <...
Aakash Maurya's user avatar
4 votes

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?

You can retrieve it from the DataProvider object. Which is accessible from within your display template. ctx.DataProvider.get_currentQueryState() This returns an object which gives you the whole ...
Elio Struyf's user avatar
  • 1,693
4 votes
Accepted

JS: If 'X' is mentioned anywhere in the LIST. Display

You should use <Contains> instead of <Eq> in your caml query: var query = "<Query><Where><Contains><FieldRef Name='Category' /><Value Type='Text'>" + value + ...
Damjan Tomic's user avatar
  • 3,656
3 votes
Accepted

Site Search results are the same no matter the query

Edit the Page that stores the search results Edit the "Search Results" web part Select "Change Query" In the Query text box, look for {searchboxquery} If you don't see that, the search box query will ...
obartholdson's user avatar
3 votes
Accepted

Importance of .Include in the query

I believe you already know how CSOM works in SharePoint though I am adding a little explanation. CSOM sends XML request to Client.svc and get JSON response. So when you write something like following,...
Atish Kumar Dipongkor's user avatar
3 votes

CAML Query not ordering, returns all items

The ViewXml you have does not conform to the XML schema it expects. It should have a <View> tag and a <Query> tag: $query.ViewXml = "<View><Query><OrderBy><FieldRef ...
Evariste's user avatar
  • 9,731
3 votes

Get a result of a predefined query by one click?

If you do that Search query from the search center then you can use the resulting url. It will look something like: [url for your search center]?k="search term"
Kasper Bo Larsen's user avatar
2 votes

Hide 'People named' section in search results

You will need to modify the query rule. By default it includes the "People Name in Sharepoint Search". You will have to inactive the People Name in sharepoint Search. Go to Site Collection -> query ...
Zeeshan Ahmed's user avatar
2 votes
Accepted

Managed Property not recognizing in QueryText

As mentioned by Mathew the managed property you are referencing should be text only. You need to have refinable, sortable managed property to use in your query. There are multiple refinable properties ...
Rajesh Sitaraman's user avatar
2 votes

Managed Property not recognizing in QueryText

Automatically generated Managed Properties are always Text regardless of the base property type. If you want Date type you have to create it yourself either in the SSA or in the site/site collection.
Matthew McDermott's user avatar
2 votes
Accepted

KQL - How to Create Query That Filters by Dates Within the Past Week (7 Days)

Try query.QueryText = "(AssignedTo:'" + name + "' ContentType:'Task' StatusOWSCHCS:'Completed' LastModifiedTime>='" + $(Get-Date).AddDays(-7) + "'"
Eric Faulkner's user avatar
2 votes
Accepted

Query components and active web front end servers in load balancer

As far Search load balancing, SharePoint control it and Most Probably Round Robin.It really does not matter on which server you configured the query component, you can configure it on WFE or on a ...
Waqas Sarwar MVP's user avatar
  • 56.9k
2 votes
Accepted

How to check if SharePoint Content database is in unsupported mode?

You can read all data in SharePoint databases and still be in supported mode. It's when you change a value or delete a row that the databases will be in unsupported mode. Even if you try to hide the ...
Benny Skogberg's user avatar
  • 25.5k
2 votes
Accepted

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

I find this from one of the questions: When a user insert a search query in the search box, this 'search word' is automatically added to the URL (for example: "results.aspx?k=word") When the user ...
Waqas Sarwar MVP's user avatar
  • 56.9k
2 votes
Accepted

SharePoint CAML query returns nothing

List and Item columns in the Workflow History list has types Single Line of Text and Integer respectively. Please verify. So Query will be: <View> <Query> <Where> ...
Ronak Patel's user avatar
  • 3,251
2 votes
Accepted

Displaying an image from a SharePoint list using Javascript building strings

ID's should be unique,, use class if you want to use the same properties on multiple elements. In HTML Change <div id="deviceimage"> to <div class="deviceimage"> In JS Change ...
Marko Tica's user avatar
  • 2,537
2 votes

Sharepoint 2013 Check if path folder exists

You can look into REST API to check if folder exists. You can call below REST API. http://<SITE NAME>/_api/Web/GetFolderByServerRelativeUrl('<TARGET FOLDER>')/Folders?$filter=Name eq '<...
Naveen's user avatar
  • 1,912
2 votes
Accepted

Search for synonyms without a thesaurus file

It is sad that your administrators do not see the business value of a well crafted thesaurus. In the past I have created a very simple Thesaurus solution driven by a SharePoint list that updates the ...
Matthew McDermott's user avatar
2 votes

Filtering Calendar Items Using REST API

Use SharePoint Manager to verify the value for the EventDate ("Start Time") field and check its Filterable property is set to false, and this is what is causing the error message to be returned. ...
Deepmala's user avatar
  • 1,857
2 votes
Accepted

Query on a table with lookup columns doesn't work

I want to create a query that updates a field in all items in listA from 'empty' to '1'. The field is not a lookup. Instead of converting current column field values, you could create a new ...
moe's user avatar
  • 5,267
2 votes
Accepted

Pnp : create a search query

If I understand correctly, You want to retrieve all items from the "M_Didacticiel" list(s) that can exist in any sites/site collections. I would use a custom content type as default for that list and ...
YogaPanda's user avatar
  • 859
2 votes
Accepted

Content Search Webpart missing "new" Items from List Query

Since it is a search web part a search crawl has to run before they will show up in the web part. The list view web part is not dependent on search, this is why they show up in the list view web part ...
Josh McClanahan's user avatar
2 votes
Accepted

SP2019 search is not working

Search service is ok if you see all Green. Its windows firewall issue. Windows Server 2019 blocks TCP port 808 even though you see SharePoint Search rule. Create a new inbound rule for TCP port 808 ...
San Juo's user avatar
  • 31
1 vote

Query Sharepoint databases in production

Unsupported by MS. From MSDN: https://msdn.microsoft.com/en-us/library/office/bb861829(v=office.12).aspx Direct modification of the SharePoint database or its data is not recommended because it ...
Juan Pablo Pussacq Laborde's user avatar
1 vote

Configure Search for a specific Column

Before you can filter on this column, you must create managed property mapped to crawled property in search schema, set it as Queryable and reindex content. More info
Paweł Hawrylak's user avatar
1 vote
Accepted

Difference between Creating a new Result Source and configuring Search Result webpart Query

A simple explanation would be around reusability. You can use the same filters in a Result Source and a query rule in a SRWP. The benefit of a Result Source is that it can A) be set as the '...
Greg W's user avatar
  • 713
1 vote
Accepted

Search query builder

BegindatumOWSDATE is text type managed property. You can't compare date with text type. You need to map that crawled property to managed property with DATE type. Only RefinableDate is date type (...
Marko Tica's user avatar
  • 2,537
1 vote
Accepted

Most efficient way of querying sites by a parameter in their url

If you need to check if the site / subsite URL contains a specific value , I wrote this code in my side that working properly : using (SPSite site = new SPSite("http://Qassasrootsite/")) ...
Mohamed El-Qassas MVP's user avatar
1 vote
Accepted

Using WS to query GetListItems with a greater than date and time query

Try to set the date time value with this format yyyy-MM-ddTHH:mm:ssZwith IncludeTimeValue='True' attribute , so it should like <Geq><FieldRef Name='Created' /><Value Type="DateTime" ...
Mohamed El-Qassas MVP's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible