Business Forms : Update Request Payload

Grafana
1

Hello to the ones who will read this !

I’m facing an issue (again haha) with the business Forms plugin that might be because of Grafana or my error.

This is the “Update Request” :

image
image703×512 21.6 KB

And this is the “Update Request Payload” :

image
image804×440 26 KB

The goal is to combine both the insert statements to be able to add values to both the tables.

Each insert statement works well separately, the issue is when I use them both at once.

I could create another visualization for the second table, I’m still curious about why this first option doesn’t work.

Thanks in advance !

Leane

1 Like
2

@LeaneM I don’t believe that transactions or multiple statements are supported in the data source.

I would recommend to use function/procedures to implement multiple statements and transactions.

1 Like
3

@mikhailvolkov Got it thank you !

So where should I write this procedure/function exactly ? (in the Business Forms, as a query, …)

4

https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html

1 Like
5

Thank you there, will read it.

Appreciating your help !

1 Like