Date Based Filter Conditions different on Hosted vs Referenced Data

[phess_luckstone]

I have noticed that Data based filter conditions are different on hosted vs referenced data.

https://doc.arcgis.com/en/dashboards/11.1/get-started/date-based-filter-conditions.htm

On a hosted item I can select a date within the last x days.

However on a referenced layer that comes from our enterprise geodatabase I am not able to select that.

Any ideas on how to enable this on referenced layers or get to work?

Thanks!

[ChrisUnderwood]

Hello @phess_luckstone , the ability to use "in the last" type Filters with Referenced data, will depend on the RDBMS that the data is referencing to allow that sort of Query. What sort of database & version etc is your layer referencing ?

[phess_luckstone]

Hey @ChrisUnderwood sorry for the delayed response, our referenced layers are coming from our Enterprise Geodatabase, its an Azure SQL database, the geodatabase version is 10.9.0.2.8, our portal version is 11.1