Restrict person in directory search result based on DFF value

Summary

Restrict person in directory search result based on DFF value .If DFf value set to 'Yes' ,person should not visible in directory person search result

Content

Hi Team, 

i have configured a Yes/No type DFF segment in Person Information page. 

Based on the DFF value ,restrict person to appear in search result in employee directory.Say, if the value of the segment is 'Yes', then we need the Directory search to exclude those records.

I have created custom security profile with custom criteria  .Attached this custom custom profile with public person security for employee role.

&TABLE_ALIAS.PERSON_ID NOT IN (SELECT PERSON_ID FROM PER_PERSONS WHERE nvl(ATTRIBUTE1, 'N')  = 'Y')