Signin Signup

How to retrieve SUM value with SQL Query in Embedded Block?

Could someone help me understand how I can retrieve this sum value using an SQL query in an embedded block?

I've tried this, but it's not working:
SELECT SUM("Price") AS total_price FROM blocks WHERE id='20240226045157-aamgpcf'

But this is working...
SELECT * FROM blocks WHERE id='20240226045157-aamgpcf'

1 Reply

124 27 2 9 85

Related articles

Quick insertion of a child block
How is it today? If a block... A) ... has no child(or children): Ctrl+Shift+A Tab B) ... has child (or children) Expand (if collapsed) Go to the end of the bloc ..

17 1 day
"Expand / Collapse" - suggestions for improvements (2)
How is it today? To completely expand a subtree, you must go to each block within that subtree, that has children, and expand it (and recursively, if necessary, ..

14 1 day
"Expand / Collapse" - suggestions for improvements (1)
How is it today? To collapse a subtree, the cursor must be in the root (parent) block of that subtree. Improvement proposal With the cursor in a child block (sa ..

25 1 day
"Exit focus" shortcut doesn't work
SiYuan Settings -> Keymap -> Exit focus Configured shorcut: Ctrl+PageUp Clicked 'Refresh' buttom At editor: zoomed an arbitrary node/bullet Ctrl+PageUp sh ..

20 1 day
Miscellaneous questions
First of all, if the most appropriate way would be to post each question in a separate post, please let me know so that I can do it that way in the future. An i ..

20 2 days
Feature: Quick navigation on mobile
The fastest way I've found to navigate back on mobile takes three taps: Gear kog on top-right Recent Documents Previous document Many apps that I enjoy using on ..

30 5 days
Change font on desktop and mobile app
Is there a way to change the font on desktop, so that the font is also loaded on the mobile(Android) app?

20 5 days

1 Reply

How to retrieve SUM value with SQL Query in Embedded Block?

Welcome to here!

Here we can learn from each other how to use SiYuan, give feedback and suggestions, and build SiYuan together.

Signup About

Please input reply content ...

leolee9086 • 1 month

Embedded Block can only use SQL sentence starts with "select * from blocks" for some reason
And dataBase block can not use SQL for now

Usman

Recent hot