Hi Anthony,

We don't have an equivalent option for GlobalUniqueId aliases like we just added for participants.

I don't know the specimen schema well enough to suggest an existing column to repurpose. However, you might be able to load a side table with the mapping data, and then use XML-based metadata overrides to configure a lookup from the specimen queries to your extra data.

You'd need to configure the metadata in your side table such that the GlobalUniqueId is marked as the one key field (even if that's not the case in the underlying table itself). You'd need to have zero or one rows per GlobusUniqueId, or when you add the lookup column you'll get row multiplication.

Then, go to the schema browser and navigate to the specimen table. Click Edit Metadata in the upper right. Click the Alias Field button. Select the GlobalUniqueId column. Configure this wrapped column to be a lookup to your side table.

Then, you should be able to use Customize View to join in your alias column when you're looking at the specimen query.

Thanks,
Josh