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

learn more… | top users | synonyms

0
votes
0answers
19 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
111 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
19 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
45 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
64 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
76 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
133 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
38 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
37 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
171 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
33 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
21 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
54 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
41 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
477 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
307 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
58 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
67 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
97 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
293 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
182 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
310 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
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
1answer
294 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
188 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 ...
0
votes
2answers
216 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
124 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
71 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
111 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
374 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
71 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
175 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
98 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
867 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
642 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
108 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
64 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
187 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
253 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
63 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
147 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
22 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?
0
votes
1answer
41 views

Show Live Document Library by QueryString

I am trying to build a page in which I can then add a Query String to pull the specific document library, showing all of the folder and files in it. Then from there I am going to create a webpart ...
0
votes
0answers
622 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 ...
1
vote
1answer
68 views

Rest API filter quote

I am using the SharePoint rest API, I need to quote a string in the filter query. This is my query: ?$filter=MyField eq 'aaa'aaa' How can I search the string " aaa'aaa "? Thanks
1
vote
2answers
4k views

Sort content search web part in alpha order by title

I have a content search web part that is displaying a bunch of things from a cross-site publishing catalog. That is working just fine. But I would like to sort the items in alpha order. I would have ...
0
votes
0answers
37 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. ...
1
vote
4answers
3k views

How to get the ID of a list item with a given GUID in Sharepoint online with REST api?

I tried a request at a url of the following form .../_api/web/Lists/getByTitle('docLib')/items?$select=id,GUID&$top=1&$filter=GUID eq '2779cf8051-381f-4834-93dc-ece6345dde33' and i get ...