Richard,
If you are trying to review some data then SQL fits for you. Otherwise use
delegator object to do that. There are several examples which uses the
delegator to fetch, store, remove the data from database.
Please check Find Services and CRUD services to see how it is working.
Groovy and
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
wrote:
Hi Rick,
Did you try https://localhost:8443/webtools/control/EntitySQLProcessor
HTH
Jacques
Le 13/09/2020 à 16:32,
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,
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