Slick 3.2: Filtering on columns from left-joined table

Question

Given the following using Slick 3.2:

val contacts = TableQuery[ContactTable]
val phones = TableQuery[PhoneTable]

val query = contacts.joinLeft(phones).on(_.contact_id === _.id)

query.filter{ case (contact, maybePhone) => ... }

maybePhone is a Rep[Option[PhoneTable]]. How can I filter on its properties? (Something like maybePhone.contains(_.areaCode === "212").)

If you want to filter by the value of the column of the joined table, why do you use `leftJoin` (instead of inner join) in the first place? — SergGr, Oct 28 '17 at 11:08
Good question. I'm defining a generic base query that an API exposes for reuse. Some callers will not care about the left joined table or its values. Others will sometimes want to filter on it. — FullTimeCoderPartTimeSysAdmin, Oct 28 '17 at 12:39

score 2 · Accepted Answer · answered Oct 28 '17 at 07:39

2

Try mapping:

query.filter{ case (contact, maybePhone) => maybePhone.map(_.areaCode === "212") }

answered Oct 28 '17 at 07:39

Dmytro Mitin

48,194
3
28
66

1

That works! I don't know how I missed that. (Never code while sleep-deprived I suppose.) Thanks! – FullTimeCoderPartTimeSysAdmin Oct 28 '17 at 12:44
Thank you, I forgot to pattern match it and got a nasty type-error. Not it works! – catchergeese Nov 25 '18 at 21:01

Slick 3.2: Filtering on columns from left-joined table

1 Answers1