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

learn more… | top users | synonyms

0
votes
0answers
8 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
13 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
10 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
11 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
13 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
12 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
21 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
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
36 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
19 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
83 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
30 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
11 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
137 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
77 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
231 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
26 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
24 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
89 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
403 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
37 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
47 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
137 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
1k 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
58 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
206 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
47 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
127 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
64 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
34 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
56 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
676 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
44 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
185 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
25 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
69 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
358 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
169 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
80 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
67 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
42 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
380 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 | ...