Strange behavior

12 views
Skip to first unread message

John Currey

unread,
Nov 12, 2022, 12:02:51 PM11/12/22
to SDQL API
Using this query:
  • date,team,o:team,coach,p:coach@coach!=p:coach and week>1 and date<today and season=2022
The developer UI shows 1 game as expected.

https://s3.sportsdatabase.com/NFL/query.html?sdql=date%2Cteam%2Co%3Ateam%2Ccoach%2Cp%3Acoach%40coach%21%3Dp%3Acoach+and+week%3E1+and+date%3Ctoday+and+season%3D2022&submit=++S+D+Q+L+%21++


Joe Meyer

unread,
Nov 12, 2022, 2:31:52 PM11/12/22
to sdq...@googlegroups.com
John,

it looks like the code preparing the SDQL for the API is putting quote marks around 'p:coach'.

That is, the SDQL you are sending to the API server is:
date,team,o:team,coach,p:coach@coach!='p:coach' and week>1 and date<today and season=2022

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/ce990000-4caf-4df7-b82e-1a472c325b6fn%40googlegroups.com.

John Currey

unread,
Nov 12, 2022, 3:31:42 PM11/12/22
to SDQL API
Oops, thanks for uncovering my mistake!
Reply all
Reply to author
Forward
0 new messages