[Odb-help] Fwd: ODB questions

[odb-help at lists.democracygroups.org]

An ODB user asked a few questions which we might as well
answer for the entire list:

1) It is easy to delete a donation.  Just view the person's payment
    history and highlight the donation.  Then use the "delete" key
    to delete it.

2) If you want to do a donation search, but you still want access
    to the ability to filter the list by type, activity, etc, that is pretty
    easy as well.  First select the kinds of people you want to
    search for, i.e. Activity = Advisory Board, Constituency = Women .
   Then click on the "View Custom Query" check box.  In our copy
   of ODB this shows the query:

Select *  from people where (Constit like "*W2*") AND (Activit like "*A1*") 

3) Copy the part of the query that appears after the word Where, not including
    any sort order:

(Constit like "*W2*") AND (Activit like "*A1*") 

4) Paste this text into the box:  "Add SQL to further restrict your search" and
    make sure the check box is checked.

5) Now Click on the option button at the top labeled donations.  Then enter
    the search range (date, dollar amount, etc.) for your donation search, and
    click Search to select your donors.

   Since you have put filled in the "custom query" boxes your search will
   use this information, in addition to the donation search information, in
   making your selection of donors.

-rich cowan


p.s. we made a significant change in the installer in 0.9.5 and we have
  since received two reports of people having difficulty with the database
  driver installation.  Anyone else have this problem?  We want to address
  it really soon.



>Subject: ODB questions
>Date: Tue, 15 Jun 2004 12:17:22 -0400
>
>1.  If I enter a donation twice by mistake, how do I delete one of the
>entries?
>
>2.  Suppose I want to find all the donors who have a particular Type,
>Activity, Constituency, etc.  How do I do that?
>
>Dennis Fischman
>Director of Planning
>Community Action Agency of Somerville
>66-70 Union Square, Somerville, MA 02143