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 |
Josh,
Thank you for the reply. I've got this working; the SpecimenDetails.GlobalUniqueId has been wrapped (alias-ed) as an additional column with custom XML to create a FK to Samples."Study Specimens". When I'm looking at the DataGrid for the SpecimenDetails query I can now bring in other columns from the Sample Set (this is where we've decided to add the 'customerId' alias for the specimen).
However, this new wrapped column is not available through the drill down from the SpecimenID column from the assay results DataGrid or from the study dataset once the assay results have been copied to the target study.
How can I achieve this functionality?
There seems to be some disconnect between the study module's Specimen and the experiment module's Samples. Though a 'shadow' sample is created for each study specimen there is no generic linkage between the two the allow automatic fk lookups between the Vail.GlobalUniqueID and the Samples."Study Specimens".Name
I understand that the target study also plays a role in resolving this lookup and it really is a composite key from an assay results table. Would it be possible to add in to the SpecimenID lookup that currently exists a way to get the to Sample."Study Specimens" and bring in the columns from that sample set? This would be a great generic and flexible option to place any additional metadata about the Specimen/Sample.
Thanks,
Anthony |