Query JSON with SQL - Cleaning Null nested values

Queries and Resources
1

Does anyone know how to clean the resulting JSON from grouping when using the Query JSON with SQL?

I am have got a slick calendar going using two nested collections. However, days that don't have an event are showing a blank list item because of the null values in the nested JSON.

Is there a way to clean these.

 select datestr, array(@{ShowName:ShowName,StartTime:StartTimeStr,ShowID:ShowID, FileStorageID:FileStorageID}) as Shows
    from {{getDays.data}} 
   
    group by datestr

image

2

Can you try WHERE ShowName IS NOT NULL ?

3

No. It just gives me an empty dataset