Lookups/Links to primary key/normal values in SQL queries | max diesner | 2020-08-24 02:36 | |||||||||||||||||||||||||||||||||||||||||||||
Status: Active | |||||||||||||||||||||||||||||||||||||||||||||||
Hi, we have no for some time a community edition labkey server running in the lab and it is just awesome. I have recently setup some SQL queries for keeping track of our Lab inventory which is also working quite nicely. However there is a minor thing that keeps bugging me. The resulting query table does not copy automatically the lookup/ Text link for a certain value from the underlying table (list). I checked the documentation and it states that you can easily get this done by applying the lookup through the Metadata properties. Thus, i accordingly changed the column to a lookup from the appropriate underlying column. I also checked the Metadata code and can see that the appropriate <fk></fk> part has been added to the metadata code. Nevertheless the resulting table still does not show the appropriate text links. Do you need to check some option that i am missing or does the LEFT JOIN statement in the SQL code overrides any potential lookups for certain values? I am trying to connenct primary keys for your information. When i am referencing from a table where the value is already a lookup it is copying the textlink right away. I am looking forward to hear from you! Cheers Max |
|||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||