SPQuery represents a query in a list view.
2
votes
1answer
51 views
SharePoint 2013 list items paging
I'm trying to make a webpart with list items paging. I followed this link http://www.directsharepoint.com/2011/03/step-by-step-guide-to-implement-paging.html
and on SharePoint 2010 server it works ...
0
votes
1answer
22 views
How to list all alements by CAML to SPGridView
Is it possible to display the listitems retrieved from a CAML query in a SPGridView?
How can I implement it?
0
votes
1answer
29 views
quick way to access splistitem in different list?
I have 2 lists: listA and listB
listA has 2 fields:
Title (text)
PortalID (text)
listB has 3 fields:
Title (text),
listAField(lookup to listA Title field)
UserID (text)
I have a UserID value ...
2
votes
2answers
217 views
SPQuery works on libraries under the list view threshold, but not over
So I am building a webpart which enumerates all doclibs in the current web, grabbing all checked out files and listing them in a table, allowing a user to apply some required metadata and check in ...
1
vote
1answer
70 views
SPQuery on null lookupfield
I have a contact list with a company lookup field and I need to retrieve those without any company associated
so I was thinking can I put it like this:
<Query>
<OrderBy>
...
2
votes
1answer
136 views
Caml Query - skip X first results
Let's assume I have list with 100 items. Is it possible to write CAML query to get 5 items, but skip 10 items from the beggining? Something like LIMIT and OFFSET in SQL?
2
votes
2answers
181 views
Get SPQuery TotalItems from query
I want to get the total number of items that match my Query, BUT also limit the results.
So say I have 100 items in the list.
50 of the 100 items in the list match my query.
I want to only get 10 ...
1
vote
0answers
111 views
SPSiteDataQuery without subfolder items?
I'm trying to use the SPSiteDataQuery to return the contents of several lists across a site collection. The problem I'm having, though, is that while there are only a few documents at the root level ...
0
votes
1answer
270 views
How to Set SPQuery.RowLimit to get all items?
I'm using my SPList View to get the html code of extracted items by an SPQuery over the listview
SPList myList = mySite.RootWeb.Lists.GetByInternalName("ListINStr");
SPView oView = ...
4
votes
2answers
195 views
SPQuery returning different before and after using RunWithElevatedPrivileges method
I am having a huge problem here.
I am executing a query looking for a SPListItem, when I execute this query with user identity it works well, retuning the fields "Author" and "Editor" that I need.
...
1
vote
2answers
216 views
SPQuery always returns values
I am trying to check a list for related values but for some reason every item in the list is returned each time. I have seen this issue before and for me its always meant a bad CAML string but I have ...
0
votes
2answers
71 views
Dynamic SPQuery
I want to build search criteria by using SPQuery object that searches a list. On application page, there are two textbox Controls, 2 combobox Controls and 2 people picker Controls. The search criteria ...
2
votes
0answers
33 views
Mysterious DBCS (Double-Byte-Characters), i.e Kanji from SiteData query
Records returned from SPWeb.GetSiteData have some fields encoded in DBCS (Kanji characters). What could be causing this?
1
vote
2answers
315 views
GetDataTable from SPListItemCollection
My question is regarding the use of DataTable vs ListItemCollection. Basically I have a small solution, where I have to loop through the items in the list to verify if the items already exists or not.
...
3
votes
1answer
140 views
Fetching from large lists while throttling is enabled
Here's the situation:
I have a heavily customized web application built on top of MOSS 2007
We're in the process of upgrading the application to SharePoint 2010
QA has identified that a page which ...
1
vote
1answer
158 views
SPQuery - join two tables and count each
I have two tables with a 1-M connection and have not been able to correctly convert the following SQL into a caml/spQuery
I want every value in table A once no matter what & table B divided into ...
0
votes
1answer
339 views
SPDataSource for asp gridView returns nothing?
I'm binding my SPDataSource to an ASP:DataGrid but it returns empty gridview not filled.
Here's my aspx file
<SharePoint:SPDataSource runat="server" ID="SPTypes" DataSourceMode="ListItem" ...
0
votes
0answers
73 views
spquery.query cannot be charged correctly
I'm charging my spquery with different parameters from a static class called Fields :
In fact I'm using this query to bind result data to my asp:grid view
using (SPSite mySite = new ...
0
votes
4answers
867 views
Detected use of SPRequest for previously closed SPWeb object after SPQuery
this code run yesterday very well and today I've been trying to solve this error for hour now :
Please close SPWeb objects when you are done with all objects obtained from them, but not before
I ...
0
votes
3answers
1k views
Sharepoint 2010 SPQuery to join two custom lists
I have two custom lists.
list 1 having following columns:
ID (consider as PK)
title
list 2 having following columns
NID (lookup column)
title
I'm using spquery.joins like below
<Joins>
...
0
votes
2answers
185 views
SQQuery, Dates and Regional Settings
First, some setup: My Site is set to Eastern Time, and the server is located in Eastern Time.
I'm trying to run a query against a list using the created date. I have tried using all variations I can ...
1
vote
2answers
442 views
Simple SPQuery throws error
I am trying to pull populate a lookup field using a lookup value without the lookup ID. I am getting the error: "One or more field types are not installed properly. Go to the list settings page to ...
3
votes
2answers
622 views
Use SPQuery.RowLimit also on large lists with small query results?
I frequently read one should use RowLimit on SPQuerys on a large list, especially with more than 2000 items.
Best Practices: Common Coding Issues When Using the SharePoint Object Model:
An ...
2
votes
2answers
133 views
QueryThrottleMode in non-query operations?
I have a big List which I want to empty. Therefore I create a template from that list, delete the list and create a new list from the template I just saved before.
I know there are other ...
0
votes
1answer
835 views
Adding IsNotNull and ViewFields in CAML Query
Trying to add IsNotNull parameter and ViewFields paramter but throwing an error. Am I inserting incorrectly or missing something to make sure this executes correctly? Seems like View is bring back all ...
0
votes
1answer
1k views
How to set caml query for special view?
I have a list with 3 views.
I want find special items of this. I use SPQuery for it.
<Where>
<Eq>
<FieldRef Name='TypeTitle' />
<Value ...
1
vote
2answers
894 views
date ranges in CAML queries
I have a list with a datetime filed.
I want selected items from this with date rang.
I use this code
<Where>
<And>
<Geq>
<FieldRef Name='SendDate' /> <Value ...
0
votes
3answers
386 views
What is the difference between CamlQuery and SPQuery
Maybe a simple question, when to use CamlQuery and when to use SPQuery ?
I think that SPQuery is used inside a WebPart running on the SharePoint server, and that CamlQuery is part of the Client ...
1
vote
0answers
114 views
SPQuery on ECT very slow
I am creating a custom web part which is supposed to return results from an External Content Type(ECT) List which contains almost 40,000 records. There are multiple ways the items can be searched and ...
1
vote
1answer
524 views
Getting User details from field “AssignedTo” in a custom List
I have a Custom List, which have different fields, when I click on any user in field "assignedTo" it navigates me to another window and I can see user's Account, Name, email etc.
I am able to get all ...
0
votes
2answers
181 views
SharePoint list query efficiency
I'm trying to build a very high performance application on top of SharePoint 2010. One thing I'm having a hard time deciding is if I should make 2 list queries (1 small and 1 large) or if I should ...
0
votes
2answers
2k views
SPQuery for Selecting/Excluding Hidden columns from a SPlist
I am trying to take a DataTable containing ID and other columns which are not hidden.
I am doing this for a generic list which contains any number/type of columns. so I don't know the field names ...
0
votes
1answer
542 views
Join two list using multivalued lookup field with spquery
I have joined two lists with the lookup that allow single value using spquery.join. can any one help me to do for multivalue lookup
1
vote
1answer
207 views
Is it possible to use spquery in WCF for sharepoint
I created custom wcf that retrieve items from the list. Is it possible to use spquery within the wcf to filter the list items
1
vote
0answers
94 views
How to display fields of parent list and foreign list using spquery
I have created parent list that lookup to another list . Both the list having one identical column label but different values(column name: displayorder).I projected the displayoreder column from ...
0
votes
2answers
1k views
How can use API to get all Publishing pages in the site collection using a specific Content Type?
I need to use API to return all Publishing pages using a specific content type in a publishing site. this includes querying all sites in the site collection. Can I do that with SPQuery?
I am using ...
0
votes
1answer
1k views
filter items by Site name and List Name using SPSiteDataQuery
I am listing files from multiple folders using the below code:
SPSiteDataQuery q = new SPSiteDataQuery();
q.Lists = "<Lists BaseType='1'/>";
q.Query = ...
1
vote
0answers
983 views
ProjectedFields working in SPQuery but not in the View
I've three lists: Competitions, Works and WorksVotes, linked to each other through Lookup fields.
WorksVotes list has Lookup field to Works list, and Works list has Lookup field to Competitions list.
...
1
vote
0answers
282 views
Is there a simple way to add paging to ListViewByQuery ?
I'm working with a ListViewQuery component on a webpart and I need to add paging control to it.
Is there a simple way to achieve that ?
I saw somewhere than just setting the RowLimit property of ...
0
votes
2answers
1k views
Error while trying to query the custom list sharepoint 2010
I am trying to query a custom list and getting the following error:
At,
SPListItemCollection OsplistitemCollection = Olist.GetItems(OqueryResponse);
below is my code
string TicketID = "123";
...
0
votes
1answer
444 views
SPQuery works on ListViewByQuery but not with GetItems
In one of my webparts, I have a ListViewByQuery displaying some elements (or all) of a specified list. The SPQuery is built dynamically depending on the search fields.
Here is how I build the ...
3
votes
1answer
669 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.
2
votes
0answers
1k views
How to get the particular columns from a SharePoint list view
I am using SPQuery to fetch data (particular columns from the list based on viewID) from SharePoint list. Here is the code for fetching the data:
SPQuery sQuery = new SPQuery();
currentlistview = ...
0
votes
1answer
3k views
Get the SPListItems using SPList.GetItems(SPQuery)
I have a requirement of filtering the data from the SPList (ex:20000 SPListItems) and I bind it to the radgrid. I want to get first 200 and next 200 of every page click in the radgrid.
This is my ...
1
vote
3answers
436 views
is this causing memory leaks?
I have a couple of utility functions that help with querying lists and wanted to see if they I wrote them would cause either memory leaks or cause the client code to try to access already disposed ...
2
votes
1answer
700 views
Search Optimization on SPListItemCollection
I have an SPListItemCollection (Thread Discussion Collection) that consists of almost 20,000 items. Each SPListItem (Thread Discussion) on the SPListItemCollection contains a sub SPListItem(Thread ...
1
vote
1answer
443 views
How do I select only top level folders using CrossListQueryCache?
I want to select the list of folders (without subfolders, not recursive) of a Document library using CrossListQueryCache.
Everything is working fine except that i am receiving ALL the folders and ...
6
votes
2answers
2k views
Can I order by Content Type in a CAML query?
Is it possible to order by content type in a CAML query?
I seem to always get the same result no matter what I do with the Order by. Ordering by ID instead works perfectly.
query.Query = @"
...
1
vote
1answer
323 views
SPQuery.ViewFieldsOnly in WSS3?
In SharePoint 2010 SPQuery has the ViewFieldsOnly property that apparently optimises the query by only returning the data you specifically ask for.
Unfortunately the 2007 version of SPQuery doesn't ...
3
votes
1answer
2k views
How do I query a list using CAML and SPQuery?
I have a SPList but I don't need to go through everything in that list. I need to establish a CAML query so I can limit the list items. Then, go thru each item from the query result and do something. ...
