Template talk:Tabular query

Latest comment: 2 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)Reply