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; } } }

Filter basierend auf aktuellen oder zukünftigen Daten in AGOL

RobbHodges

<\/HEAD>

Ist es möglich, einen Filter einzustellen, der Ausfälle anzeigt, die nach Datum noch nicht abgeschlossen sind? Wir haben ein Startdatum\/uhrzeit und ein Enddatum\/uhrzeit. Ich möchte die abgelaufenen Ausfälle ausblenden. Ich dachte daran, ein neues Ja\/Nein-Feld zu erstellen, nach dem ich filtern kann, aber ich möchte vermeiden, dass ein Benutzer das manuell eingeben muss. Ich möchte die Ergebnisse nach dem Abschlussdatum automatisch ausblenden. Ist das möglich?<\/P>

<\/P>

Danke!<\/P><\/BODY><\/HTML>

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

MikeMillerGIS

Oh, you need to modify the json that makes up the webmap manually, the UI does not allow you to specify this query. The AGO-Assistant can help. Just be careful, it is easy to mess the json up.

NilsBabel

Ok, thanks. One of my feature services I am in control of and know that the database is SQL Server and the fields are date fields. This one does show the date fields in the filter window. However it doesn't let me add an expression in the value field. Where would I add the expression above in a web map filter window?

Also, another feature service that I use but am not in control of has date/time fields but I'm unsure of what database format it is in. The date/time fields do not show up in the drop down in the filter window. Why would that be?

Thanks!

MikeMillerGIS

The syntax I provided above is for SQL Server and ArcGIS Online hosted data. If you use a different database, you will need to determine the syntax for that database, You will also need date fields so enable editor tracking is one way to get these.

NilsBabel

Does this only work with Hosted Feature services then? I have a feature service I have added to AGOL from a local ArcGIS Server. The date fields don't show up when I try and create a filter.

MikeMillerGIS

For Hosted services, if you allow non standard queries, you can use the sql server date syntax. Here is an example that will only show feature created in the last 30 seconds.

DATEDIFF(s,DATEADD(s,30,CreationDate),GETDATE()) < 0

RobbHodges

That should work, thanks! I think I was trying to over complicate it.

Anonymous User

Is there way to set a filter; using a date query of date>=5/1/2015, during the [create replica] process within the REST services of ArcGIS Online!?

russell_roberts

You can set filters on your layer and use dates in these filters like: Date "is not between" Date a & Date b. Or if you had a field that has the expired domain(yes/no) you can use that which might work for your setup if the expired date could be a different value for each feature on the map.

Hope this helps.

Russ

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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