ORing textacular scopes with other queries about textacular HOT 6 CLOSED

I'm not sure what you've tried, but the query objects returned by Textacular's methods should play nicely with the tools available from ActiveRecord for this kind of thing. I found some discussion of this on Stack Overflow that might be helpful.

from textacular.

Here's as close to it as I've got:

scope :with_id, ->(id) {
  where(id: id)
}

Then

search = Linguist.basic_search('1234')

Linguist.select(search.select_values).where(
    Linguist.with_id('1234').where_values.first.or(search.where_values.first)
).order(search.order_values)

It gives roughly the sql I need, but it is choking on this bit:
WHERE (("linguists"."id" = 1234 OR 'to_tsvector(''english'', "linguists"."title"::text) @@ plainto_tsquery(''english'', ''1234''::text) OR

with the error

PG::InvalidTextRepresentation: ERROR: invalid input syntax for type boolean:

Perhaps you could shed some light as to why this would be happening?

from textacular.

I'm outside my previous experience, here. Anyone else have a better grasp of how AR's or is meant to be used?

from textacular.

Good question. I also stumbled across this problem. For now I use the workaround which is not very beautiful.

if query =~ /^[0-9]+$/
        search_criteria[:id] = query.to_i
      end

      result = result.advanced_search(search_criteria, false)

I need this to also search the ID of the record which is of course an Integer and not searchable using textacular.

For me it works. I also search by id. The where clause of generated SQL expression:

WHERE (to_tsvector('russian', "ads_in_list"."short_description"::text) @@ to_tsquery('russian', '70616:*'::text) OR to_tsvector('russian', "ads_in_list"."long_description"::text) @@ to_tsquery('russian', '70616:*'::text) OR to_tsvector('russian', "ad_contacts"."phone"::text) @@ to_tsquery('russian', '70616:*'::text) OR to_tsvector('russian', "ads_in_list"."id"::text) @@ to_tsquery('russian', '70616'::text))

I hope I will find a proper solution in the future.

from textacular.

Thanks for this, not ideal, but a decent hack!

from textacular.

Since there's a workaround and I don't understand this very well, I'm going to go ahead and close this.

from textacular.