How to Build Alert based on Grade code.

Summary:

We are in the process of creating alert email notifications to users other than specific grade codes which contain 'VP' 'HR'. Alert should be excluded to those whose grade code contains VP, SP, EP, SE ex: MKMSSEMGMC

The steps I currently follow are,

Add Resource Alert - Add filter - workers/workRelationships/assignments - Add expression.

workers/workRelationships/assignments - GradeCode - But do not have not equal to Operator.

And I also tried SQL query - exists(select 1 PER_GRADES_F where ( substr (grade_code,1,2 ) = 'HR' OR substr (grade_code,5,2 ) IN ( 'SP', 'EP', 'VP', 'SE' ) )

I know something is wrong with my input, please help me with the right SQL or expression