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

learn more… | top users | synonyms

0
votes
0answers
8 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
15 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
17 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 ...
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 ...
3
votes
1answer
29 views

SP 2013 Search Results web part

I am trying to create an org chart based on a persons department. I am using the Search Results web part in SP 2013 Enterprise. When I build the query I select the "Local People Results (system). I ...
3
votes
2answers
36 views

Search Results WebPart: Result preview returns more results than actual

I am using the search results webpart to return a list of people in a particular department. I set up the query correctly for the webpart and when I do "Test Query", it returns 8 relevant results in ...
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 ...
1
vote
1answer
21 views

How to query list from custom created web part

I have built a custom visual web part in c# for SharePoint 2010. What I would like to do is be able to query a specific list in SharePoint and then process the results. I am a complete noob when it ...
0
votes
1answer
33 views

Sharepoint CAML query is returing 0 records

I am trying to retrieve the document from the sharepoint by setting the GUID and _UIVersionString has the criteria for the query. It is not retrieving the record from the library. This is my query : ...
0
votes
1answer
27 views

ClientContext query by Title?

I want to do something like the below. But I'm not sure how exactly to do it. I just want to return items with similar Title to be efficient. List pages = ...
1
vote
0answers
26 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 ...
0
votes
1answer
43 views

REST query works on one site but not another

I have an query "< my_url >/fr/_api/search/query?querytext=..." It works fine and returns what I want. However when I try "< my_url >/en/_api/search/query?querytext=..." This fails ...
2
votes
2answers
62 views

Query to a list doesn't work

I want to get the number of comments from the list "Comments" of a blog site. To do that, I have a query with this code: using (SPWeb oWebsite = oSiteCollection.OpenWeb(new Guid(WebId))) ...
0
votes
2answers
72 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
67 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
54 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
32 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. ...
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 ...
1
vote
0answers
34 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
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
1answer
71 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
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 ...
1
vote
2answers
277 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
66 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
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. ...
1
vote
0answers
64 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
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
1answer
37 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
44 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
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
1answer
67 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
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} ...
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
145 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
1answer
19 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
36 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
28 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
198 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
224 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
35 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
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
85 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
258 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
94 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
183 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?