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

learn more… | top users | synonyms

1
vote
1answer
37 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 ...
1
vote
1answer
85 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: ...
2
votes
0answers
39 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 Webpart called "What's new?" So ...
2
votes
0answers
499 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(); ...
2
votes
0answers
398 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
521 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
68 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
18 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
15 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
36 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
33 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
93 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
74 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
60 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
257 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
35 views

SharePoint Query Builder unknown error

On a SharePoint 2013 on-premises, we tried to install the August 2015 CU. However, the installation failed and since then, all Content Search web parts show an error if I try to change the query. The ...
0
votes
0answers
11 views

Content search web part - what to use for most read posts?

I have seen different posts about how to sort by 'most read' in a content search web part and I am confused. I managed to get some sort of result but I am not sure it is correct since the blog list ...
0
votes
0answers
12 views

Query 'linked data source' through code

I created a linked data source (which joins a couple of lists). How do I access/query on this linked data source through code from my custom webpart? I can't seem to find any resources on this online. ...
0
votes
0answers
11 views

Sharepoint 2013, how to run a query on published access database?

I currently have published an access database in Sharepoint Enterprise 2013. I have published an infopath form to enter data but I need to set up a query to locate a record to add additional data ...
0
votes
0answers
31 views

Task List View with Where Clause

I don't think what I am trying to do is massively hard, but I've been at it for a couple of days now and can't find an answer. Sorry if this has been answered before. Basically I have a ...
0
votes
0answers
24 views

Search by content exclusive OR

I am trying to construct a result source that can be used by a Content by Search Web Part in MySites. This is my current query: {searchTerms} ...
0
votes
0answers
65 views

How do you change a CSWP query template with pagination for anonymous users

I have the exact same issue with a post by Shosh Programmatically change Content by Search queryTemplate & Paging display template I have tried encapsulating the codes within the override Onload ...
0
votes
0answers
15 views

Sharepoint 2010 > QueryService MSSQLFT script > LIKE operator exception work with other operator.

I have SharePoint 2010 library. I have created many custom meta columns for this library. Have gone through all the steps required for crawling. To query using code i am using MSSQLFT script. The ...
0
votes
0answers
14 views

sharepoint 2010 - order by clause not ordering in QueryService MSSQLFT script

I very new to SharePoint. I have a SharePoint Library which as many meta columns. For the library all crawling related setttings have been done. The crawl based search works as expected. I have a ...
0
votes
0answers
53 views

Filter XML results from REST API call to SP list data

I was curious if it was possible to use VBA to send a query inside a REST API call to a sharepoint (SP) site in order to extract data from the SP list? I've looked around and I can't find an exact ...
0
votes
0answers
31 views

Refine Search Results for Search Query

I am using SharePoint rest search API. I am asking it to return me a specific set of results. It currently searches against a field called myfield. myfield is a multiple choice field. I am ...
0
votes
0answers
49 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
9 views

return the most recents items of several lists with code

I would like to query more lists at the same time and return the most recent items. With sql, I could do this with a union and order by. Can I do this by code (c#) in Sharepoint?
0
votes
0answers
44 views

InfoPath - SQL as Secondary Datasource - Limit Results

I have limited InfoPath experience, mostly using as SQL table UI. I am now trying to create a SharePoint form that will capture data from a SQL table. In dev environment I have been able to add the ...
0
votes
0answers
87 views

keyword query syntax today less than a text date

I have a managed property that is of type text but is a date but when I do date>{today-3} it throws a syntax error. is there anyway I can get this working so I can do a query with todays date
0
votes
0answers
31 views

Search query don't show a content type if less than todays date

I have many content types, and in search they all get found. however I have a certain content type called payout that I want to hide if the created date(created) is less than todays date. I have tried ...
0
votes
0answers
136 views

CAML Query - Data Between Two Date Sets

I'm trying to get the data between two date sets, but the CAML query doesn't seem to be working. I'm trying to get anything opened between the two dates or anything closed between the two dates. ...
0
votes
0answers
40 views

Display a Filtered List from a Visual Studio SharePoint App on button click

I have an app I created that users entered their information in (created with Visual Studio c#) After the users fills out the required data it's stored in a SharePoint List. The List is hidden froom ...
0
votes
0answers
17 views

Search results web part: Querying using Workflow results column

Is it possible to use the property filter on a workflow results column (approval process)? Essentially, imagine we have the search results web part which is searching through a content type. It will ...
0
votes
0answers
11 views

Restrict Results on two tags

How do I create a query that restricts results based on two separate tags? By using either the result source or some other way that does not include coding.
0
votes
0answers
86 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
6 views

Is it possible to show more than 6 Tags in the Refinement Section of 2013 Search Query Builder

Is it possible to show more than 6 tags in the refinement section of 2013 Search Query Builder? We have the problem that we can't find all the tags we need.
0
votes
0answers
24 views

Web Part Query String not showing on a standard Site Page (SharePoint 2010) in edit mode

I am trying to add a standard Query String filter to a SharePoint Site Page but the web part is not showing in edit mode, the code for the web part is present within the page when you edit it in HTML? ...
0
votes
0answers
34 views

Including tag from discussion and newsfeed

How can I retrieve posts containing a specific tag from Discussions and Newsfeed? I have a page in which I can filter posts based on specific tagID. Here's the query I'm using: ...
0
votes
0answers
32 views

SharePoint 2013 external content type query

How can I see the SQL query made by an external content type? From Central Admin in the BCS service application I can see the list of all the external content types but not the query.
0
votes
0answers
19 views

Scoping search to just a particular site or list using search service

This is the XML I'm sending right now: <QueryPacket xmlns="urn:Microsoft.Search.Query" Revision="1"> <Query domain="QDomain"> <Context> <QueryText ...
0
votes
0answers
172 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 ...
0
votes
0answers
72 views

How to build search query to get full results with optional querystring

I'm using a content search web part and am trying to figure out a way to use {QueryString.MyParameter1} with three parameters, but one of them being optional and having the search still work. ...
0
votes
0answers
20 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. ...
0
votes
0answers
38 views

Creating a report on the same page as a list

I currently have a list where users are assigned based on a ratio. For example, User1 is assigned 3 times as many files as User2, so the ratio would be 3/1. I have added my list as a Web Part to a ...
0
votes
0answers
15 views

refreshing a query in Excel from a list of Sharepoint

When I have added more records to a list on SharePoint and I run "refresh query" in Excel, I don't see the added records in Excel. Looking at the table the range of it can not be extended, for the ...
0
votes
0answers
16 views

All shared queries - Power BI

I know it's possible to check the statistics of your own queries on the personal Power BI page. In case of a data steward isn't there a possibility to check all the shared queries without having to ...
0
votes
0answers
304 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
0answers
33 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 ...
0
votes
0answers
99 views

Content Query migration

I'm doing a migration from 2007 to 2010 and one of the issues I've run up against is the Content Query Web part seems to come pre populated in my 07 install, and this behaviour overwrites my nice ...