None vs =0

[John Currey]

I was trying to get a team's first home game of each season. In S2, I used this, which now returns no results.

• date,team,o:team@team=Yankees and H and tS(1@H) is None

https://s3.sportsdatabase.com/MLB/query.html?sdql=date%2Cteam%2Co%3Ateam%40team%3DYankees+and+H+and+tS%281%40H%29+is+None&submit=++S+D+Q+L+%21++

I change the query to this which returns the expected data.

• date,team,o:team@team=Yankees and H and tS(1@H)=0

https://s3.sportsdatabase.com/MLB/query.html?sdql=date%2Cteam%2Co%3Ateam%40team%3DYankees+and+H+and+tS%281%40H%29%3D0&submit=++S+D+Q+L+%21++

I think the "is None" version is correct. I'm wondering if something changed or if I have something wrong in the data.

[Joe Meyer]

John and SDQL API Friends,

yes, the Sum aggregator now default to 0.

To isolate a team's first home game of the season, use the SDQL:

tS(1@H) = 0

or, equivalently,

tA(1@H) is None

I've updated the manual to reflect this change.

Best regards,

Joe Meyer

Sports Database LLC.

--

---
You received this message because you are subscribed to the Google Groups "SDQL API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sdqlapi+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/a94317b5-4345-4515-ab0b-557e3e881242n%40googlegroups.com.

[John Currey]

Thanks, Joe!