Hi everyone, I'm quite stuck at this part so I'm needing some helps
I built an interface to show a report which data is from a view, the view looks like this table below:
The interface does not show updatedDateTime + Step (business requirement), and was filtered by loginUser(), which is why I got this result of duplicating rows with same case ID and other columns all have the same values in the report for the same case. Is there anyway I can get the unique row using Appian if there are duplicating row in the interface?
Discussion posts and replies are publicly visible
Hi mollyn126
Use union() function from where you are sourcing your data in the grid. Union will remove duplicates.use it like this - union (local!data,local!data)
Thank you :D
Note with the union() function you will have to retrieve extra data into your interface before filtering it out, which is not scalable. I would suggest utilizing Query Aggregation to group fields, which will eliminate duplicates from being returned altogether.