influxdb - 手动按特定顺序排序

Question

我有以下查询:

SELECT mean("voltage") FROM "cells" WHERE 
("cell" = 'Cell 1' or "cell" = 'Cell 2' OR "cell" = 'Cell 3' OR "cell" = 'Cell 4' OR 
 "cell" = 'Cell 5' OR "cell" = 'Cell 6' OR "cell" = 'Cell 7' OR "cell" = 'Cell 8' OR 
 "cell" = 'Cell 9' OR "cell" = 'Cell 10' OR "cell" = 'Cell 11' OR "cell" = 'Cell 12' OR 
 "cell" = 'Cell 13' OR "cell" = 'Cell 14' OR "cell" = 'Cell 15' OR "cell" = 'Cell 16') 
AND $timeFilter 
GROUP BY time($__interval), "cell" fill(linear)

我的问题是涌入排序为字符串，所以我得到 Cell 1 然后是 Cell 10，我想要 Cell 1、Cell 2 ......，我怎样才能做到这一点？

Answer 1

您可以使用

ORDER BY SUBSTRING(cell, 6, 12) * 1;

哪里 SUBSTRING(test, 6, 12)将从开头和 * 1 中删除“Cell”将其余的转换为数字。