You can create a database query which returns a single record. That’s really useful in cases where you filter your data and expect a single result to be returned, like retrieving the logged in user info - so no complicated repeats are required.
In this tutorial we will show you how to filter a Single Query and use the result directly in the rest of the Server Action steps.
We created a server action, which is going to be used for retrieving the logged user details, so we already added the standard database connection and security provider steps:
Right click the Security Provider step, open Database Actions and select Database Single query:
Configuring the Database Single Query is identical to configuring a regular database query. Just click Query Builder:
Add the table you want to query and then add the columns you need:
Setup your filters. In our case we filter the user ID by the Identity returned by the Security Provider step:
Click OK when you are done.
You can access the Single Query results in any Server Connect step, added after it. In the following example, we have a send mail step and we can directly bind the query results in the mail body:
Click the Dynamic Data Picker button:
And you will see the Single Query bindings available in the picker:
You can use them wherever you need them, without using any repeaters as the Single Query only returns a single record.