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'

Usman 1 month

1 Reply

127 27 2 10 87

Suggestion: Ticktick Integration
Hey team, please consider adding in the future integration to TickTick application. Ticktick is a todo-list / habit tracker / time blocking calendar application ..

10 18 hours
Can't access docker instance and network sharing from my mobile
Hi siyuans I am having trouble accessing my siyuan docker instance, when I open it on the port 9806 and enter auth code, I am stuck on the logo page and nothing ..

20 2 days
Custom shortcuts sync
Custom shortcuts, as far as I noticed, are not synchronized. I think it would be interesting if they were. Thanks a lot!

19 1 day
Android app: visibility of 'Toggle' button (one that expands/collapses a block) should be configurable.
Android app. There should be a setting so that the 'Toggle' button that expands/collapses a block could (1) always be visible or (2) only be visible when the bl ..

20 3 days
Adapt to VSCode 1.89.0 update
The main content is excerpted from the VSCode 1.89 release notes. In this document, 'we' refers to VSCode. Local workspace extensions is generally available Loc ..

21 3 days
Bug when selecting blocks with the keyboard
[pic] Situation A Cursor is at A Shift+↓ repeatedly I can select from A to E [pic] Situation B Cursor is at A A is collapsed Shift+↓ repeatedly I cannot select ..

38 6 days
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 ..

45 1 week

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

Article

Point

857

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

Related articles

Suggestion: Ticktick Integration

Can't access docker instance and network sharing from my mobile

Custom shortcuts sync

Android app: visibility of 'Toggle' button (one that expands/collapses a block) should be configurable.

Adapt to VSCode 1.89.0 update

Bug when selecting blocks with the keyboard

Quick insertion of a child block

Welcome to here!

Recent hot