Hi,
I'm trying to edit specimen properties, and I'm running into some problems. I have two questions:
1. I set up a new column on both the Specimen Event and Vial tables, and I made it an integer lookup. This doesn't work - in the "Edit Specimen Properties" area, both columns look like lists. However, when viewing specimens, the integer is displayed, and in customize view this new column has no plus sign to indicate that it's a lookup. I tried this using a list for the lookup and also using a study dataset for the lookup, with the same results.
2. Is there any way to add a column on the Specimen (or "draw") table? I would like to add an additional additive type, say "additive2" where vials that have different values for "additive2" have separate rows in the "grouped vials" view, but I can't find a way to do this. Is it possible?
Thanks for any help,
Jen |
| |
| Dave Bradlee responded: |
2014-05-30 15:15 |
Hi Jen,
On question (1), this looks like a bug. I added lookup columns as you suggest and it's not displaying the lookup's "label" and if I try to edit that specimen I do not get a dropdown as I would expect.
On Question (2), this is not possible. The determination of which vials are grouped into a specimen is fixed. (Generally these are the fields for types, ptid and the draw timestamp and maybe another). There is no way currently to specify which fields are considered for this grouping. You can add a field to Specimen, but it can only get populated via one of the new rollup rules we defined (CountOf or SumOf), so they are fairly limited.
Thanks.
Dave Bradlee |
| |
|
|