×
labkey.org will be offline for maintenance on Thursday, November 6th @ 5:30pm Pacific Time. The site will be offline for approximately three hours. Please save your work before this time. We apologize for any inconvenience.

Is it possible to replace the LABKEY.Filter.Types.IN filter on a query with a parameterized query instead?

LabKey Support Forum (Inactive)
Is it possible to replace the LABKEY.Filter.Types.IN filter on a query with a parameterized query instead? Jon (LabKey DevOps)  2015-10-21 13:00
Status: Closed
 
Hi Leo,

I think I understand what is going on.

If you have a query that is parameterized and requires values, then yes you can have parameters for your QWP as well if you need it to pass parameters to it automatically rather than requiring the user to input them in.

So your second example would be correct:

                    qwpResponse = new LABKEY.QueryWebPart({
                        parameters: <blah>,
                        queryName: responseParameterized,
                        schemaName: 'study'
                    });

So <blah> would have to be coded as:

{'fieldname': 'value', 'fieldname2': 'value'}


Please refer to our docs here for more information and an example API call that uses the QWP:

https://www.labkey.org/wiki/home/Documentation/page.view?name=paramsql

Regards,

Jon