Hello,
I have a sample set with many rows of data and only 1 or two of the flags are set on all of these rows. However, whenever I select the data through rlabkey with the standard selectRows call, all of Flag values are set to something like this:
urn:lsid:fhcrc.org:Sample.9.Homologue:MSSR00001
Is there a reason for this? Is there a way for selectRows to simply return an empty string if the field is actually empty on my labkey server?
Thanks!
Hector |
| |
| Steve responded: |
2016-09-16 10:48 |
Hi Hector:
I don't know off the top of my head why the 'flag' column has lsid values -- I'll look into this.
But you might try working with 'flag_comment' column as an alternative. It is a string column, which defaults to the empty string, unless you actually flag a record and add some text.
- Steve |
| |
| Jon (LabKey DevOps) responded: |
2016-09-20 13:49 |
Hi Hector,
The Flag value is tied to the LSID so it can identify itself to the sample set row in question.
The way it identifies itself as being flagged (turned on) vs unflagged (turned off) is whether there is a comment made or not.
If you run your selectRows query to look at 'Flag/Comment' on the Sample Set table and specifically look for an empty string, that will show you the Sample Sets that are not flagged.
Does that make sense?
Regards,
Jon |
| |
|
|