TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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.
Reply
Answers (
3
)
bind the image from sharepoint picture library in Gridview
Sharepoint Practise