Search Engine: Elastic

Article ID: 123332, created on Oct 30, 2014, last review on Oct 30, 2014

  • Applies to:
  • Business Automation


We need to create a report about customers that have already confirmed the email. How can we do that?


The only way to find list if confirmed/not-confirmed emails is in database:

pba=> select "UsersID","Email" from "EmailConfirmationStatus" ;

And then you can get ID of the account:

pba=>  select "AccountID" from "Users" WHERE "UsersID"=[user_id_from_previous_select];

Feature request #PBA-52323 to implement such functionality in PBA-E CP.

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF