Exporting SQL data rows from within the designer studio

3

Hi everyone,

I just had the need to get multiple rows of data without having access the the SQL database. I didn't want to create a field for this one time use case. Unfortunately the 'Test' result window of the expression editor, didn't have the option to copy the result.
Luckily I thought of the Administration Tools\Search Logs. As you can see in the attached picture, I was able to execute an arbitrary SQL statement and could export the result to Excel. :)

Best regards,
Daniel