There is a field listed in the specimen archive format documentation called parent_specimen_id. I'm looking for a way to show that one vial came from another vial. For example, a vial of blood cells was sorted into several vials which contain CD4, CD8, etc. I would like the CD4 vial information to have a link to the original cell vial. Parent_specimen_id seemed promising, but it's numeric, which means I can't put a global unique id in there. Is it meant to have some internally generated key instead?
I notice there are also text fields for unique_specimen_id and other_specimen_id, and it's not really clear to me what these are for either.
Is it possible to do what I'm trying to do? And if it is, could you point me towards the right field(s) to use?
Thanks so much,
Jen |
| |
| jdutra responded: |
2012-07-24 08:24 |
I've just been looking at this again. I went through all the specimen datasets listed in the schema browser, and I can't find this parent_specimen_id field anywhere. If anyone could give me some additional information about it I'd really appreciate it. |
| |
| Dave Bradlee responded: |
2012-07-25 15:21 |
Hi,
There is nothing special about any of those fields. They are fields that some, but not necessarily all, customers need for their specimen data. LabKey does not assume any particular behavior and thus you could use any of those for your own purposes. But of course, it would be up to you to do something with the field. For example, you could use parent_specimen_id to hold the record_id of a specimen or use other_specimen_id to hold a global_unique_id for another specimen. But you wouldn't be able to click on parent_specimen_id, for example, and navigate to that row in a table.
Hope this helps.
Dave Bradlee |
| |
| jdutra responded: |
2012-08-14 12:28 |
Hi Dave,
Thanks for your input. The big problem I'm having at this point is that I can't find any of these fields. For example, I've decided to put the GlobalUniqueID for a linked specimen into the other_specimen_id field (as listed in the help). I checked my inventory.specimens file, and I have the ids right where I want them. But after I import, I can't find the data or the field anywhere. The table on the help page ( https://www.labkey.org/wiki/home/Documentation/page.view?name=specimenArchiveFileFormat) says that other_specimen_id is an attribute of "Event". So I looked for it by clicking on the history of the specimen, but there's nothing there. I tried customize view on the history screen to see if that field was not included in my default view, but didn't find it there either. I went to the schema browser and looked at the field lists for all of the specimen tables, but still didn't find it. Could you point me in the right direction so that I can get to this field and use it in a query or custom view?
Thanks so much,
Jen |
| |
|
|