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

learn more… | top users | synonyms

0
votes
2answers
122 views

Query with current date and time

I've built the following query to retrieve articles in Sharepoint: (-PublishingExpirationDate<yesterday OR EmptyEndDate:0) (PublishingStartDate<2015-09-29 OR EmptyStartDate:0) I read the ...
1
vote
1answer
144 views

Create a timer job definition that queries a list and sends a reminder email daily

I am working in SharePoint 2013 and have a requirement to create a timer job that will keep sending notifications to users in a recursive manner. I have referred this article which describes the ...
-4
votes
3answers
59 views

Query on All Items view in SharePoint 2013 [closed]

I need to query on AllItems view for getting items. How can I do this? CAML maybee?
0
votes
1answer
66 views

CAML Query and statement not working

I've been working on this query for a while now and I can't get it to return any rows. It was working before I added in the content between and added the and statement. camlQuery.set_viewXml("<...
0
votes
0answers
41 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 ...
1
vote
0answers
45 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 ...
0
votes
0answers
7 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
1answer
142 views

Get List Items that contains spaces

I am creating a SharePoint 2013 hosted app and I have come across a problem. I am able to submit everything to my list including a text box that say for instance may contain "this is a test". However ...
0
votes
0answers
39 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 ...
1
vote
2answers
569 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
118 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
25 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
22 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
126 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
21 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
52 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
80 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
86 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
168 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 header').find('#...
1
vote
0answers
42 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
1answer
22 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
70 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
47 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
630 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
1answer
66 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
107 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
318 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
228 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
365 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
1answer
411 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 http://technet.microsoft.com/en-us/library/jj683123(v=office....
0
votes
1answer
260 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 ...
1
vote
2answers
1k 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 Doe'&$expand=Author/Title&$select=...
0
votes
2answers
262 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
138 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
78 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
131 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
411 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
76 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
211 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
1answer
102 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
955 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 ...
1
vote
2answers
762 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
1k 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
1answer
123 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 ...
2
votes
0answers
72 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
212 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
2answers
361 views

Remove one page from Search Results

We have a subsite with its own search result source (scope) "This site." The scope is only available on the site. So people who use it will be on the site. For many searches the site home page comes ...
0
votes
1answer
68 views

Which way is best when getting files off couple of document libraries

Scenairo Two document libraries (no folders just default settings only uploading files), Fruit Crate Document Library Fruit Document Library Now I have a string with names of files.... ...
0
votes
1answer
189 views

Result source query difference between SPSiteUrl and Site

Working with with result sources and sometimes I see the query like this: {searchTerms?} (contentclass:sts_listitem OR IsDocument:True) **SPSiteUrl**:https://example {?owstaxidLSTopic:{Tag}} And ...
0
votes
1answer
23 views

Linked List too large to manage

I have a list linked to a Microsoft Access Table it exceeds the 10,000 line limit. How can i create views if it exceeds the limit?