Untitled

mail@pastecode.io avatar
unknown
plain_text
11 days ago
945 B
1
Indexable
Never
=QUERY(dataset,"Select * where
A > 1 AND 
C contains '"&c_event&"' AND NOT C contains '"&c_event_e&"' AND
D contains '"&c_map&"' AND
E contains '"&c_team&"' AND 
X > date '"&TEXT(DATEVALUE(
IF(ISBLANK(c_date1)=TRUE,"2020-01-01",c_date1))
,"yyyy-mm-dd")&"' AND
X < date '"&TEXT(DATEVALUE(
IF(ISBLANK(c_date2)=TRUE,"2050-01-01",c_date2))
,"yyyy-mm-dd")&"' AND 
(V contains '"&ci_1&"' AND V contains '"&ci_2&"' AND V contains '"&ci_3&"' AND V contains '"&ci_4&"' AND V contains '"&ci_5&"' AND W contains '"&ce_1&"' AND W contains '"&ce_2&"' AND W contains '"&ce_3&"' AND W contains '"&ce_4&"' AND W contains '"&ce_5&"' AND NOT V contains '"&cfe_1&"' AND NOT V contains '"&cfe_2&"' AND NOT V contains '"&cfe_3&"' AND NOT V contains '"&cfe_4&"' AND NOT V contains '"&cfe_5&"' AND NOT W contains '"&cee_1&"' AND NOT W contains '"&cee_2&"' AND NOT W contains '"&cee_3&"' AND NOT W contains '"&cee_4&"' AND NOT W contains '"&cee_5&"')
AND NOT V = W
",0)
Leave a Comment