Makes in_care query different hopefully better.

cloud-gov / hhs-acf-uc-api

API for the Dept. of Health and Human Services: Administration for Children and Families' Unaccompanied Children database

Creative Commons Zero v1.0 Universal

2 stars 1 forks source link

Closed baccigalupi closed 8 years ago

baccigalupi commented 8 years ago

    Because of the way the query was set up before, it was always

the same number and base on the two statuses in the data.

    Changed query: if the date is today, it will just find all with

the correct statuses. Otherwise, it will find anything with an program exit after that date and a status of DISCHARGED.

    The otherwise (not today) case is going to be greedy and get

things wrong, but the data does not exist either way.

baccigalupi commented 8 years ago

@mgwalker Can you check this out for sanity?

baccigalupi commented 8 years ago

@mgwalker Nevermind. The data is so bad that the two queries are off by more than 20%.