Home > Forum > Tips&Tricks > Exporting SQL data rows from within the designer studio

Exporting SQL data rows from within the designer studio
3

MVP

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

Nobody has replied in this thread yet.
Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings