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

learn more… | top users | synonyms

2
votes
1answer
20 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 ...
2
votes
0answers
17 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
53 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
641 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
462 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
573 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
74 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
27 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
37 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
68 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
32 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
42 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
34 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
106 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
83 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
66 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
287 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
13 views

Retrieving SPList in SSIS with oData shows Created By as a number

I'm trying to retrieve information from a SharePoint Online list using SSIS following this guide: ...
0
votes
0answers
12 views

The type specified in the TypeName property of ObjectDataSource could not be found

I'm trying to use SPGridView with ObjectDatasource to display search results and I get the message in the title. I read several forums and that lead me to conclude that the correct TypeName is : ...
0
votes
0answers
3 views

Access 2007 Parameter query to SharePoint List

Still new to SharePoint 2013. I moved a 2007 Access database to SharePoint 2013 without any issues. But I added a query to the Access database, after the fact, and attempted to link it to the same ...
0
votes
0answers
17 views

CAML Query to Return Blog Posts from any Blog Sites in SIte Collection

I have a web part that searches a site collection for any blog posts (across various blog sites within collection), and returns the posts. Below is the code I am wanting to port from javascript to ...
0
votes
0answers
18 views

REST Web Service query using Listdata.svc

I have a Library that contains Agent Call Monitors. This Library has columns that hold Agent Name, Scores, Created, Created By, etc. I have created a form to query the data in that Library. For ...
0
votes
0answers
21 views

Append query suggestion to Search Box from a third party Source in sharepoint

Is there a way to add additional items to the default query suggestions provided in the search box as a user types. I need to fetch suggestion items from a query template endpoint and add the returned ...
0
votes
0answers
6 views

Search Result Web Part Setup for Pages Linked to Current Page or Related by Content

I'm creating a procedural Wiki in SharePoint Foundation 2013. I'd like to set up a search result web part within each of my pages that returns other pages that either (a) link to the current page or ...
0
votes
0answers
25 views

Two choice fields to select a unique list submission then edit the result

Goal: I am trying to filter against two choice parameters in order to find the unique ID of the item shared between the two. I would then open that unique item entry, edit it, and overwrite it back to ...
0
votes
0answers
22 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
14 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
15 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
64 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
34 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
146 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
25 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
29 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
227 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
46 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
86 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
10 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
80 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
178 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
36 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
300 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
62 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
22 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
16 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
138 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
486 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
31 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
409 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
100 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 ...