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 |
||