CAML query in sharepoint 2010

Mahesh Babu

Hi,
I have Two Lists.
1) Entity
Columns:
Title-Text
BankName-Text
Managers-Person or Group(multiple Users)
2) BankBook
Columns:
Title-Text
AccountNumber- Number
BankName- LookUp (from Entity List- BankName)
Country- Text
Now I want retrieve the data AccountNumber,BankName,Country from BankBook based on the condition.
Condition is Managers are belong to multiple banks. now based on the Logged in User I want to retrieve the data from BankBook List.

Title AccountNumber BankName Country          Title BankName Managers
Data 111                  SBI           India                 Test        SBI       Suresh, Mahesh
Data 222                  Kotak         Germany           Test       Kotak      Mahesh,Ganesh
Data 333                   SBI          US
Data 4444                 SBI           India

Lets take logged in User Suresh,Then result will come like this, because suresh belong to SBI Bank

Title AccountNumber BankName Country
Data 111                 SBI             India
Data 333                 SBI              US
Data 4444                 SBI            India
So, Please provide Caml query or other approach to achive this.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manesh Golekar12y ago
1. Get Banks for where current login Manager

SPList entitylist = ... // entity list
SPQuery query = new SPQuery();
SPUser user = ... // SPUser object

string sUserName = user.Name;

query.Query = ""+sUserName+"";

SPListItemCollection itemColl;

itemColl = entitylist.GetItems(query);

2. Get All Accounts for each Bank from second list

DataSet ds = new DataSet();
DataTable dt = null;

SPList bankBooklist = ... // Bank Book list
SPQuery bquery = new SPQuery();
SPListItemCollection bitemColl;

for each(SPListItem item in itemColl)
{
bquery.Query = ""+Convert.ToString(item[BankName])+"";

bitemColl = bankBooklist.GetItems(bquery);

dt = bitemColl.GetDataTable();
ds.add(dt);
}

Hope this will Help
Mahesh Babu12y ago
half completed.
Sagar Pardeshi12y ago

SPList list = ... // initialize your list
SPQuery query = new SPQuery();
SPUser user = ... // initialize SPUser object

string sUserName = user.Name; // you just need to know user display name in SharePoint

query.Query = string.Format("{0}", sUserName);

SPListItemCollection items;

items = list.GetItems(query);