• State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 92 subscribers
  • Views 767 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?   

  • 0 over 3 years ago

    There is no SQL to get these numbers. But if the script and the template are in the final state, you could run a data consistency check - "Objects\Templates" on the person table.

  • 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