Strange behavior

[John Currey]

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++

However, passing the same query through the API, returns many more games (which are invalid). 

http://www.gimmethedog.com/NFL?q=date%2Cteam%2Co%3Ateam%2Ccoach%2Cp%3Acoach%40coach!%3Dp%3Acoach%20and%20week%3E1%20and%20date%3Ctoday%20and%20season%3D2022

[Joe Meyer]

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]

Oops, thanks for uncovering my mistake!