Issue with lookup to a query

LabKey Support Forum (Inactive)
Issue with lookup to a query katy wiseman  2024-05-16 09:35
Status: Active
 

Hey,

I've been trying (and successfully managed before) to set a lookup in a sample table to point to a query.

I've set my "group_id" column in my query as the key field:

   <column columnName="group_id">
    <isKeyField>true</isKeyField>
  </column>

And then gone to my sample table and made my lookup field and successfully chosen my query as the target table and pressed save.

However, it just hangs when I try and add a row and when I go back in to the table design it tells me that my query table doesn't exist:
Current Folder > samples > mixcr_output_paired_metadata_grouped . Error: Lookup target table does not exist.

I'm not sure where it's going wrong. Any ideas?

Best,

Katy

 
 
mohara responded:  2024-05-16 11:15

Hi Katy:

What version of LabKey are you using? I wonder if you are hitting this issue, which was fixed in version 24.3, as well as maintenance release 23.11.11.

Issue 49511: Setting lookup to custom query shows "Error: Lookup target table does not exist."

In addition, if you're on any version lower than 23.11.11 now, you should upgrade to the latest maintenance release of either 24.3 or 23.11 as soon as possible because of the security update described in this other post.

--Molly

 
katy wiseman responded:  2024-05-17 00:42

Hi Molly,

Thank you! It looks like we're on a lower version. IT are going to love me... I'll let you know if it fixes it!

Best,
Katy