How to export a partly loaded reference field to Excel

Tags: not added yet

If you want to export Down/Up (Incoming/Outgoing) references of the items, then see:

How to export all (Down-Up-In-Out) references of the items to Excel

The attached Excel example template solves a problem that the reference-fields of the export items are might not be fully loaded during export so some of their properties might be missing.

In this example we want to show the reference field which is in the "versions"/Releases field. The template uses a Manager call to fully load the "versions" and prints out its properties.

This template will always load the HEAD revision even when the reference field points to an earlier version:

template.xlsx

This second template does the same, but keeps the correct version of the reference field: for example if the "Releases" field points to an old version of a Release then this version will be loaded correctly:

templateWithVersions.xlsx