Differences between Select from Manual query and users query User Manager Campaign

[HOMER333]

If I want to filter out users that did not record a response for their certification and launch a new campaign with those selected users under which query field, would I need to use. Under the Select certifier there is an option to place a manual query, but under Advanced Configurations there is also a user's query what is the difference between the two options? In addition, what query would I be able to use to only receive no response certifiers from previous campaign.

[Saathvik · Accepted solution]

Select from Manual query under select certifier: will define for which certifier you want to launch certification. Meaning you have 100 certifiers in your system but you want to launch certification for specific certifiers based on certain condition/logic then you use this option 

user's query under Advanced Campaign configurations: will define which users will be certified under certification. 

[Saathvik]

In addition, what query would I be able to use to only receive no response certifiers from previous campaign. - Do you need certifier list who did select no response for certain line items? or Do you need list of users for whom certifier selected no response?

[Saathvik · Accepted solution]

If you need certifier list who did select no response for certain line items

select u.username from campaign cm inner join certification c on cm.id=c.campaignkey inner join certification_user_status cus on c. certkey=cus.certkey inner join users u on c.certifier=u.userkey where cus.certified is null and cm.campaign_name='<campaign_name>'

If you need list of users for whom certifier selected no response? 

select u.username from campaign cm inner join certification c on cm.id=c.campaignkey inner join certification_user_status cus on c. certkey=cus.certkey inner join users u on c.certifier=u.userkey where cus.certified is null and cm.campaign_name='<campaign_name>'

[HOMER333]

I am looking for a list of users that did not respond to their certification ( i.e they did not certify any users and the campaign has expired