Is there a cheat sheet for the data structure following database queries?

If I run a database query as an initial step to see whether the record exists
How can I then set a value to the id of the record found so that I can use it in a database update step.


I have found that I can use {{dataset.identity}} after a database insert. But where are these things documented.

I think I've got a similar question.
First I query a table.
Then I want to use the first record ID from that table as the filter value for an update query.

I thought of creating a SetValue step. But I don't see a possibility to assign this first record ID to the SetValue.
Someone any suggestions/ideas??

Hi Hans,
In order to get a specific result from a query in server connect you just need to:

1. Add and filter your query
2. Add a repeat after the query, and use {{queryName}} as a repeater expression
3. In the repeater step, add whatever action you need and you will see the binding from the query repeat.

Yes I thought of using A repeater.
But I only need the first record.
How can I Limit the first query to have only the first record? In MySql I use LIMIT 1, but I don't know how to do that in App connect.
Or can I stop the repeater after 1?

You can use server connect data formatter and format the expression for the repeater to just return first or last record from your query.

Okay, that is cool. I never thought of using the formatter for this.
Thank you!

You are welcome.
One of the main purposes of Server Data Formatter is to be able to do this