possible to join a regular query to a parameterized query, applying params?: /home/Support/LabKey Support Forum

possible to join a regular query to a parameterized query, applying params?

LabKey Support Forum (Inactive)

View Message

possible to join a regular query to a parameterized query, applying params?

Ben Bimber

2013-04-05 11:19

Status: Closed

I have a fairly complicated parameterized query written in labkey sql. this query accepts 2 numeric parameters. There are 2 ways this query is used.

1) run directly by user, where the user inputs the params (working fine)

2) we have a second table where we have cached expected values for PTIDs. it would be really convenient to join this table to my parameterized query, in order to apply these default values to that query. i dont see any way that this would work though. is there any way to accomplish this?

The alternative is to duplicate my complicated SQL query into a parameterized one and a non-parameterized one. just trying to avoid that.

Thanks in advance for any help.

Matthew Bellew responded:	2013-04-08 10:30
The outer query with the joins should inherit the parameters of the inner query. Are you using 12.3 or the 13.1 development branch? It's possible that the fix for 17036, broke this in some cases.