• Replies 5 replies
  • Subscribers 416 subscribers
  • Views 134 views
  • Users 0 members are here
Related

merging constituents

Mary Dahlsten
$organization

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

Does anyone know of a report or counter in Tessitura that can be used to record the number of constituent merges done over a certain period?  We are beginning to tackle our rather daunting merge list and thought it might be more bearable if we could track the amount of completed merges to indicate some sort of progress!  Any insight would be appreciated.

 

Thanks in advance and I'm looking forward to DC!

 

 

Parents
  • $organization

    Unknown said:

     

    Does anyone know of a report or counter in Tessitura that can be used to record the number of constituent merges done over a certain period?

    If you'd like counts per day over a range of dates and are or have access to someone that's comfortable with SQL, you could run something like this, too:

    select convert(varchar(8), merge_dt, 112) "short_merge_dt",
        count(*) "count"
    from t_merged
    where status = 'S'
    and merge_dt between '07/01/2010' and '07/16/2010'
    group by convert(varchar(8), merge_dt, 112)
    order by short_merge_dt

     

Reply
  • $organization

    Unknown said:

     

    Does anyone know of a report or counter in Tessitura that can be used to record the number of constituent merges done over a certain period?

    If you'd like counts per day over a range of dates and are or have access to someone that's comfortable with SQL, you could run something like this, too:

    select convert(varchar(8), merge_dt, 112) "short_merge_dt",
        count(*) "count"
    from t_merged
    where status = 'S'
    and merge_dt between '07/01/2010' and '07/16/2010'
    group by convert(varchar(8), merge_dt, 112)
    order by short_merge_dt

     

Children
No Data