Exclude using friendly_id?

Question

I want to run a controller query and exclude the current (self) record. I can use this:

Model.where.not(slug: params[:id])

That works fine until you manage to pass the record id.

Is there a cleaner more direct way to do this?

UPDATE

I clarified my example. I want to search where the id OR slug columns are not equal to the params[:id]. This also would have to chain after any normal scope or where query I run.

Vishal · Answer 1 · 2019-07-02T06:59:52.527

1

You can write this query

Model.where('slug <> :param_id or id <> :param_id', {param_id: params[:id]})

edited Jul 02 '19 at 06:59

answered Jul 02 '19 at 04:11

Vishal

7,113
6
31
61

I updated my question to clarify - I was not clear. – Dan Tappin Jul 02 '19 at 04:51
@DanTappin Updated my answer please check – Vishal Jul 02 '19 at 07:00

score 0 · Answer 2 · edited Jul 02 '19 at 07:00

0

You can use or:

Model.where.not(slug: params[:id]).or(Model.where.not(id: params[:id]))

Or you can rewrite your query:

Model.where('slug <> :param_id or id <> :param_id', {param_id: params[:id]})

edited Jul 02 '19 at 07:00

Vishal

7,113
6
31
61

answered Jul 02 '19 at 05:39

CAmador

1,881
1
11
19

Exclude using friendly_id?

2 Answers2