Select from Manual Query : Certifications in progress/incomplete

[William3squivel]

To my understanding within this current version 5.5 SP 3.x there is no automatic bulk escalation of certifications for a user manager campaign to reassign from an L1 manager to an L2 manager. With this in mind I am looking for another possible workaround. A potential workaround that our team is looking at is to essentially create a new campaign filtered with only users that have not completed their certification for the application selected and launch a new campaign through the secondary manager using the attribute to identify Manager set as Secondary Manager. Is there a manual query that will filter out users that have not completed their certifications to only have them loaded within a campaign? 

[rushikeshvartak]

You can send bulk Escalation email using analytics query

[sk]

Yes possible.

select u.username from certification c inner join users u on c.certifier=u.userkey inner join campaign cm on c.CAMPAIGNKEY=cm. id where cm.campaign_name in ('<expired_campaign_name>') and c.status =4

status =4 means certification is expired. I assume certification is expired when you say not completed