CAML query in sharepoint 2010

Question

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 AccountNumberBankNameCountry 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 MaheshGanesh Data 333 SBI US Data 4444 SBI India Lets take logged in User SureshThen 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.

Manesh Golekar · Answer

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 Babu · Answer

half completed.

Sagar Pardeshi · Answer

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);