Template talk:Tabular query
Add topicLatest comment: 4 years ago by The RedBurn in topic Query number columns
Query number columns
[edit]Is it possible to use this template for querying number columns?
For example it could be successfully queried for string occurence, like
{{Tabular query|SELECT=hospitalisations_icu_total|FROM=COVID-19 Sweden daily cases hospitalisations deaths|WHERE=date|IS=2021-02-25}}: `5233 `
But when query changed to look for number in number column, it just returns empty string (fails to find appropriate row):
{{Tabular query|SELECT=date|FROM=COVID-19 Sweden daily cases hospitalisations deaths|WHERE=days_back|IS=0}}: ``
84.47.179.91 21:28, 26 February 2021
- I'm guessing you want to query the date of the latest row of commons:Data:COVID-19 Sweden daily cases hospitalisations deaths.tab. The easiest way to do it is:
- {{#invoke:Tabular data|cell |output_row=-1 |output_column=date |COVID-19 Sweden daily cases hospitalisations deaths.tab}}
- which returns: 2023-03-22
- The RedBurn (ϕ) 20:34, 3 December 2021 (UTC)