Using parameter in lookup column

LabKey Support Forum (Inactive)
Using parameter in lookup column Ju Yeong Kim  2017-10-20 16:28
Status: Closed
 
Is it possible to use parameters in lookup column?

For example,

```SQL
PARAMETERS(groupLabel VARCHAR DEFAULT 'mice')
SELECT participantid.groupLabel
FROM Demographics
```

where participantid.mice exists
 
 
Ju Yeong Kim responded:  2017-10-20 16:33
error message:
```
Error on line 2: Unknown field [Demographics.participantid.groupLabel]
```
 
jeckels responded:  2017-10-20 16:47
No. Parameters can be used in place of static strings or integers that would otherwise be embedded in the SQL, but not to swap out identifiers like table or column names.

Thanks,
Josh