• State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 93 subscribers
  • Views 816 views
  • Users 0 members are here
Options
Related

Data export of not-triggered columns.

MChernyshev
over 3 years ago

Hi,

In out project we have special rules regarding a "default email address" column in a table Person. We construct addresses with help of a special script that is called in a template of the column. But we suspect that not all active identities have triggered this template and therefore have "wrong" email addresses. So we would like to estimate numbers of such identities. Is there a way (SQL query e.g) to retrieve all Person whose default email addresses will change if we trigger the template?   

Parents
  • 0 over 3 years ago

    Hello,

    It really depends on what your script does.  If DefaultEmailAddress has a value in each case, I suspect you could use the criteria in your script to construct the query.

    For example, current DefaultEmailAddress is firstname.lastname@domain.com (john.smith@domain.com), but the script should change this to initiallastname@domain.com (jsmith@domain.com).  Then perhaps you query to find the values that don't meet your criteria.  Again, it really depends on how you're doing this.

    Trevor

Reply
  • 0 over 3 years ago

    Hello,

    It really depends on what your script does.  If DefaultEmailAddress has a value in each case, I suspect you could use the criteria in your script to construct the query.

    For example, current DefaultEmailAddress is firstname.lastname@domain.com (john.smith@domain.com), but the script should change this to initiallastname@domain.com (jsmith@domain.com).  Then perhaps you query to find the values that don't meet your criteria.  Again, it really depends on how you're doing this.

    Trevor

Children
No Data