# Full-text search engine for associations w/ values

**URL:** <https://www.ruby-forum.com/t/full-text-search-engine-for-associations-w-values/153775>\
**Category:** Rails\
**Created:** [November 20, 2008, 11:33pm UTC](https://www.ruby-forum.com/t/full-text-search-engine-for-associations-w-values/153775 "2008-11-20T23:33:01Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jeffrey\_LSTaylor](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/ee7513/32.png) [@Jeffrey\_LSTaylor](https://www.ruby-forum.com/u/Jeffrey_LSTaylor)\
**Post date:** [November 20, 2008, 11:33pm UTC](https://www.ruby-forum.com/t/full-text-search-engine-for-associations-w-values/153775/1 "2008-11-20T23:33:01Z")

</div>

I am looking for a full-text search engine compatible with Rails that  
can  
handle associations with a value in the join table with equality and  
inequalities. For example, database of items with searchable titles and  
descriptions and tags possibly with values:

“Hello” AND tag:release \<= 0.4 AND tag:due \< ‘2009-01-01’ AND  
tag:important

An item with “Hello” in one of the indexed fields, “release”, “due”, and  
“important” tags. The value of the “release” tag is less than or equal  
to  
“0.4” (string or floating point compare okay), “due” date is this year  
or  
earlier.

TIA,  
Jeffrey