sheltermanager

Open full view…

I am trying to adjust the SAC Dog report to not include Trial Adoptions

tmc210
Mon, 29 Jul 2019 17:29:52 GMT

What script would I use to do this?

robinrt
Mon, 29 Jul 2019 17:51:31 GMT

The 2 subqueries that produce dog adoption counts need an IsTrial=0 clause. These are the ones that are aliased as AdultDogAdoption, JuniorDogAdoption. For both of them, change the line --- WHERE MovementType = 1 --- to --- WHERE MovementType = 1 AND IsTrial = 0 ----