Contact Us Today! | vcare@wdmtech.com

WDMtech

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

More
30 May 2017 10:16 #4323

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


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Pitagora
  • Pitagora's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
30 May 2017 08:20 #4321

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 or Create an account to join the conversation.

More
29 May 2017 07:59 #4308

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 or Create an account to join the conversation.

  • Pitagora
  • Pitagora's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
29 May 2017 06:44 #4305

Hi, I would appreciate a response to this request.

Please Log in or Create an account to join the conversation.

  • Pitagora
  • Pitagora's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
24 May 2017 23:48 #4293

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


See attachment.

Attachments:

Please Log in or Create an account to join the conversation.

  • Pitagora
  • Pitagora's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
24 May 2017 23:19 #4292

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

Please Log in or Create an account to join the conversation.

More
24 May 2017 13:28 #4290

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


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Pitagora
  • Pitagora's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
24 May 2017 08:41 #4286

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 or Create an account to join the conversation.