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

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

Can you give us some more details as to what you're looking to do here?

The LABKEY.Filter.Types.IN is the equivalent of an OR operator in SQL, using semi-colons to separate the values you're looking to find within the specific column you're running the filter against. Are you trying to use the LABKEY.Filter.Types.IN filter as a parameterized query like this?

<script type="text/javascript">

var myFilter = LABKEY.Filter.create('Language', 'English;German;Spanish', LABKEY.Filter.Types.IN);

LABKEY.Query.selectRows({
    schemaName: 'lists',
    queryName: 'People',
    success: onSuccess,
    filterArray: [ myFilter ]
    });

function onSuccess(data)
{
    alert("Success! " + data.rowCount + " rows returned.");
}

</script>

Regards,

Jon