Just posted a question about room in stackoverflow...

# android

[Joan Colmenero]

Just posted a question about room in stackoverflow, it's about an M:N relationship, if you know or have worked with it, please ping me, I'm seeing that I'm almost done but I need my last clarification. Thanks!

[Dominaezzz]

Link?

[Joan Colmenero]

Send it to you

[Dominaezzz]

Haven't used Room in a while. Not sure if M:N is now supported. You may have to manually write the query.

[Dominaezzz]

I ask for the link so other people could easily look it up.

[Joan Colmenero]

Easier question then, I have inside my Entity an object that is a List<String> so I need to do a query to check if X is inside that list, how can I do it?

[Joan Colmenero]

I've found this https://stackoverflow.com/questions/44986626/android-room-database-how-to-handle-arraylist-in-an-entity but also is there a @Embeded thing...

[Dominaezzz]

The version of sqlite shipped with android can't handle surgical queries on a column. You'll have to move that list into another table and do JOINs and WHEREs.

[Joan Colmenero]

i'm usin room

[Dominaezzz]

Which uses sqlite underneath.

[Joan Colmenero]

Then how can I do the query to that list?

[Dominaezzz]

Look at Option #1 of the voted answer.