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

learn more… | top users | synonyms

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: ...
1
vote
1answer
85 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
217 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
489 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
245 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
231 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
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
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
1answer
77 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
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. ...
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
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
378 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
118 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
36 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
68 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 ...
2
votes
0answers
373 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
315 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
411 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
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 ...
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
70 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
62 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
50 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
206 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
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
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
12 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
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 ...
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
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 ...
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
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 ...
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 ...
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
79 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
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
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
95 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 ...