Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [query]

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

3
votes
0answers
583 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 ...
2
votes
0answers
965 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 ...
2
votes
0answers
1k 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....
2
votes
0answers
28 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 ...
2
votes
0answers
159 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 ...
2
votes
0answers
34 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 "...
2
votes
0answers
67 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 ...
2
votes
0answers
120 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?" ...
2
votes
0answers
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)...
2
votes
0answers
753 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 ...
2
votes
0answers
81 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. ...
1
vote
0answers
41 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 ...
1
vote
0answers
266 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 ...
1
vote
0answers
173 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 ...
1
vote
0answers
211 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 ...
1
vote
0answers
45 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 ...
1
vote
0answers
25 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 ...
1
vote
0answers
111 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 ...
1
vote
0answers
62 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 ...
1
vote
0answers
106 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 ...
1
vote
0answers
39 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 ...
1
vote
0answers
81 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 ...
1
vote
0answers
11 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 ...
1
vote
0answers
59 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 ...
1
vote
0answers
25 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 ...
1
vote
0answers
503 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 ...
1
vote
0answers
828 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 ...
1
vote
0answers
46 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?
1
vote
0answers
162 views

Sorry Something Went Wrong while building a query

I recently built a new SSA and performed a full crawl on all content sources, all search results appear to be fine, however when building a query, no matter what I put in or use I get the Error "Sorry,...
1
vote
0answers
45 views

“Sounds Like” or Metaphone search on Specific columns in a list

I need to build "Prevent similar Names" functionality into "Large" SharePoint Online list's "New Item" view. I have three columns in the list against which I need to check an entered value for a "...
1
vote
0answers
123 views

How to Debug FAST Search Query?

We have a SharePoint 2010 Farm with a SharePoint FAST Search Server. My problem is if you search in the list "Telefonbuch" for the user Manfred Willy through the query "Willy" the search shows two ...
1
vote
0answers
356 views

Result Source Query Builder Invalid Request

I cannot create a result source in MySites. Whenever I launch the Query Builder, I am greeted with the following message, even when the query box is blank. Sorry, something went wrong. ...
1
vote
0answers
100 views

Configure Result Sources to show only Sites and Webs with a specific text in the URL

Scenario: I'm using SPO. I need a Result source that returns only Sites and Webs that contain the the word "Program" in their title. So far, i've managed to get results by using {searchTerms} ...
1
vote
0answers
68 views

Search result preview returns title and url, is there a way to only show custom site columns in the result?

I've got a list with one item (site columns: title, license). Is there a way to retrieve only what's inside license based on the query text? (content search web part) I've tried to use {|License(from ...
1
vote
0answers
43 views

searching all documents in sharepoint

If I want to search all through my sharepoint site for all documents any place in the site. Would it just be Get-SPSite mysite | Select -ExpandProperty allwebs | Select -ExpandProperty Lists | ...
1
vote
0answers
137 views

MySites URL - use another query paramater other than accountname? GUID? | SP 2013

Is it possible to use a different query parameter other than accountname for Mysites? For example, can we use the GUID to link a person to the person.aspx page? The problem is that because the ...
1
vote
0answers
110 views

sorting with querymanager

i see a function orderBy but i don't understand how it works and if it's the correct solution. i'd like know the way to sort the results from querymanager or maybe do this in kql? and then are there ...
1
vote
0answers
80 views

DataView Webpart Folders

Is there a way to pass the root folder parameter to a page that the DataView webpart consumes? If I have a page, test.aspx with a DVWP on it, it will show all my documents and folders in a list. If I ...
1
vote
0answers
512 views

Multiple Column Lookup field from Access to Sharepoint

I have two fields called "Tool ID" and "Tool Name" in my main "Tools" table in Access. "Tool ID" is set as the primary key, in that it gives each tool a unique autogenerated number. When I ...
0
votes
0answers
30 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 ...
0
votes
0answers
13 views

Workflow Affects Modified Date?

I'm trying to develop a process to programmatically check the last modified date, calculate the retention period, and send an email with the URL to the site owners if the document is past the ...
0
votes
0answers
14 views

Performance on checking permissions for a large amount of items

I need to check user specifik permissions on a relatively large set of list items. I know about SPListItem.DoesUserHavePermissions, but then I have to fetch each individual list item to perform the ...
0
votes
0answers
8 views

Sharepoint Form Autopopulate

I have a Sharepoint List that looks like this: Quarter Year Client Field 1 2017 Client 1 1.5 4 2016 Client 1 1.4 3 2016 Client 1 1.3 2 2016 Client 1 1.45 1 2016 ...
0
votes
0answers
20 views

Search results page

I have a search results page that seems to be working the way that I need it to. The issue is that I cannot figure out how to remove or edit what I think is descriptive text about the item (test2). ...
0
votes
0answers
478 views

How to delete a non-responsive query component from search topology using PowerShell?

How to delete a stuck and not responding query component from a search topology in SharePoint 2010? This query component worked fine before but it is not responding because the web front end server ...
0
votes
0answers
239 views

SP2013: is content search web part query builder SORTING tab fake?

We are using SP2013 on-premise enterprise edition. On a site we use Content Search Web part to show the latest document and pages in entire farm. In the CSWP query builder, we can list all the ...
0
votes
0answers
654 views

SPO 2013 redirect using url parameter doesn't work

Using same solution proposed here: Confirmation Page / Custom List Url is included in a function that generates newpost.aspx in a pop up. It worked once but then stopped which is weird. function ...
0
votes
0answers
1k views

Caml LookupId and LookupValue

I need to get the LookupId value and the lookup text value by CAML. With this query I get the ID but I can not get the value text anymore. <RSSharePointList xmlns:xsi="http://www.w3.org/2001/...
0
votes
0answers
66 views

Filter WebCollection using a List of Urls

I have a List that holds the URLs of the Subsites I want to retrieve. I need to use that as a filter (optimize the query) so when I query the SharePoint it only returns the webs I want to work with. I'...
0
votes
0answers
34 views

Query all items which belong to same model based on article number

I want to create a query which retrieves all items which belong to same model, based on their article number. Every item have an article number which can be something like I-12V2 which is standard ...