Tagged Questions

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

learn more… | top users | synonyms

1
vote
1answer
43 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
22 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
17 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
42 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
9 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
82 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
0answers
20 views

SharePoint External User cannot view Query

SharePoint 2013, online, 500 license version. So. We have an external user who has edit and contribute access to one specific site. He can get into the site, see everything. There are a number of ...
0
votes
1answer
22 views

Search query from search box looking for contenttypeids

{SearchBoxQuery: ContentType:0x010100C568DB52D9D0A14D9B2FDCC96666E9F2007948130EC3DB064584E219954237AF39007B3838B9BC334FD5A775B8EBEE407D1F0050EECE79DC1D06469A2CB43CE1682F42* } I am trying to create a ...
0
votes
1answer
30 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
38 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
63 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
18 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
436 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
47 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
83 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
37 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
24 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
81 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
53 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
28 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
50 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
339 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
28 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
124 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
55 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
157 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
128 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
65 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
49 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
23 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
32 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
27 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
242 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
28 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
46 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
38 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
10 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
81 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
71 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
146 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
55 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 ...
0
votes
1answer
263 views

Query Rules in SharePoint 2013 (regex)

I have a pretty simple requirement to have a best bet (query rule) come up in a SharePoint 2013 search. If the phrase "BQS" is included in the search query, I want to display a recommended link. To ...
1
vote
2answers
103 views

Your query is malformed with a date in where clause

I'm trying to query SharePoint using jQuery and SPServices. When I run the code below, I get the error Your query is malformed. Please rephrase your query. var searchq = ...
1
vote
1answer
74 views

Caml query after modified choices

I have a column with an internal name of: PublicY with 2 choices: Yes/No, the query works but if I change the choice name to Ja/Nej the code will not query the results, why? I have tried to change the ...
2
votes
2answers
222 views

Querying against a note field with the REST API 2013

I'm getting the error The field 'OtherInfo' of type 'Note' cannot be used in the query filter expression whenever I run a query like this: ...
2
votes
0answers
327 views

XsltListViewWebPart Custom Filtering on Query String with paging

We are working on a solution to use custom query and paging inside a XsltListViewWebPart. This work,s but the paging does not work: var doc = new XmlDocument(); ...
1
vote
2answers
416 views

How can I get the correct SPFieldUserValue to use SPSiteDataQuery to aggregate tasks for a certain user?

I'm trying to gather all the tasks of a certain content type for a certain user. To accomplish this I'm using a SPSiteDataQuery which looks like this: string where = String.Format(@"<Where> ...
1
vote
0answers
53 views

MySites URL - use another query paramater other than accountname? GUID? | SP 2013

Is it possible to use a different query parameter other than accountname for Mysites? For example, can we use the GUID to link a person to the person.aspx page? The problem is that because the ...