Can I create a cron/feed from quick option for delete some rows?

Like:

DELETE a1 FROM `#__deals` a1, `#__deals` a2 WHERE a1.company_id = a2.company_id AND a1.id < a2.id AND LEFT(a1.created,10)=CURDATE()

Thanks

Hello,
Yes you can. Cron / Feed section have the option to write your own Database query.

Can you tell me how? Because it forces me to use a profile.

Daniel wrote: Hello,
Yes you can. Cron / Feed section have the option to write your own Database query.

See attachment.

Hi, I would appreciate a response to this request.

Hi,
Oh Sorry, I missed it, We have applied a validation not to allow any query except fetching the data records from Database. However It can be customized for you only. Please contact our Sales team via Contact us -> Request a Quote form, We'll look into it.