Showing Most Recent and Unique Values

169
1
03-22-2019 02:48 AM
Luiz_AmadeuCoutinho
Occasional Contributor III

hi guys

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?

Thank you. 

0 Kudos
1 Reply
Luiz_AmadeuCoutinho
Occasional Contributor III

Anyone? :( 

0 Kudos