Joomla Extensions

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

More
6 years 8 months ago #4286 by Pitagora
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

Please Log in to join the conversation.

More
6 years 8 months ago #4290 by Daniel
Hello,
Yes you can. Cron / Feed section have the option to write your own Database query.

Thanks
Daniel

Please Log in to join the conversation.

More
6 years 8 months ago #4292 by Pitagora
Can you tell me how? Because it forces me to use a profile.

Please Log in to join the conversation.

More
6 years 8 months ago #4293 by Pitagora

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


See attachment.
Attachments:

Please Log in to join the conversation.

More
6 years 8 months ago #4305 by Pitagora
Hi, I would appreciate a response to this request.

Please Log in to join the conversation.

More
6 years 8 months ago #4308 by Daniel
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.

Thanks
Daniel

Please Log in to join the conversation.

Cron Job Starts