Filtering for predefined named sets not working within Copy Number detail view

[lehnerchristian]

@zichner commented on Wed Oct 11 2017

Release: dev

Steps to reproduce

1. Open list of all cell lines
2. Select A549
3. Open Copy Number detail view (-> Copy number values are shown)
4. Filter detail view by Predefined Named Set normal chromosome protein coding human genes
   -> No copy number information is shown

I guess this is due to a bug in the SQL statement:

SELECT d.ensg AS id, d.relativecopynumber AS score 
FROM cellline.tdp_copynumber d 
INNER JOIN cellline.tdp_cellline s ON d.celllinename = s.celllinename 
INNER JOIN public.tdp_gene g ON d.ensg = g.ensg 
WHERE g.species = 'human' 
AND d.celllinename = 'A549' 
AND d.celllinename = ANY(ARRAY(SELECT celllinename FROM cellline.tdp_panelassignment WHERE panel = 'normal chromosome protein coding human genes'))

The last part should filter genes but is filtering cell lines.

Please check again the code that builds the SQL queries very thoroughly to avoid these kind of bugs (the SQL queries are one of the most crucial parts of the application).

PS: Interestingly, filtering for predefined named sets is working in the Combined View. However, shouldn't both SQL queries be almost identical?