0
votes
1answer
41 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 ...
2
votes
0answers
57 views

Join SPQuery in list

List 1 "Posts", fields Title body #comments modified in this list #comments fields is look up from another list Comments: List 2 "Comments", fields title body comments post ...
1
vote
1answer
490 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> ...
1
vote
4answers
3k 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> ...
1
vote
0answers
175 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 ...