Array to String in Server Connect

[sbecks]

So I’m looking to add a csv export button on a page. The server connect file for the page uses a repeat to get 2 sets of nested data. I’m struggling with getting the nested elements to collate as a comma separated string for the csv export.

There looks to be 2 options, and the most likely seems to be creating a temp table to add the export data to and then retrieve it for the export. The other combining csv files of each query.

I’ve tried a few iterations to get the data in the temp table, the issue is joining the programmes/permissions into a string to insert into a single column in the db which keeps returning an array to string conversion error.

Here’s a couple of examples of what I’ve tried taken from other posts across the forum.

Taken from here:

Fetching user roles on client side

Bumping this post just in case there are others who wants an alternative to @jowhiskey’s solution. Instead of creating another column for the “collective” permissions, we can create an array in Server Actions Step to “join” all the permissions as “comma-separated” so we can get it as a string. And on the page, we can do the “contain” filter to be used in the conditional region. Server Actions: [image] Don’t forget to check on the “output” button so it will return back the result to the page…

I’m sure it’s a simple solution but I can’t see it for looking at the moment! Can anyone point me in the right direction?

Thanks!

[sbecks]

After quite a lot of trial and error I’ve got this working.

The circled step returns:

as the value for permissions which I can then insert in the field in the export table.

This isn’t possible with the UI pickers it gives the line underneath labelled ‘permissionsUI’ which returns empty…

This means I can now export a table like this:

Into this in Excel/csv: