Curious to know about LABKEY.Filter

LabKey Support Forum (Inactive)
Curious to know about LABKEY.Filter Leo Dashevskiy  2013-05-28 12:29
Status: Closed
 
Hey, guys!

So how does it work exactly? The filtering itself happens on the server side, of course, right? And does the LABKEY.Filter.create() statement get translated to an appropriate SQL statement/command, so that the filtering is handled by the db system or is the mechanism somehow different?

In other words, would there be a difference in performance if I was to use LABKEY.Filter approach vs. a pure SQL approach?

Thanks.
-Leo
 
 
Matthew Bellew responded:  2013-05-28 12:35
The filter gets translated into SQL and executed. There should be no difference writing in SQL or using the Filter methods. Filter is provided to mimic the behavior of the UI and URLs, and sometimes it's more convenient to use programmatically than writing SQL.
 
Leo Dashevskiy responded:  2013-05-28 12:43
Thanks!