LABKEY.ext.Store and filters

LabKey Support Forum (Inactive)
LABKEY.ext.Store and filters Leo Dashevskiy  2013-01-11 15:26
Status: Closed
 
Updated example that uses slashes for the query column names:

var strFilteredTable = new LABKEY.ext.Store({
            autoLoad: true,
            schemaName: 'flow',
            sql: 'SELECT DISTINCT FCSFiles.Name AS "File/Name" FROM FCSFiles WHERE FCSFiles.Run.FCSFileCount != 0 AND FCSFiles.Run.ProtocolStep = \'Keywords\''
        });

then try filtering on some file name values:

strFilteredTable.setUserFilters([LABKEY.Filter.create("File/Name", "file1.fcs;file2.fcs", LABKEY.Filter.Types.IN)])

strFilteredTable.load()


For the old server, it works, and for the new one it does not (as of 1/16, revision 24056)!