The query tag has no wiki summary.
1
vote
2answers
36 views
query a sharepoint 2010 list from excel vba to retrieve a specific record
I have created a SharePoint 2010 list with 2 relevant columns:
- Identification Key
- Version Number
I want to be able to query this SharePoint list from Excel VBA - passing the Identification Key to ...
0
votes
0answers
30 views
Is there a way to remove code from a sharepoint list?
Ok I have a custom built sharepoint list on a standard aspx page with no sharepoint header. With Sharepoint Designer I have set parameters on my list with several filters. On the page I have several ...
1
vote
3answers
128 views
Web service based CAML query breaks 5,000 item limit
I have a CAML query of the form shown below which is called via the Sharepoint web service interface to search the entire Sharepoint site containing 600,000 documents looking for documents:
...
0
votes
1answer
21 views
Shorten Search String to get around character limitations
We are trying to use the standard sharepoint search alerts and are currently being limited by some character limitations. I am wondering if there is a way to shorten our search strings...
For ...
0
votes
0answers
52 views
Search Refinements and Search Core Results Query
I think this might be a bug in SP2013, but let me know your thoughts.
Using SP2013 I have a search page with a refinements panel and a search results web part. At that point all works perfect. The ...
0
votes
2answers
52 views
Where to define Query Rule and when?
We can define Query rule in three places:
Search Site > Site Settings > Search > Query Rules
Search Site > Site Settings > Site Collection Administration > Search Query Rules
Search Service ...
0
votes
1answer
45 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
1answer
45 views
Dynamic Content Editor Text File
I would like to have the text file associated with my content editor change based upon the query string.
?division=Name
Content Editor link:
/site assets/[QueryStringResult].txt
0
votes
0answers
63 views
Append Text To Query only follows two restrictions
I have a people search page for our staffdirectory. I want to filter out some user profiles that are for generic accounts. I have the following in the 'Append Text To Query' box in the webpart.
...
4
votes
1answer
206 views
Error using javascript to retrieve a SharePoint list's items
I am trying to use this method to query items of a column of a list in my SP site via javascript (the reason I am doing this is to display that info on the page by modifying the html tags in the DOM), ...
1
vote
1answer
67 views
Filter query by site property
I have set a crawled property at the site level using
$site.IndexPropertyKey.Add() and $site.Properties.Add()
I set the value of that property to "somevalue"
I full crawled.
I mapped it to a managed ...
0
votes
1answer
36 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 ...
4
votes
2answers
362 views
Get all Files from sub folder of a certain content type
my problem is I have a document library with sub folders. Also the document library got more than one content type.
Is there a way to create a CAML or LINQ query to get all files of a certain content ...
0
votes
2answers
59 views
Sorting out lookup values while getting them
I have two lists,
List A [Document Number, Name, Title,...] (document library)
List B [Information Number, Name, Title, Document Number] (simple list)
Now List B is getting all documents from List ...
0
votes
1answer
118 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 ...
1
vote
1answer
189 views
How to use Content Query by query string parameters
I need my Content Query Web Part to show some content which depends on a Value of a property. Now I had no problem doing it "statically", putting in the properties the filter like:
Column is equal to ...
0
votes
1answer
41 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 ...
1
vote
0answers
26 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. ...
4
votes
4answers
2k views
Multiple Values in CAML query from Array? SharePoint 2010 using jQuery/SPServices
So if I use SPServices to GetListItems with CAMLQuery, is it possible to insert multiple values inside Value Type='Number'> here
I would like to evaluate things throught a flow in my page, add to an ...
1
vote
1answer
128 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
308 views
AllItems View of Query String: can I group using value in query string?
Can I somehow how a query string to show a group of documents within a given library. Not one single item, but the AllItems like view. So within the library I have a grouping type of id value in a ...
1
vote
1answer
168 views
Send current user's parameter to External Content Type
Is it possible to send the current user's username as a parameter for my External Content Type query? I am on SharePoint 2010 Standard.
0
votes
0answers
70 views
Access append query multiplying results to SharePoint
I have an Access 2010 query that uses two left joins between two tables (SQL below, both tables are linked SharePoint 2010 lists). When I run it as a Select query it produces 3,701 results - the ...
0
votes
1answer
160 views
Query by user field returns wrong number of items
I'm trying to query a list in an eventreceiver through properties.List.GetItems (in the itemadding event). The field I'm filtering on is a 'Person or Group' field. But the query always returns all ...
1
vote
1answer
519 views
How do I convert CAML to use in the CQWP?
I have the following CAML query which returns checked out files.
<Query><Where><Eq><FieldRef Name="CheckoutUser" /><Value ...
0
votes
2answers
328 views
DVWP CrossList Paging Does Not Work
I've build a Data View Web Part with SharePoint Designer 2010, using SPDataSource and DataSourceMode="CrossList". The DVWP works great, but when I add paging, it adds the paging placeholder and the ...
1
vote
1answer
217 views
Get all webs with certain property value
If I have a certain number of webs within my site collection, and those web have set some property, eg. web.Properties["foo"] = "bar". I'd like to get list of all the webs which have property foo set ...
0
votes
3answers
547 views
how to check CamlQuery results
.I am running below query against a sharepoint list.
How to check the results of below Camlquery? cPop is set with value 'AboutUs'.
Result is always zero records although list has valid matching ...
0
votes
0answers
376 views
Error: Report item expressions can only refer to fields within the current dataset scope, System_State, TFS 2010 WSS 3.0 Report Builder 2008 R2
When I add comments to the Burnrate and Burndown reports in Report Builder to the query (dsVelocity or dsBurndown) I get:
Error: The Field expression for the dataset 'dsVelocity' refers to the field ...
1
vote
3answers
839 views
Page a list via A-Z
So I am trying to create an a to z directory from a list of items which should be an easy task and it is really, however, I am trying to find the most efficient way of doing it.
So I was thinking use ...
0
votes
1answer
192 views
PublishingStartDate empty even though the page is published
I've been through the typical publish/approve process and have, seemingly, successfully published a page (I've checked it's approval status in the manage content and structure section of the site ...
2
votes
2answers
57 views
Where can I find a list of fields that can be retrieved when running a sharepoint query?
An SPSiteDataQuery. So far I have:
...
query.ViewFields = @"<FieldRef Name=""Title"" /><FieldRef Name=""Author"" />";
...
I just happened to get these two FieldRef's right (purely ...
0
votes
0answers
78 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 ...
1
vote
1answer
3k views
Querying a simple list with a 'User' column, using CAML
I'm having some trouble getting a CAML Query working against a very simple list.
My custom list has the fields:
Person : User
Date : Date
Amount : Lookup
My query looks like this:
<Query>
...
1
vote
2answers
303 views
Selecting single user from User Information List
I've got a problem with not being able to select a single list item from the User Information List,
I have used U2U CAMLbuilder to build a query that extracts an entry with the ID = 1
When run in the ...
1
vote
2answers
96 views
Search Service Property Returns Nothing
I'm using the SharePoint query web service to search and return results. Everything is working great and I'm able to get back plenty of properties from the search. Some of the properties include ...
8
votes
5answers
9k views
How to query Sharepoint 2010 lists with sql?
I think it has to be a common task. We have some applications on sharepoint and we need to prepare reports with data from these applications. It would be great if we could use Reporting Services. We ...
3
votes
2answers
170 views
View SQL Queries/times for page request
SharePoint 2010 has the fancy new developer dashboard where you can view the SQL queries made and how long they took to determine bottlenecks etc.
I am not a SQL Sysadmin so I cannot use SQL profiler ...
4
votes
3answers
858 views
How to get visible SPField's for a specific list view
I am trying to enumerate a list based on a selected view - basically, programmatically doing what is visually shown when viewing a list.
I will be using this to output a file, so I am first getting ...
3
votes
1answer
696 views
Is it possible to return only the count of the query?
Is there any way to return only the count of the rows from a Sharepoint query? I would like to get only the count of the result returned by sharepoint query.
1
vote
1answer
583 views
External List Error : The query against the database caused an error
I got an SQL Server 2008 R2 and a SharePoint Server. I have put up a BCS between the two servers. Reading data through a External List. This worked fine yesterday. But to day I got this error:
The ...
0
votes
1answer
409 views
Removing duplicate results FAST Search Server for SharePoint 2010
I have a custom content type which contain duplicate values. I try to remove duplicate results from Query Web service returns. For specify duplicate data, I created "groupid" managed property which ...
3
votes
2answers
433 views
Jumping to a specific page within a SharePoint List
I was wondering what people think the best way is to jump to a specific page within a sharepoint list, taking into account performance considerations.
eg:
1) List with 1000 items in it
2) Each page ...
1
vote
2answers
744 views
How can I query all of the items which are inside a folder, which is in turn inside a document library?
I am trying to use Powershell to query my Sharepoint site so I can get a list of items to use as input in my migration script. I have a document library (Site Assets), which has a folder (Calendar ...
3
votes
4answers
710 views
What is the recommended way to query data on a Sharepoint site?
Say if I need to retrieve list items for batch processing, how would I be recommended to retrieve the data? Maybe Powershell or a SQL Server query?
0
votes
1answer
293 views
Wrong results returned with Sharepoint Client ObjectModel
I'm using the sharepoint client object model for a small application. When I try to get all folders and items from the "Shared Documents"-library, it doesn't return all folders and files.
Code:
...
4
votes
3answers
2k views
How to query multiple document libraries?
I need to query multiple document libraries and get a particular item's ID by matching the queried barcode value. I need the ID to update the metadata for that item using web services. All the ...
