entity operator problem

[Richard Fleming <ri...@thebva.com>]

Hi all,

I'd need to use the tsearch2 operator "@@" in a query like:

SELECT * FROM PRODUCT
WHERE INFO @@ to_tsquery('maytag&belt&washer')

-INFO is a new column which combines several pieces of information about a product and the tsearch function allows a more natural search for users(ie.. "I need a maytag belt for my washer").

I've tried to use the @@ operator in an entity-condition, but I get the error:
org.ofbiz.base.util.GeneralException: Error rendering screen [component://ecommerce/widget/CatalogScreens.xml#SearchByTerm]: java.lang.IllegalArgumentException: Could not find an entity operator for the name: @@ (Could not find an entity operator for the name: @@).

Do I need to step back and us a JDBC connection, or can the operator be defined somewhere that will allow it's use?

As always, thanks in advance.
Rick