Mahesh Babu

Mahesh Babu

  • NA
  • 1.7k
  • 368.4k

CAML query in sharepoint 2010

Jul 14 2014 10:30 PM
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.


Answers (3)