I'm trying to filter a layer in ArcGIS Online so that it only displays the features with the next upcoming date. I'm able to successfully do this in ArcGIS Pro with the following SQL code:
date = (select min(date) from TABLE_NAME where date > current_date)
Date is the stand-in for the column name and table_name is the layer name in the database. I want to do this same thing in ArcGIS Online Assistant by editing the JSON. However, whatever I try doesn't seem to work, and I think it is because I can't find the correct table name. Does anyone know where I can find this so that my expression will work? Or is there another expression that I can substitude so that I won't need the layer name?
