Re: Execute custom SQL

[Jacques Le Roux]

Hi Rick,

Did you try https://localhost:8443/webtools/control/EntitySQLProcessor

HTH

Jacques

Le 13/09/2020 à 16:32, Rick Fleming a écrit :

Hi all

I need to execute a custom plain text query against our Postgresql database.
  "select product_id, internal_name, brand_name, description, small_image_url from product 
where page @@ plainto_tsquery('"+searchterm+"') limit 25";

What is the preferred way to do this in Ofbiz?

Thanks
Rick