None issues

[John Currey]

This shows all sack data has a value for 2021.

https://s3.sportsdatabase.com/NFL/query.html?sdql=jcurrey.jcurrey.date%2Cjcurrey.team%2Cjcurrey.week%2Co%3Ajcurrey.team%40jcurrey.sacks%3DNone+and+jcurrey.week%3C19+and+jcurrey.season%3D2021+&submit=++S+D+Q+L+%21++

When I look at the Rams and Cardinals, today's game p: value incorrectly show None.

https://s3.sportsdatabase.com/NFL/query.html?sdql=jcurrey.date%2Cjcurrey.team%2Co%3Ajcurrey.team%2Cjcurrey.sacks%2Co%3Ajcurrey.sacks%2Cpo%3Ajcurrey.sacks%2Copo%3Ajcurrey.sacks%2Cp%3Ajcurrey.sacks%2Cjcurrey.rushes%2Co%3Ajcurrey.rushes%2Cpo%3Ajcurrey.rushes%2Copo%3Ajcurrey.rushes%2Cp%3Ajcurrey.rushes%40jcurrey.team%3DRams+and+jcurrey.season%3D2021&submit=++S+D+Q+L+%21++

https://s3.sportsdatabase.com/NFL/query.html?sdql=jcurrey.date%2Cjcurrey.team%2Co%3Ajcurrey.team%2Cjcurrey.sacks%2Co%3Ajcurrey.sacks%2Cpo%3Ajcurrey.sacks%2Copo%3Ajcurrey.sacks%2Cp%3Ajcurrey.sacks%2Cjcurrey.rushes%2Co%3Ajcurrey.rushes%2Cpo%3Ajcurrey.rushes%2Copo%3Ajcurrey.rushes%2Cp%3Ajcurrey.rushes%40jcurrey.team%3DCardinals+and+jcurrey.season%3D2021&submit=++S+D+Q+L+%21++

Changing the team from the Cardinals or Rams to Bills or Patriots, the last row shows as expected.

Lastly, for the all teams, there seems to be one random week where po:sacks and p:sacks show None for no apparent reason. Coincidently, po:rushes and p:rushes show as None for the same game. I didn't investigate other values, but it seems something is strange. 

Thanks. 

[Joe Meyer]

John and SDQL API Friends,

This brings up an important and somewhat subtle point:

By default the parameter prefixes are defined using all the games in the database.

My best guess here is that another user had a mis-scheduled game, and that this confused the `tp` prefix.

 

To ensure that the tp (and other prefixes) only reference the games you have uploaded, use the settings API to set:

{ 'follow':['jcurrey']}

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/00b5f3d3-9152-4293-bde6-4c1abcb30ed7n%40googlegroups.com.

[John Currey]

Joe, 

Maybe I'm mistaken, but wouldn't the explicit use of my database name in the link in my post above be the same as using the follow setting?

Also, this link shows the results without using follow where I get rogue None values in the results:

https://s3.sportsdatabase.com/NFL/query.html?sdql=date%2Cteam%2Co%3Ateam%2Csacks%2Co%3Asacks%2Cpo%3Asacks%2Copo%3Asacks%2Cp%3Asacks%40team%3DRams+and+season%3D2021&submit=++S+D+Q+L+%21++

Here, I have the follow setting on and I get fewer None values, but the None values for 20220117 po:sacks, opo:sacks, and o:sack appear to be returned incorrectly. 

http://www.gimmethedog.com/NFL?q=date%2Cteam%2Co%3Ateam%2Csacks%2Co%3Asacks%2Cpo%3Asacks%2Copo%3Asacks%2Cp%3Asacks%40team%3DRams%20and%20season%3D2021

Thanks.

[John Currey]

Sorry, I think I've found the cause of this problem -- it's a data issue. Sorry for the false alarm.