How to remove duplicate items on the screen?

Hello guys!

On my screen that lists a user's books, a triplicate book is appearing.

In the database there is only one record.

I identified in the Get do Aggregate that because there are three rows in the CatalogoSistematico table, it ends up bringing three items and puts it on the list.

How can I resolve this?

Hi @Raffa Guerra ,

You can apply groupby to that particular aggregate's column from where you are showing your list. I hope it will work. Please let me know if you need any help. 

Somil I solved it! But now I'm a warning! At least I took a few steps.

Instead of doing a join or giving another GET I created a block and pass the book ID to the block. Inside the Block there is an Aggregate that filters by the book ID.

At least for now it's working, lol.

In this case, I agree with @Somil Nagar that "group by" is a good choice. 

You can inspect your web app, and you can find a lot of server calls to get data (each block will call once)

Thanks and best regards


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.