Skip to main content

Questions tagged [query]

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

133 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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
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
2 votes
0 answers
1k views

Querying List Item Field Values with PowerShell Problem

I have googled this a lot and have found trouble finding an instance of someone having similar issues with a resolution. I am currently working on querying a medium sized list on a sharepoint farm so ...
ITGuy3381095's user avatar
2 votes
0 answers
34 views

Get result from two queries in single Content by search webpart

First of all I would like to say that my requirement is a bit different. Consider there is a list as below. Here I want to retrieve and show the items in content search webpart in the following ...
Unknown's user avatar
  • 309
2 votes
1 answer
83 views

Returning results from a SharePoint list using Javascript code

Going round in circles. I'm trying to return results from two columns on a SharePoint list pictured, which will return the results to a HTML page which is being created by a different JavaScript ...
Dazza's user avatar
  • 767
2 votes
0 answers
256 views

Create dynamic view of list item by clicking on tile

I have a "promoted links" list to display some tiles on a page. What I am trying to do now is to display a popup window or a seperate browser window when I click on that tile, based on the list ...
ddominnik's user avatar
2 votes
0 answers
44 views

Assigning the result of the query variable to another query variable in CSWP

I am using content search webpart. I have the query that fetches all the items from a list like (HRDepartmentOWSTEXT:"a*" OR HRDepartmentOWSTEXT:"b*" OR HRDepartmentOWSTEXT:"c*"...so on). Here "...
NivethaSri's user avatar
2 votes
0 answers
76 views

SharePoint 2010, filter Document Set in URL

I'm trying to filter a document set in SharePoint 2010. For example, the URL to the main document library is #1) http://uat/sites/dps/doc/Forms/folders.aspx I would access a document set like this ...
kidax's user avatar
  • 21
2 votes
1 answer
61 views

Querying Standard Rendering Elements in CAML

Folks I'm looking to use the "standard rendering element" <PageUrl/> within a CAML query as per below: <Or> <Eq> <FieldRef Name="Webpage" /> <Value Type="...
Kunal's user avatar
  • 121
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 ...
penfold1992's user avatar
2 votes
0 answers
133 views

How to make CQWP retrieve 4 most recent Items in the whole site collection?

I'm a little stuck with one of m Content Query Web Part: On my homepage, I would like to display the 4 most recent items added to my site collection in a Content Query Web part called "What's new?" ...
Gaelle's user avatar
  • 592
2 votes
0 answers
1k views

XsltListViewWebPart Custom Filtering on Query String with paging

We are working on a solution to use custom query and paging inside a XsltListViewWebPart. This work,s but the paging does not work: var doc = new XmlDocument(); doc.LoadXml(((XsltListViewWebPart)...
Maza's user avatar
  • 41
2 votes
0 answers
790 views

Sorting in Search.asmx querypacket

I have this querypacket to query Search.asmx service, and get back the results, stored in queryXML object, I can retrieve data successfully, but I can't figure out how to sort this data on any field I ...
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
2 votes
0 answers
89 views

What CMIS services are required if Fast Search is used to query an external CMIS repository

For a repository to be CMIS compliant, it must implement a number of services. Query services are not mandatory. I want to incorporate a CMIS repository in SharePoint 2010 as an External Content Type. ...
BrianB's user avatar
  • 21
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
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
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
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
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
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
1 vote
2 answers
308 views

Sharepoint 2010 Query List with SPD Workflow?

Working in Sharepoint 2010, I have to create a Sharepoint Designer Workflow to query all the items in a list. I want to query the list and sort the results from highest to lowest based on project ID. ...
bberndt's user avatar
  • 143
1 vote
0 answers
62 views

Multiple items in single query. How to separate them?

What I would like to do is exclude preferred names in a web query in single command. For example, now if I want to exclude some system accounts or user names that are named John and Edward and other I ...
Sławomir's user avatar
1 vote
1 answer
39 views

Creating a Query or SQL Statement from multiple lists30

I have built out the back end of my database with multiple related tables. What I'm trying to do now is build a view that pulls from those tables based on the relationships and a combo box filter. ...
Robert Sullivan's user avatar
1 vote
1 answer
541 views

URL OData query in SharePoint Online?

Any help needed to get me in the right direction would be greatly appreciated. I'm looking for a URL query I can enter to obtain all list items with a specific chosen field. Example: I have subsites ...
jaredjohn's user avatar
1 vote
0 answers
388 views

How to write a REST query to obtain all tasks within a Workflow Task list?

I'm trying to write a REST query to obtain all tasks associated with a given list item. The workflow task list is named 'Workflow Tasks'. Under the 'Related Content' column, one can see the title of ...
user1513177's user avatar
1 vote
0 answers
256 views

Searching ID's within a modern SharePoint 2013 list

I have a List with Project Info, it has 500+ items as if for now and it will double over the period of time. I would like an efficient way to search projects with ID (OOB SharePoint column). When I ...
SavantProdigy's user avatar
1 vote
1 answer
33 views

Search Results Query

I have search results that I have looking into a specific document library but I only want specific documents to show that are no older than a certain date. I do have a date field as one of the column ...
Flat Banana's user avatar
1 vote
0 answers
427 views

Checking if document library (list) exists takes too long

I need to check if specific document library exists on sharepoint site and I don't know the title of the library, because it is being created dynamically. The only thing I know is RootFolder.Name ...
Raman Sinclair's user avatar
1 vote
0 answers
54 views

Change hyperlink display form - content query

I am having a page called https://example.com/sites/nl/view_item.aspx?ID=10 for example, This displays the content in a nice visual way for that specific item. Next to that item I have made a list ...
Sander's user avatar
  • 143
1 vote
0 answers
33 views

SharePoint 2013 Query dynamic text and connect to filiter values

I have an embedded Visio Diagram that has different filter values for each shape. I have the filter values that are connected to List and Library's, and when a user selects a particular shape it will ...
Randy Jones's user avatar
1 vote
0 answers
174 views

Using KQL in Sharepoint online 2013

I'm using ContentTypeId:0x0108* Path:{Site.Url} AssignedTo:{User.Name}Status<>Completed to sort out all completed tasks. But it does not work. If I use only NOT or -Completed it works, but it ...
Alexander Säll's user avatar
1 vote
0 answers
358 views

Query Parameter disappearing from URL

I'm currently working on a document management system (SP 2010) and I have one last hurdle to get over before completion. I have an Upload Link which is a hyperlink that opens a document library ...
user63619's user avatar
1 vote
0 answers
123 views

Is it possible to show search results by regular expression?

Is it possible to show always search results on some page by regular expression? My target is to show documents/pages with a creditcard number in the content. In the regular expression I would like to ...
Ola's user avatar
  • 4,385
1 vote
0 answers
49 views

List query returns wrong links for items (AAM misconfiguration?)

I have a webpart that sends a query to a list and returns items as links. For some users, not all mind you, the link goes to a different hostname which appears to be set up with AAM. To make matters ...
user3463093's user avatar
1 vote
0 answers
89 views

Infopath Data Conections from code behind

I have a form in infopath 2013, I am getting data from a sharepoint list to perform some actions, but I need the data query of the data to be done when I press the button on my form. I have code in ...
Azaria Martinez's user avatar
1 vote
1 answer
358 views

Advanced Mode not displaying in Content Search Web Part "Change Query"

I am having an issue with SharePoint Online. I am trying to integrate CSWP into some pages within a SharePoint site. However, when I attempt to change the query to modify the results, the ability to ...
JoshUA's user avatar
  • 11
1 vote
1 answer
587 views

CAML Query multiple Lists with same fields

I have 4 different lists with different fields. Now I would like to retrieve items from all 4 of these lists ordered by user "Created By" ("Author") field using CAML. Also, all of the lists have a ...
Gintas K's user avatar
  • 1,237
1 vote
0 answers
18 views

Result Sources restriction when not logged in

I'd like to restrict some files when a user, who is not logged in, searches for files. Is that possible? I tried building a query in Result Sources -> "custom name" -> Query Transform, where I can ...
Rasmus Bækgaard's user avatar
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 ...
Tarek Salah uddin Mahmud's user avatar
1 vote
1 answer
149 views

Query to filter the pages with word typed in the search box in sharePoint Online

Below query is bringing all the results instead of filtered results for the pages in SharePoint Online: var queryUrl = "/_api/search/query?querytext='" + term + "'" + &trimduplicates=false&...
SandeshR's user avatar
  • 1,992
1 vote
0 answers
67 views

decoupling Search 👀 Query Builder from WebPart Properties and running it with JavaScript

I spent some time googling around .. no luck Goal Am building me own flavor of the Content Search WebPart, it performs REST Searches [✔], transforms the results [✔], and displays everything in an ...
Danny '365CSI' Engelman's user avatar
1 vote
2 answers
416 views

REST API Queries - Expand on Field but Not to Limit that Field Only

I'm trying to build a query to retrieve list items using the REST API. Is there a way to expand on certain fields, but still bring back every other field? This is for use within a SharePoint-hosted ...
LaLaLottie's user avatar
1 vote
0 answers
31 views

Lookup column that auto filters bases on site pages.

I'm building a form that surveys user's opinion of the page the page viewed by the user. I have a list with a lookup-column that gets the ID from site pages. I'm looking for the ID to be ...
speedydev's user avatar
1 vote
0 answers
570 views

SharePoint 2013 Search Results Display Template not showing all results

I have a search results display template for a video library. Each video has a category (DiscussionCategory), a Chapter (CustomDTListChapter) a section (CustomDTListSection) and the title itself. My ...
SpGurlz's user avatar
  • 123
1 vote
0 answers
3k views

what are the differences between "Not Contains" and "Not Equal" inside my query builder for a Managed metadata site column which allow multiple values

I want to refine the default search service result source. so i did the following steps; i went to "Central Administration" >> "Managed Service" >> "Search Service" , then i copy the default "local ...
John John's user avatar
1 vote
0 answers
72 views

Can SharePoint use an index for 'Begins with' queries?

Lets say I have a 'Begins with' CAML query for a column and I also created an index for this column. Can SharePoint use this index for the query?
pindumb's user avatar
  • 25