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
>