nonWorkDays collection not showing up in exported reports

[tibormolnar]

Hello,

I need to be able to export the list of "Exceptions" (i.e. public holidays) for each of our schedules. So I've created a report on Schedules that includes the following column:

displayname=nonWorkDays
listdelimiter=,
listmethod=nested(nonWorkDays).lists
textmode=true
type=iterate
valueexpression=CONCAT(STRING({nonWorkDate}),if(isblank({scheduleDay}),'','#'),STRING({scheduleDay}))
valueformat=text

This works like a charm on the screen, but as soon as I export the report data, the nonWorkDays column is empty.

I've tried using another listdelimiter, changing valueformat to HTML, and also replacing the valueexpression with valuefield=nonWorkDate (for simplicity), still no joy.

If I create a project report and include the collection of the tasks, as follows, the collection is included in the export file:

displayname=Project Tasks Names
listdelimiter=<p>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valuefield=name
valueformat=HTML

I wonder what I am doing wrong.

I appreacite any help or ideas.

Thank you,

Tibor

[skyehansen]

It might not be you doing something wrong. Some collections just don't seem to download! When this happens to me, I do try all the valueformats I know about, and then just submit a ticket to Support asking if the data is supposed to be able to be downloadable too (if you're an authorized support contact) -- they are pretty good at helping out with that sort of thing.

[GrahamSp2]

Did you ever find a solution for this? I need to do the same. I even tried to access via Custom API module in Fusion and I cannot seem to access this data.

[KristenS_WF]

I had the same issue with the nonWorkDays collection not exporting.  I played around a bit in Fusion, and I think I made it work (I haven't actually tried using the data for anything yet, but I seem to be able to pull it).

I created a test schedule in our Sandbox Preview environment and added one holiday exception: 10/10/25.  I then added a Custom API Call module in Fusion, requesting to see the nonWorkDate field and using the schedule ID in the query:

It gave me this result:

Hope this helps!