Hi Leo,

I've done this sort of thing before (minus R) and it is possible. I think the general approach is to work with the DataRegion, rather than the QWP itself. The QWP has a reference to the DataRegion (probably this.dataRegion, although I dont know for certain). LABKEY.DataRegion has some JS doc on available methods, but you should be able to use this to change sort, filter, etc.

There is probably a success callback on QWP, which would allow your code to act once the DataRegion loads. DataRegion also has some events for filter change, etc., which might be useful for your situation.

Thanks, Ben!

Yes, I saw the DataRegion API, but it was confusing to me how to use it.
I still cannot quite figure it out. Would you have an example on how to use it along with a QueryWebPart?

Thanks.
-Leo

Hi Leo,

I normally get the DataRegion with the getDataRegion function that belongs to the QWP (though isn't on the API docs).

var wp = new LABKEY.QueryWebPart({..});
var dataReg = wp.getDataRegion();

then e.g. current filters

    var filters = dataReg.getUserFilterArray();
    Ext4.each(filters,function(filter){
        var col = filter.getColumnName();
        var type = filter.getFilterType().getDisplayText();
        var val = filter.getValue();
        
        console.log('Filtering ' + col + ' with condition:' + type + ' ' + val);
        
    });

Though, playing around. This doesn't appear to return filters when the data has been filtered with view, customize view UI. And neither is sort info return with dataReg.getUserSort()

I discovered you can fetch the sort info with the qwp object: wp.userSort. Which returns a comma separated string of all the columns you are sorting by. But again, not when using the customise view UI - I'm not sure how to get that info..

Anyway, not sure if that helps any.

Ok, yes, getUserFilter() and getUserFilterArray() are the 2 pieces of API that seem to return what I need.

Thanks.