PSDio - IQ - Lybunt Query For Date Range and Per Org

Purpose of This Query 

This query will give you a Lybunt/Sybunt results for a specific date range. There are four pictures below to help you build this query, the first two are the columns and the second two are the conditions (with the second picture of conditions being the subquery).

The query conditions start with a subquery, what this subquery does is says "Show me all the families that don't have a pledge for a certain time frame" So this could be your 2017 fiscal year, so you are asking for all the families that haven't given during 2017. From there you are going to add conditions that will say, "Of those families who haven't given in 2017, show me the families who did give in 2016." 

 

Columns #1

results_1.jpg

Columns #2

results_2.jpg

Conditions

date_conditions.jpg

Subquery

date_subquery.jpg

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.