Missing piece

9 views
Skip to first unread message

John Currey

unread,
Jun 19, 2022, 1:11:39 PMJun 19
to SDQL API
Hi,

This query returns the 38 May games with results separated by the 38 favorites and 38 dogs as expected.
  • month=5 and F,D and season=2021
https://s3.sportsdatabase.com/NBA/query.html?sdql=month%3D5+and+F%2CD+and+season%3D2021&submit=++S+D+Q+L+%21++

When sending "date,team@month=5 and F,D and season=2021" to the API, a list of three dictionaries are returned. In the "sdql as terms" key, I see:
  • '(t:line<0)'
  • '(t:line>0)=False'
  • '(t:line>0)=True'
I'm wondering 2 things. Why the API sends back 3 when the data for the first 2 is identical. Secondly, how does the developer UI know to only display only 2 of the 3?

I think there's a trick I'm missing.

Thanks. 

Joe Meyer

unread,
Jun 25, 2022, 2:33:08 PMJun 25
to sdq...@googlegroups.com
John and SDQL API Friends,

I cannot reproduce this result.

The following URL shows only two keys:

Please let me know if you continue to see errors here.

Best,

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/aead18b0-f745-4ae2-9b56-a972a4b9da3bn%40googlegroups.com.

John Currey

unread,
Jun 25, 2022, 3:51:22 PMJun 25
to SDQL API
Here it is. 

https://sportsdatabase.com/NBA/query.json?sdql=date%2C+team%40+month%3D5+and+F%2C+D+and+season%3D2021&submit=++S+D+Q+L+%21++

The difference is your SDQL is:

date,team@month=5 and F,D and season=2021

I used this:
date, team@ month=5 and F, D and season=2021

Joe Meyer

unread,
Jun 26, 2022, 9:35:23 AMJun 26
to sdq...@googlegroups.com
John and SDQL API Friends,

This is now working correctly.

I see that the space in `F, D` had been causing the `D` part to be incorrectly treated as an implicit group-by. 

Thanks for the good debugging,

Joe Meyer
Sports Database LLC

John Currey

unread,
Jun 26, 2022, 12:25:46 PMJun 26
to SDQL API
Thanks Joe!
Reply all
Reply to author
Forward
0 new messages