Maybe it´s a basic question, but i´m getting confuse how to do this. I have one hosted feature layer from Survey123 to collect asset numbers in the field (barcode or qrcode from Rooms and Spaces on my Campus University), It´s working fine.
Sometimes I got duplicate asset numbers and it´s normal because the equipment was moved to another room. Here a sample.
I built a simple app using WAB to show the collected record, that´s ok I can see all assets per room. But I need to show only one unique asset number (the latest one) in case of duplicate numbers.
Using the query widget it´s impossivel to create a query using Select Distinc based on field latest_edited_date.
So, any suggestion how to create this query on WAB or another way?