nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Selecting dates with Query widget

AndrewNiederhauser1

Is there a way with WAB DE 2.6 - 2.8 to set Query widget options for "Today", "Yesterday", "Last Week", etc? When a user selects today, the widget would pull the current date and query based on that value vs. having the user choose the specific date(s).

Thanks,

Andrew

Najděte více příspěvků označených jako

Accepted answers

All comments

AndrewNiederhauser1

and I feel silly now b/c I can easily see it's enabled via REST endpoint on the service used.

Use Standardized Queries: true

AndrewNiederhauser1

Robert,

We're using SQL Server 2008 R2 with ArcGIS Server 10.3.1. Reviewing the link below and our system (screenshot below), it appears we have standardized queries enabled.

About standardized queries—Documentation (10.3 and 10.3.1) | ArcGIS Enterprise

Thanks,

Andrew

rscheitlin

Andrew,

What is the underlying database or data source for the layer you are trying to query. Does that service have standardized queries feature enabled.

AndrewNiederhauser1

Adrian,

It appears this is already available in the widget by setting the "in the last" operator. However, I'm getting a "Query failed!" response even thought my data includes records with dates in the last 24 - 48 hours.

AdrianWelsh

Andrew,

That's a good question. I wonder if you could have a drop down list that has these options (today, yesterday, etc.) and the underlying code could spell out the actual query.

I found this stacked exchange page that lists a few options on how to get dates like this that might be helpful:

sql server - SQL statement to select all rows from previous day - Stack Overflow

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.