RFC: extracting distinct values

Bloke · 2020-10-10 19:17:41

etc wrote #326329:

which other SQL aggregate functions could be useful? Currently we have max, min, sum, avg.

Just count to add from that list, I think. Unless you reckon that’s adequately covered elsewhere. The rest are a bit esoteric and statistics-driven to be of much use, imo.

The only other outliers are:

group_concat() but since you have to use groups for that, we’re starting to get into seriously convoluted tag territory.
json_* because someone might want to pull out json-formatted content in future. But since we’re only targeting article tags here and don’t store JSON data yet, this might be overkill now.

etc · 2020-10-10 19:31:52

Bloke wrote #326330:

Just count to add from that list, I think. Unless you reckon that’s adequately covered elsewhere.

count is already available, but not as fields value: max(posted) is a date and can be output via <txp:posted />, but not count(posted).

group_concat() but since you have to use groups for that, we’re starting to get into seriously convoluted tag territory.

We actually already do GROUP BY, so adding group_concat() is not a problem, but I doubt of its utility.

json_* because someone might want to pull out json-formatted content in future. But since we’re only targeting article tags here and don’t store JSON data yet, this might be overkill now.

They look promising, but are available in MySQL 5.7.22+ only, do we require this?

etc · 2021-01-04 17:22:24

FWIW, GROUP_CONCAT(field SEPARATOR ',') is available now (4.8.5) as list(field). It’s yet time to change list for concat or join or ..?

Textpattern CMS

Textpattern CMS support forum

#21 2020-10-10 19:17:41

Re: RFC: extracting distinct values

etc wrote #326329:

#22 2020-10-10 19:31:52

Re: RFC: extracting distinct values

Bloke wrote #326330:

#23 2021-01-04 17:22:24

Re: RFC: extracting distinct values

Board footer