Hi Ben,

I don't think there's a great solution at the moment. Your implementation looks reasonable for smaller sets of rows.

I don't think that LABKEY.DataRegion has an API for getting the current filter, but if it did you could potentially use it to call LABKEY.Query.selectRows(). It wouldn't have the DISTINCT performed server-side, but it would give you the right set of rows. This might be a viable solution assuming the number of rows isn't too huge.

I don't have any great ideas on how to support the DISTINCT case without a fairly specific API, but will think about it.

Thanks,
Josh