topic Re: Dashboard Date Selector with wrong time in ArcGIS Dashboards Questions

Dashboard Date Selector with wrong time

RoseZhou2 — Tue, 17 May 2022 20:53:51 GMT

Hello,

I have a dashboard with a Date Selector (type=Advanced). Please see the screenshot below.

When select "Past 14 days", from web browser's Developer's tool, I found it queried the date range more than 14 days. For example if I select it at 4:45 pm EST, May 17th, the "where" clause is:

date <=timestamp '2022-05-17 21:45:10' AND date >=timestamp '202-05-03 04:00:00'

It's more than 14 days! I have another web map with filer set: 'date in the last 2 weeks'. This web map queries exactly 14 days, from date <=timestamp '2022-05-17 21:45:10' AND date >=timestamp '202-05-03 21:45:10'.

The dashboard and the web map return different result due to different query time period. How to make those two consistent?

Rose

Re: Dashboard Date Selector with wrong time

RoseZhou2 — Tue, 17 May 2022 22:41:24 GMT

By the way, I am using ArcGIS Enterprise version 10.8.1 Portal built-in dashboard.

Rose

Re: Dashboard Date Selector with wrong time

RoseZhou2 — Wed, 18 May 2022 20:30:44 GMT

For those may encounter the same issue, I have found a solution.

In the feature layer within the web map, I used following definition query before:

date BETWEEN CURRENT_TIMESTAMP - INTERVAL '14' DAY AND CURRENT_TIMESTAMP

After I changed to following, it’s working:

date BETWEEN CURRENT_DATE - INTERVAL '14' DAY AND CURRENT_TIMESTAMP

Rose