Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have two custom lists in SharePoint 2010 (Absent Request and Employee Leave Balance) with these columns:

Absent Request List: Absent Type, Approver, Start Date, End Date, Absent Reason

Employee Leave Entitlement: Employee Name, Approver, Annual Leave Balance, Sick Leave Balance, Hospitalize Leave Balance, etc.

When John creates an absent request for 5 days Annual Leave in Absent Request List, a workflow will check John's leave balance from the Employee Leave Balance List (under the Annual Leave column) to see whether John is still entitled to take 5 days annual leave.

Is it possible to use a CAML query to do this check?

share|improve this question
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.