How to Query on Gifts with a Posted Status of "Posted (adjustment pending)"

When a gift has a Posted status of "Posted (adjustment pending)" one may have trouble finding the correct query criteria to find such gifts.
The criteria to find these gifts is as follows:

GL post status is equal to Posted
and Adjustment\Adjustment post status is equal to Not Posted

Environment

 Blackbaud CRM
 4.0.170

Was this article helpful?