SQL javascript API How to quickly delete all rows in a list and/or create temporary tables/lists to do SQL Operations

LabKey Support Forum (Inactive)
SQL javascript API How to quickly delete all rows in a list and/or create temporary tables/lists to do SQL Operations dabaker3  2018-10-24 11:23
Status: Closed
 
• Using Rstudio worked client side, and I can convert that code to Javascript.
         • One issue I ran into was with filtering there is a PostgreSQL limit on an "IN" or "NOT IN" of ~2000 items, in which I would have to programmatically disable the filter. An SQL INNER JOIN would have alleviated this limit, but I will go with the javascript solution instead.