[eclipselink-users] Insert into table using ReadallQuery with expression

[Tim Hollosy <hollosyt@xxxxxxxxx>]

This has got to be a common use case, I'm just not seeing how to do
this with the API.

I want to take an expression off of a ReadAllQuery, change the select
values (I'd assume I'd have to use a Report Query)? and insert that
into a new table.

Example:

insert into employee_tracking
select 1,'custom_string',e.name from employee
where employee....


So I already have a nice ReadAllQuery representing the select from
employee, I want to reuse that to do a bulk insert into
employee_tracking. It's a basic bulk action from a search type
pattern.

Ideas?

Thanks!

./tch