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

Daniel
Offline
Administrator

30 May 2017 10:16 #4323 by Daniel

Replied by Daniel on topic Can I create a cron/feed from quick option for delete some rows?

Yes, vData doesn't allow you to run Delete query in Cron.

Thanks
Daniel

Please Log in to join the conversation.

Pitagora
Topic Author
Offline
New Member

30 May 2017 08:20 #4321 by Pitagora

Replied by Pitagora on topic Can I create a cron/feed from quick option for delete some rows?

Daniel wrote: 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.

I'm not sure I understand you very well. First you tell me it's possible but now you tell me I have to pay?

Please, let me know.

Please Log in to join the conversation.

Daniel
Offline
Administrator

29 May 2017 07:59 #4308 by Daniel

Replied by Daniel on topic Can I create a cron/feed from quick option for delete some rows?

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.

Pitagora
Topic Author
Offline
New Member

29 May 2017 06:44 #4305 by Pitagora

Replied by Pitagora on topic Can I create a cron/feed from quick option for delete some rows?

Hi, I would appreciate a response to this request.

Please Log in to join the conversation.

Pitagora
Topic Author
Offline
New Member

24 May 2017 23:48 #4293 by Pitagora

Replied by Pitagora on topic Can I create a cron/feed from quick option for delete some rows?

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

See attachment.

Please Log in to join the conversation.

Pitagora
Topic Author
Offline
New Member

24 May 2017 23:19 #4292 by Pitagora

Replied by Pitagora on topic Can I create a cron/feed from quick option for delete some rows?

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

Please Log in to join the conversation.

Daniel
Offline
Administrator

24 May 2017 13:28 #4290 by Daniel

Replied by Daniel on topic Can I create a cron/feed from quick option for delete some rows?

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.

Pitagora
Topic Author
Offline
New Member

24 May 2017 08:41 #4286 by Pitagora

Can I create a cron/feed from quick option for delete some rows? was created 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.