Missing piece

[John Currey]

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]

John and SDQL API Friends,

I cannot reproduce this result.

The following URL shows only two keys:

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

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]

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]

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

To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/44d0839b-6045-4c37-a2cf-f6d6f0b9a4e0n%40googlegroups.com.

[John Currey]

Thanks Joe!