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

learn more… | top users | synonyms

0
votes
1answer
423 views

Connect multiple task lists into one master task list or view

I have lots of project sites each with their own task list. I want to create a master task list (or view or whatever?) on the parent site that can display all tasks in all of these project task lists. ...
0
votes
0answers
26 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
19 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 ...
1
vote
2answers
908 views

How to use SPServices search sql query - getting malformed query

I am using the SPServices javascript library to make a search request to sharepoint 2010 search. I am trying this query: queryText = "<QueryPacket xmlns='urn:Microsoft.Search.Query' ...
2
votes
1answer
98 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
14 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.
0
votes
1answer
551 views

Grabbing a filter value via CEWP code behind

I have employed a Query String Filter to parse a value and send it to a chart web part. now I would like to use this value in a CEWP to provide an explaination/clarification for the chart, but the ...
0
votes
2answers
990 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 ...
1
vote
1answer
16 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
27 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
18 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
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
2answers
60 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
1answer
551 views

Phonetic / Liguistic Search for People is Not Working in SP2013 Farm

Phonetic search is not working for us in a SharePoint Server 2013 farm. We are also seeing the following in the event logs (I the query text): 04/17/2014 11:40:15.89 ...
11
votes
7answers
25k views

How to query Sharepoint 2010 lists with sql?

I think it has to be a common task. We have some applications on sharepoint and we need to prepare reports with data from these applications. It would be great if we could use Reporting Services. We ...
0
votes
1answer
145 views

How to write queryXml to search out “88X211.doc” using keyword “211”?

I try to use following codes, but it does not work. Results is Status=ERROR_NO_RESULTS_FOUND Total count =null. If I use "88x211", I can get the right result. How to write queryXml to search out ...
0
votes
2answers
46 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
47 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
36 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
35 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 ...
1
vote
1answer
291 views

sharepoint 2010 - How to get document ID using spservices sql search query?

Using spservices to make search requests, I am building the query like this: var queryText; queryText = "<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'>"; queryText += ...
2
votes
1answer
561 views

Choice field not allowing save on choice field value changes

I have a SharePoint 2010 List with a simple Choice column called "RequestType" with values like New Hire, Job Change, Equipment Request, etc. I can add the new records and select any option, but ...
2
votes
1answer
62 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
823 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
1answer
26 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
44 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
33 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
72 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
76 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
2answers
236 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
42 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
289 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
29 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
111 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
0answers
16 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
41 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
9 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
73 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 ...
2
votes
0answers
35 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
2answers
34 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
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
20 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
1answer
25 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
41 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
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
30 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
1answer
15 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
0answers
31 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
1answer
35 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 ...