Looking for an equivalent to 'SELECT column_name WHERE IN' for beast mode.

Is there a Beast Mode equivalant for this SQL? Can Beast Mode even accomodate something like this?

 

select * from TABLE
where ResolvedBy in
(select distinct ResolvedBy from TABLE
where AssignmentGroup = 'IT Ops T1 Tickets'
and ResolvedBy != '')
and AssignmentGroup = 'IT Ops T1 Tickets'
order by ResolvedBy asc;

 

I know it can be done in a DataFlow, but I was told that Beast Mode can take pretty much any SQL scenarios. However, I have yet to figure out, or determine if the above is possible.

Comments

  • Would a series of CASE statements or nested CASE statements do the trick?

  • It looks like this could be done with 2 filters on the card

    1. 

    Place the `AssignmentGroup` field in the filters section and select 'IT Ops T1 Tickets'

     

    2.

    Place the `ResolvedBy` field in the filters and select the "not in" option and then the null box

     

    (if the second filter doesn't work then you may need to use a beastmode to highlight the null values)

    CASE WHEN `ResolvedBy` = '' THEN 'none' ELSE IFNULL(`ResolvedBy`,'none') END

    then you can place this beastmode in the filter and select not in "none"