Help constructing an Advanced Search

Patrick Points

I'd like to easily identify Requests that have been marked Renewable, but have not yet been Renewed. The Renewable checkbox doesn't appear to be something you can add through the Basic Query Builder (all I see is an option for the Renew Date, which doesn't exist yet).

Is it possible to use the Advanced search to identify Request records where the Renewable box has been checked?

Justin Finighan

@Patrick Points this Advanced Search will find all Renewable Requests that have not yet been Renewed

Requests.Renewable = -1 AND NOT EXISTS (SELECT * FROM Requests r WHERE r.Prior_Grant_ID = Requests.ID)

Patrick Points

@Justin Finighan Thank you very much!

Angela Finley Hunter

@Patrick Points - Thanks for this post Patrick!!!!

Angela Finley Hunter

@Justin Finighan - Thanks for the answer Justin! Very helpful!