Thank you Mandeep and Jacques for your kind replies
I will look in that direction ----
-Rick




    On Sunday, September 13, 2020, 11:26:12 AM MDT, Jacques Le Roux 
<[email protected]> wrote:  
 
 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
>
  

Reply via email to