0

could you help me to convert SQL query to Criteria JPA in Java? Unfortunately, I don't know how to implement it. My query:

select * from public.phone where phone.id in (
   select SPLIT_PART(STRING_AGG(phone.id, ','), ',', 1)
   from public.phone as phone where phone.check_id is null
   and phone.brand_id = 'f483ae53-645d-4788-98a8-b97cdc625940'
   group by phone.brand_id, phone.name, phone.series, 
   phone.amount_of_built_in_memory, phone.amount_of_ram
);
AlexK
  • 1
  • you can try https://stackoverflow.com/a/4668015/1811348 additionally criteria query class has options for groupby, having and so on refer: https://docs.oracle.com/javaee/7/api/javax/persistence/criteria/CriteriaQuery.html – swapyonubuntu Oct 11 '22 at 16:34

0 Answers0