Log in to AnswerLog in to Follow
2022-05-02 13-46-21
Raffa Guerra
30Views
3Comments
How to remove duplicate items on the screen?
Question
Database

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?

0
0
14 Jun

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. 

0
0
14 Jun

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.

1
0
14 Jun

Replying to Raffa Guerra's comment on 14 Jun 2022 18:19:05

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

Shingo

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