Display of null foreign keys in LABKEY.QueryWebPart

LabKey Support Forum (Inactive)
Display of null foreign keys in LABKEY.QueryWebPart Jon (LabKey DevOps)  2015-01-27 14:10
Status: Closed
 
Hi Will,

I confirmed that anything you enter into that FK field will come back with the bracketed response when there is no matching value, like 123 coming back as <123>. So the only options are to either expect bracketed responses if you decide to fill in anything in the FK field or you just leave it blank. Beyond this, the only thing you could do to prevent anything from coming back is to have some custom javascript code to modify the UI to omit the response if it comes back with a value you want to hide. So if you went back to using zeros, your javascript would hide anything coming back that would normally display <0> in the response.

Does this make sense?

Regards,

Jon