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

learn more… | top users | synonyms

1
vote
1answer
3k views

CAML Query, get item by lookup value, not by ID

I have the value of a lookup column, but I don't have the ID, I want to query items from SharePoint list using the lookup value. How do I achieve that in CAML?
0
votes
1answer
19 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, ...
1
vote
2answers
955 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' ...
0
votes
0answers
24 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
21 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
12 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
23 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
22 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
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
0answers
11 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
15 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 ...
1
vote
2answers
24 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
12 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 ...
0
votes
0answers
22 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
2answers
1k 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 ...
0
votes
1answer
20 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
1answer
566 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 ...
0
votes
1answer
465 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
30 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
36 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
119 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
21 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
566 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 ...
1
vote
1answer
23 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
37 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
26 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
79 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 ...
11
votes
7answers
26k 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
148 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
58 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
52 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
40 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
43 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
305 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
568 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
114 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
996 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
29 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
50 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
38 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
78 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
99 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
283 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
50 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
350 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
36 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
139 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
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 ...