Hi Olivier,

Yes, you can create a custom SQL query to do this, specifically applying a WHERE clause in your SQL statement and then you would use that query as the lookup target. You will also have to set the XML metadata to mark the primary key from the underlying table as a key field for this to work.

Take a look at this previous message board post from another user that has an example of the XML metadata and how to modify it for guidance.

https://www.labkey.org/announcements/home/Server/Forum/thread.view?entityId=49c0dcf1-8ccc-1031-abc2-6432661daa52&_docid=thread%3A49c0dcf1-8ccc-1031-abc2-6432661daa52

Let us know if you have any further questions.

Regards,

Jon