SPQuery represents a query in a list view.
1
vote
3answers
2k 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
192 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 ...
0
votes
2answers
182 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 ...
3
votes
1answer
141 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 ...
0
votes
1answer
15 views
Filter List for DateTime using CAML against Calculated Field
In WSS 3.0, I have a list with a Calculated Field, 'MaxDate'. It gets the greater of two other dates, Notional Date and Override Date.
I am trying (and failing) to build a CAML query to get all items ...
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 ...
0
votes
1answer
551 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
2
votes
0answers
38 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?
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 = ...
1
vote
0answers
119 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 ...
1
vote
0answers
118 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
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 ...
1
vote
0answers
998 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
288 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
0answers
74 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 ...
