Compare fields in queries

I would like to be able to compare two separate against each other without having to define the specifics match criteria as indivudal queries.

Currently I could build a query looking for Solicit Code = A and Action Attribute <> A to return a positve result. But this would requrie me to build a separate query for each solicit code/action attribute combination in my system.

What I would like to do is build a query Solicit Code <> Action Attribute.

  • JP Provencal
  • May 11 2012
  • Attach files
  • Guest commented
    March 17, 2016 23:09

    I would like to compare date fields. Like First gift date = latest gift date or latest gift date > latest action date.

    Attachments Open full size
  • Guest commented
    March 17, 2016 23:09

    JPP and Melissa's are fantastic suggestions. Additionally, I would like to be able to compare fields between spouse records, such as Preferred Address <> Spouse Preferred Address, or Total Given <> Spouse Total Given (to fix soft credits), etc.

    Attachments Open full size
  • Guest commented
    March 17, 2016 23:09

    More examples:

    summary gift field 1 > summary gift field 2
    last gift amount > next to last gift amount (ya, we need this field added too)
    Last name <> spouse last name (to check that add/sal is correct)
    Proposal Ask/Expected Amount > Proposal Funded Amount
    Rating (this year) <> rating (last year)

    May be more but that is what I can think of quickly.

    Attachments Open full size
  • Guest commented
    March 17, 2016 23:09

    Oh Primary Add/Sal (couple add/sal) <> Spouse Primary Add/Sal (couple add/sal) too!

    Attachments Open full size

Related ideas