topic Filter records based on the time they were created in Mapping Questions

Filter records based on the time they were created

Jon_Tait — Tue, 19 Jan 2021 09:45:32 GMT

Hi. I have a Survey123 used by the public to make complaints about noise from industry. I'm using that data to populate a dashboard so the enforcement officer can assess the results. The officer would like to only see those records created at nighttime (between 23:00 and 07:00). Is there a way to filter the records in the web map to show only those records?

I have a CreationDate filed which includes the time but I don't seem to be able to filter against this, only by the date they were created.

Thank you

Jon

Re: Filter records based on the time they were created

Anonymous User — Thu, 21 Jan 2021 06:05:34 GMT

Hi Jon,

A screenshot of your attribute table structure, and your dashboard configuration of this service would help with troubleshooting.

This should be a straight forward filter to apply, so it may require a bit of digging to figure out where the problem is 🙂 It could be that the field you want to filter on isnt the correct field type - id check first that this is a standard date field. Another option is to make this service time enabled, and register that field as a time enabled field.

Let me know how you go 🙂