Zuoqiu-Yingyi/widget-query

表格中能显示图片吗

Chenm4 opened this issue · 1 comments

Chenm4 commented

我如果在asset表中查询图片能有办法显示吗，我看它只显示path

Zuoqiu-Yingyi commented

可以, 下面是一个示例, 功能为随机显示一张图片的引用路径与图片预览:

SELECT
    a.path AS __1____raw__图片引用路径,
    '![' || a.name || '](' || a.path || ' "'|| a.title || '")' AS __2____pre__图片预览
FROM
    assets AS a
ORDER BY random()
LIMIT 1;