Custom Contributions Search Export
==================================

This export will show up as an option on the :doc:`../../../Finance/Contributions_All` page when you click the drop-down menu beside the blue `Filter` button. This recipe allows you to add additional columns of information to the standard `Contribution Export <https://docs.touchpointsoftware.com/Finance/Contributions_All.html#filter-button-and-export>`_. This specific example adds the following 3 extra values to the export.

* Addressee
* Casual Salutation
* Formal Salutation

You can modify the code below to add/change other columns of information.

Add the Export
--------------

Step 1
    Go to `Administration > Setup > Special Content` and select the `SQL Scripts` tab.

Step 2
    Click the green `+New Sql Script File` button and type ``CustomExport`` (or whatever name you choose) as the name of the report.

Step 3
    Type ``Contribution Export`` in the `Content KeyWords` field. This is what allows this export to show up as an available export on the :doc:`../../../Finance/Contributions_All` page.

Step 4
    Copy the code below and paste it into the new file. Click the blue `Save Sql Script` button.

Code
----

.. note::
    The code below uses the ``@contributionIds`` variable to include only the results from the contribution search.

    Lines ``67-69`` and ``72-74`` will need to be modified to match *existing* extra values on your database. Those rows are simply an example of the code necessary to include extra values named ``Addressee``, ``Casual Salutation``, and ``Formal Salutation``.

.. literalinclude:: Files/CustomContributionsSearchExport.sql
    :linenos:
    :emphasize-lines: 67-69,72-74

|
|

+--------------------+------------------+
| **Latest Update**  |  **1/24/2022**   |
+--------------------+------------------+

Created article.