• Replies 3 replies
  • Subscribers 413 subscribers
  • Views 105 views
  • Users 0 members are here
Related

List/Output criteria request

Former Member
Former Member $organization

Does anyone have any list/output criteria that would let me select/output contribution information that includes soft credits?  Would you be willing to share that with me (including any custom views)?

Thanks in advance

 -steve carlock

Santa Barbara Center for the Performing Arts/The Granada

Parents
  • $organization

    Steve,

    I set this view to be used in LIST MANAGER, but it could be viewed in the same way for OUPUT SET MANAGER. First create the view and then add an entry in T_KEYWORD so that it is added to the OUPUT SET MANAGER.

    ALTER view [dbo].[lv_creditee]
    as
    /*
    View created to give list builder the ability to pull on credited
    contribution information. This view has an entry in t_keyword
    */

    select
        ref_no,
        creditee_no as customer_no,
        credit_dt,
        credit_amt,
        xref_no,
        creditee_type
    from t_creditee

Reply
  • $organization

    Steve,

    I set this view to be used in LIST MANAGER, but it could be viewed in the same way for OUPUT SET MANAGER. First create the view and then add an entry in T_KEYWORD so that it is added to the OUPUT SET MANAGER.

    ALTER view [dbo].[lv_creditee]
    as
    /*
    View created to give list builder the ability to pull on credited
    contribution information. This view has an entry in t_keyword
    */

    select
        ref_no,
        creditee_no as customer_no,
        credit_dt,
        credit_amt,
        xref_no,
        creditee_type
    from t_creditee

Children
No Data