None vs =0

12 views
Skip to first unread message

John Currey

unread,
Apr 12, 2022, 7:30:22 AMApr 12
to SDQL API
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

I change the query to this which returns the expected data.
  • date,team,o:team@team=Yankees and H and tS(1@H)=0

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

unread,
Apr 13, 2022, 1:29:34 PMApr 13
to sdq...@googlegroups.com
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

unread,
Apr 13, 2022, 6:15:53 PMApr 13
to SDQL API
Thanks, Joe!
Reply all
Reply to author
Forward
0 new messages