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

learn more… | top users | synonyms

0
votes
0answers
14 views

Scoping search to just a particular site or list using search service

This is the XML I'm sending right now: <QueryPacket xmlns="urn:Microsoft.Search.Query" Revision="1"> <Query domain="QDomain"> <Context> <QueryText ...
0
votes
0answers
27 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
17 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
0
votes
1answer
29 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
21 views

How to build search query to get full results with optional querystring

I'm using a content search web part and am trying to figure out a way to use {QueryString.MyParameter1} with three parameters, but one of them being optional and having the search still work. ...
0
votes
0answers
9 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. ...
0
votes
2answers
64 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
2answers
53 views

Using CAML Query to Retreive from Multiple Lists

I am creating an applicant tool which contains the following lists: Applicant; Applicant Answers; Job Questionnaire; Job Title The lists are related as follows: Applicant.ID = Applicant ...
1
vote
1answer
125 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
0answers
23 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 ...
1
vote
0answers
23 views

Search result preview returns title and url, is there a way to only show custom site columns in the result?

I've got a list with one item (site columns: title, license). Is there a way to retrieve only what's inside license based on the query text? (content search web part) I've tried to use {|License(from ...
0
votes
1answer
70 views

sharepoint search boolean managed property

I have a managed property isActive which happens to be a Boolean. I am creating a search query and I only want the ones that are active so isActive:true however I am having trouble with the correct ...
0
votes
0answers
11 views

refreshing a query in Excel from a list of Sharepoint

When I have added more records to a list on SharePoint and I run "refresh query" in Excel, I don't see the added records in Excel. Looking at the table the range of it can not be extended, for the ...
0
votes
0answers
14 views

All shared queries - Power BI

I know it's possible to check the statistics of your own queries on the personal Power BI page. In case of a data steward isn't there a possibility to check all the shared queries without having to ...
0
votes
2answers
274 views

List Query - How to get attachments link

I have a query: function consultaPropostas() { var customlist ; var clientContext = new SP.ClientContext.get_current(); var oWebsite = clientContext.get_web(); var oList = ...
0
votes
1answer
24 views

Search query from search box looking for contenttypeids

{SearchBoxQuery: ContentType:0x010100C568DB52D9D0A14D9B2FDCC96666E9F2007948130EC3DB064584E219954237AF39007B3838B9BC334FD5A775B8EBEE407D1F0050EECE79DC1D06469A2CB43CE1682F42* } I am trying to create a ...
0
votes
1answer
36 views

unable to add a search core result web part inside my enterprise wiki site collection

I have two site collections inside the same web application; siteA & siteB. now inside siteA i want to display the latest items from siteB. i read a lot about cross-site query , and it seems that ...
1
vote
1answer
45 views

phone number search query

I am writing a query for phone numbers in search so when you input any part of the number it is returned by the search. I tried using this : (MobilePhone:{subjectTerms} OR PhoneNumber: ...
0
votes
1answer
100 views

Add suggestions to search box, not happening

I configured my search box for using query suggestion in SharePoint 2010. Unfortunately after 6 search of a term and runing the job Prepare query suggestions and Logging query, it doesn't appear in ...
0
votes
1answer
19 views

Lists structure,usage and search in SharePoint

I have some requirements items that can have multiple tests and each test can have data sets and each data set may/ may not have defects. How do I structure this as a list and not think of it as a ...
0
votes
1answer
896 views

change display style for link column type in content query webpart

I have some questions about content query web part with sharepoint 2013 I use the content query to filter a list. This list has a column type link with some http links. when I display it with the ...
0
votes
1answer
57 views

SPQUERY returns null value

Hi im using sp query to retrieve the items and using projectproperty.Title to get the web name dynamically ,but I got empty value in this data table. q.ViewFields = "<FieldRef ...
0
votes
1answer
153 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. ...
1
vote
2answers
40 views

Get the field “Created”

I have a list "Consult", and I want get the field "Created" this is my code: function consultWorkOrder() { try { var customlist ; var clientContext = new ...
0
votes
0answers
43 views

Search Server is unavailable and could not be accessed While crawling .zip files

I Have Search Service Application running in one of the Application Server in my Farm. I am using Continuous Crawl to Crawl My Local SharePoint Site Content Source. Today I looked at ...
0
votes
0answers
118 views

Content Query Webpart - Dynamic display of Document library

I have to display files from a document library (DL) in a content query webpart depending upon the value from a list-value pair. This list-value will have the URL of the required DL. The document ...
1
vote
1answer
62 views

List consult in JavaScript, which is the best

I have a list and I want to consult another list with JavaScript.... I am using this code: ( ) function consultBP() { try { var customlist ; var clientContext = new ...
0
votes
1answer
31 views

Site Specific search query

I want to create a query for a search results that is the same as the default one, in that it only returns things in the particular section of the site it is in. Does anyone know what this query would ...
0
votes
2answers
52 views

Search by Folder name in different site collections

I'm trying to setup a search query to look @ one specific folder name across site collections. If I have the 3 site collections and similar "leader" folders of: ...
0
votes
1answer
569 views

How to use the Content Search Web Part to filter on a custom column property?

I am quite new to SharePoint 2013 and I have been working lately with the Content Search Web Part. However I haven't been able to make possible a filtering through a custom column that I have on a ...
0
votes
1answer
40 views

How to add CAML query results with ListItems to a datasource of a repeater?

I am using SP2010. I have created a CAML query. This query has listItems as results. I would like to add these items to my repeaters datasource. How can I implement this?
3
votes
3answers
165 views

Soap + Rest: Trying to understand differences for selecting fields between the two

I'm working on a Java-Application that integrates with SharePoint. The different SharePoint services are currently requested via the SOAP API. I am now working on an abstraction layer to also ...
0
votes
0answers
24 views

Filter ListView by Current User's City

I have a 2013 list view on a custom page. It is working with JSLink + all of the great OOB features. I have a city column in that list. How can I dynamically filter it based on the current user's city ...
1
vote
1answer
64 views

Security trimmed results for custom query on property

The sites in my site collection are using a custom property to determine what "type" of site they are. E.g. web.Properties["SiteCategory"] = "SomeCategory1"; I'm planning on creating a web part to ...
0
votes
2answers
265 views

How to know which site collections a user has access?

I have a web part that needs to identify the site collections the logged-in user has access to. Can Search help with this? Are there better options for me aside from: The web part looping through ...
0
votes
0answers
159 views

Query list in designer workflow

I have created a approval workflow using SharePoint Designer workflow. I want to query the task list to get the task with minimum due date for the current task approver. Below is the scenario : I ...
0
votes
0answers
74 views

Using function to query multiple lists

I am using the code below to check whether an item exist on one list. Seeking to improve this code so that I can check two lists. If it finds it on the first list (FILE_LIST_NAME), I want it to ...
0
votes
1answer
62 views

How to grab a value from cache and pass it to an SQL Stored Procedure

I am designing a website that queries an SQL database when opened, providing a list of bills for the given user. I am using a custom SQL query with a Data Source/Data View and in the Command & ...
0
votes
1answer
24 views

Outputting full name in query powershell

I am querying a sharepoint site. At the moment its returning Our future comm... how would I be able to make it print out the full name Here is my code Get-SPSite mysite | Select -ExpandProperty Lists ...
0
votes
0answers
38 views

search mutliple sites get-SPsite

I have a site mysite which also has other site collections which are not shown if you just do Get-SPSite is there anyway to search multiple site using Get-SPSite I know this doesn't work but for ...
0
votes
0answers
30 views

searching all documents with a content type

How can I search all documents with a particular content type of 'EC Docs' and then query a site column in that content type where column -eq 'Res' Get-SPSite mysite | select -ExpandProperty AllWebs ...
0
votes
1answer
321 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 ...
1
vote
0answers
30 views

searching all documents in sharepoint

If I want to search all through my sharepoint site for all documents any place in the site. Would it just be Get-SPSite mysite | Select -ExpandProperty allwebs | Select -ExpandProperty Lists | ...
0
votes
1answer
55 views

query xml powershell sharepoint

Get-SPSite mysite | Select -ExpandProperty AllWebs | Select -ExpandProperty Lists | Select -ExpandProperty Items | Out-File outputpm.txt I have this code, which produces the items, one of the items ...
0
votes
0answers
39 views

Finding items using content types

Get-SPSite http://skynet | Select -ExpandProperty AllWebs | Select -ExpandProperty Lists | Select -ExpandProperty Items | ForEach { ForEach($ct in $ContentTypes){ if($ct.PM -eq "Res" -or "Con"){$_}}} ...
0
votes
0answers
13 views

Where query with a metadata field applied to the base content type

I want to create a query for all document library tagged with the terms ‘r’ or ‘c’ under their pm metadata field? the pm field is a ‘choice’ term type, applied to the base content type, so all of our ...
0
votes
1answer
121 views

Rest queries in SP2010 with $top and $skip

I have been reading up on Rest queries for SP2010, but at the moment I dont have an enviroment to test on. would these two queries return items 10-19 of the Example list? var test1= siteUrl + ...
0
votes
2answers
73 views

How to know when async query's finished

When does an asynchronus function end in case I want to show the user a "saving" icon when the query's proceeding? I have something like this for my query: entry = ...
0
votes
1answer
158 views

Retrieve list item information using path

Using: SharePoint 2010, JavaScript, jQuery 1.10.2, SPServices In SharePoint 2010 I have a custom (JavaScript-based) page where users may type in text and link to items in SharePoint lists. A recent ...
0
votes
1answer
60 views

List.GetItems is running slow for certain sites

I'm running a pretty simple query to get back items using List.GetItems and it seems to be performing horribly on some of my sites (differing site collections). The lists being queried are essentially ...