Requirement for Custom Query

Summary:

Hi Experts!

We had a requirement from the customer to have a role which would grant access only to CONTRACTOR records and should satisfy the following conditions:

From our findings we understood that the requirement is possible via the custom query attached to person security profile. Below is the summary of the requirement which they have asked for:

• Role should only give access to CONTRACTOR records.
• If the worker is from INDIA and falls into the given list of Departments then his record shouldn't be picked up.

Example:

Consider three cwk's john, matt and david - all 4 are contractors. John from US, matt from US and david from INDIA and Anil from india. for example lets consider the dept as A.