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

learn more… | top users | synonyms

0
votes
0answers
34 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
1answer
20 views

Use SPSiteDataQuery to get all site collection lists having same column name

I have one site collection that is RootSite. Two sub sites that are subSite1 and subSite2. subSite1 has list EMP_info with columns Title and Dept. subSite2 has list DEPT_info with columns Title ...
0
votes
0answers
10 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. ...
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. ...
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
1answer
30 views

Percentage of Total Amounts Based on Criteria

So here's my situation. I have a list used to track bids for a construction company. Each item represents a bid this company has submitted and includes the dollar amount, square yardage and status ...
0
votes
1answer
30 views

Content search web part, query search, is it possible to perform this filter

I have one CSWP that displays article pages from a single site. The article pages have 2 different tags (a & b). I would like the tags a to always be displayed, no matter how much time passes, ...
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
1answer
23 views

How to write the CAMLquery for column name:ID

Column name: CauseID:Code The type of information in this column is: Lookup function searchFunction() { var strDamcode = $('#searchDamage').val().trim(); if ($('#wrap ...
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} ...
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
64 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
14 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
1answer
16 views

Specify <DIV> when querying people “About Me”

I'm working on a "people directory" using a search query on the active directory. As it stands now I'm just using our group name, which is part of a large company. This get's all of the employee's in ...
0
votes
1answer
19 views

Query multiple lists in different sites and display them like a OOTB list

I have different subsites which contain lists called "Articles". On the root site I need to query these lists ("Articles") and display all them in a OOTB "list like" fashion. What is the best way to ...
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 ...
1
vote
2answers
34 views

Querytext: blank value for a property

How could I specify in a Querytext that I want all the elements that doesn't have defined a value for a property? For example, let's say that I'm interested in the property CheckoutUserOWSUSER, how ...
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
1answer
22 views

SP 2013 - Search Schema - People Result Query

I added a field to "Manage User Properties" in user profile. The field name is Exclusion and it's boolean to exclude certain users from people search. I have a powershell that uses some logic and ...
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 ...
2
votes
1answer
154 views

CAML query filtering is not working

I've googled that it can be in case when query is not well-formed. But I'm verifying it for several hours and didn't find any mistake. Problem is common: query doesn't filters and returns all data. ...
0
votes
1answer
24 views

Query the ContentTypeId field using SharePoint REST API

I would like to know if it is possible to query a SharePoint list using the ContentTypeId field using REST API. Can someone please help me on that? Thanks.
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 ...
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
1answer
43 views

{searchTerms} Path:{Site.URL} not returning any results

I have the same unanswered issue as in : Using a Search Result Source to limit to current site According to Microsoft's documentation at ...
0
votes
1answer
37 views

Hide 'People named' section in search results

I'm building a custom search page for a document library, I've defined this query for it : {searchboxquery} (contentclass:STS_ListItem OR IsDocument:True) Path:https://pathtolobrary The search is ...
0
votes
2answers
121 views

REST query not working on list after 5k threshold

The following query works on one site: mysite/_api/lists/getbytitle('Listname')/items?$top=5001&$filter=IndexedCol1 le 'M' and Author/Title eq 'John ...
0
votes
2answers
75 views

SharePoint List Ping IP Address

We have setup a SharePoint page with a list of our office sites. At the moment we have a column called status so in the event of an infrastructure outage, we manually change the status from Connected ...
0
votes
2answers
56 views

Alternative to Lookup Column

I have a list with a lookup column displayed as a dropdown menu in the NewForm allowing the user to pick a contact person retrieved by lookup to the contacts list, however this list will soon grow ...
1
vote
2answers
45 views

Pull data from Salesforce Chatter into a SharePoint list?

We're looking to query data driven within Salesforce Chatter and pull relevant information into a SharePoint list. Does anyone know if this is possible and how to do it?
0
votes
2answers
46 views

Disable “image content” content type in CSWP

i'm on SP2013 Enterprise Edition and have a little problem to solve. What i want to achieve i would like to display all the new items through all my site collection except the images. So, for ...
2
votes
1answer
159 views

What are the user data returned from Person or Group column (People Only) query?

I'm using SPServices to query a SharePoint Online (2013) list that contains a Person or Group column. (This column is set to allow selection of People Only, in case that matters.) The query used is ...
0
votes
1answer
33 views

Prefix matching seach when prefix contains characters treated as whitespaces

It is my first post on this forum. I have the following case. In the search engine there is a property id and I have to search by it using the wildcards. The problem is that the id can contain the ...
0
votes
1answer
51 views

REST API get by author differences by platform

I find that when I want to retrieve custom list items by author (in this case, by the current user) I need to use a different query whether using SP2013 on premise or O365. I tried creating the same ...
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
86 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
134 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
1answer
57 views

AverageRating is null in JSOM

I am trying to get the rating field from a SharePoint pages library in JavaScript, after using the get_item('AverageRating') it's returning null. My function looks like the following: var ...
0
votes
1answer
419 views

How to consolidate JS for CAML queries with multiple filters?

I'm very new at the entire JS/SPServices concept (and JS as a whole) and I'm trying to slim down the amount of JS needed for a few HTML pages. I have several unordered lists on the HTML page that I ...
0
votes
0answers
39 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 ...
1
vote
2answers
181 views

How to get multiple lists on a page using context.executeQueryAsync?

Code that I can execute like this is my end fantasy: var listCollection1 = getList("listName1"); var listCollection2 = getList("listName2"); // at this line I now have both of those populated Where ...
0
votes
2answers
327 views

Search results webpart displaying items without search box query

I have ecoutered a strange behavior with search results web part. The scenario is, that we have blank page with some web parts on it. Part of the page is also search box web part and search result web ...
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
1answer
47 views

GetListItemChangesSinceToken Folder Query option

I would like to get the list of folders and list items one level at a time, instead of querying all items under a SharePoint list. I plowed through SharePoint documentations and Stackoverflow and ...
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.
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 ...
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 ...