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

learn more… | top users | synonyms

1
vote
2answers
657 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
2answers
61 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 ...
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: ...
1
vote
1answer
83 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 ...
1
vote
1answer
206 views

Switching Search Results Sort Order if Keyword Term Exists

We have a Course Listing based on results surfaced by a Search Results Web Part that is configured to use a specific Results Source. The web part serves a dual purpose in that by default it should ...
1
vote
1answer
469 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 ...
1
vote
1answer
234 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 += ...
1
vote
1answer
230 views

“Find Similar results” Fast search for sharepoint 2010

I trying to implement "find similar results" in fast search for sharepoint 2010. Im using the docvector manage property and similarTo property(KeywordQuery property) for this. I hv to pass the ...
0
votes
1answer
27 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
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
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
152 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
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
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
319 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
107 views

FAST Query Language Syntax

I'm running nested Fast Query on SP 2010. Is this syntax correct? OR ( string("London", mode="phrase") , string("ullamcorper et blandit", mode="phrase") , AND (string("publish", mode="phrase"), ...
0
votes
1answer
34 views

Best Bets Missing When Query Contains Multiple Keywords

Let's say I have a Keyword "Hello", and a Best Bet associated to it called "Hello There". Let's say I have another Keyword "Goodbye", and a Best Bet associated to it called "Goodbye Son". If I ...
0
votes
1answer
67 views

Displaying Reports on SharePoint

First of all, I must say that I'm new to this. I'm a 3rd year ICT & Business student and an intern in a international company. My assignment is to create a reporting service on the company's ...
0
votes
1answer
126 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
1answer
440 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 ...
0
votes
1answer
48 views

How to make faster readable elements from the list?

I have an ASP Calendar, which shows elements from the list. If I try to bind the elements to the list, there are a lot of elements for example 35 429 elements. It takes up to 4 minutes to load this ...
2
votes
0answers
359 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(); ...
2
votes
0answers
299 views

Sharepoint 2013 Search File Share result source exclusion

I'm using the query builder to try and get the results excluded containing the string "archive" The content source is a file share, not a web page. This is one of the hundred query transform ...
2
votes
0answers
396 views

Sorting in Search.asmx querypacket

I have this querypacket to query Search.asmx service, and get back the results, stored in queryXML object, I can retrieve data successfully, but I can't figure out how to sort this data on any field I ...
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 ...
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 | ...
1
vote
0answers
68 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 ...
1
vote
0answers
61 views

sorting with querymanager

i see a function orderBy but i don't understand how it works and if it's the correct solution. i'd like know the way to sort the results from querymanager or maybe do this in kql? and then are there ...
1
vote
0answers
49 views

DataView Webpart Folders

Is there a way to pass the root folder parameter to a page that the DataView webpart consumes? If I have a page, test.aspx with a DVWP on it, it will show all my documents and folders in a list. If I ...
1
vote
0answers
192 views

Multiple Column Lookup field from Access to Sharepoint

I have two fields called "Tool ID" and "Tool Name" in my main "Tools" table in Access. "Tool ID" is set as the primary key, in that it gives each tool a unique autogenerated number. When I ...
1
vote
0answers
54 views

What CMIS services are required if Fast Search is used to query an external CMIS repository

For a repository to be CMIS compliant, it must implement a number of services. Query services are not mandatory. I want to incorporate a CMIS repository in SharePoint 2010 as an External Content Type. ...
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 ...
0
votes
0answers
19 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
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 ...
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
0answers
42 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 ...
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 ...
0
votes
0answers
158 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
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
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
0answers
27 views

Query all items which belong to same model based on article number

I want to create a query which retrieves all items which belong to same model, based on their article number. Every item have an article number which can be something like I-12V2 which is standard ...
0
votes
0answers
35 views

different query for same view showing on different page as list view web part

If you have three pages and want to add Documents library as list view web part to these three pages with different query (Programmatically), Do you need to create three different views for Documents ...
0
votes
0answers
94 views

Content Query migration

I'm doing a migration from 2007 to 2010 and one of the issues I've run up against is the Content Query Web part seems to come pre populated in my 07 install, and this behaviour overwrites my nice ...