How to get/capture the output result of a query?

I might not be understanding it correctly. But this is what I want to achieve:

I'm running a query and I added at the end a RETURNING so I can get the created ID. This, so I can capture it an use it in another query.

What I'm looking to get is the number 93 from inv_com_id of the Output.

Is this posibble? Thanks.

Hey @Adorp, you should be able to access it from

You could get 93 with[0]

Might be null if this query hasn't been triggered before accessing it.

I'd suggest using the transform results box to return the new ID to keep your downstream logic cleaner