View Issue Details

IDProjectCategoryView StatusLast Update
0014633mantisbtplug-inspublic2015-11-09 07:53
Reportercas Assigned To 
PrioritynormalSeverityfeatureReproducibilityN/A
Status newResolutionopen 
Summary0014633: Query plugin
Description

This plugin will enable you to define multiple queries/scripts which:

  1. can be run online (by admin)
  2. can be scheduled in which case results are emailed to nominated recipients

this is the first release so feedback is highly appreciated.

Additional Information

More information can be found in the doc/readme.txt

TagsNo tags attached.

Activities

cas

cas

2012-08-17 06:03

reporter  

Query100.zip (15,722 bytes)
cas

cas

2012-08-22 10:26

reporter  

Query101.zip (16,398 bytes)
cas

cas

2012-08-22 10:26

reporter   ~0032618

Apart from some bugfixes, added an option for defined users to execute queries.

cas

cas

2012-08-23 06:23

reporter  

Query102.zip (19,014 bytes)
cas

cas

2012-08-23 06:24

reporter   ~0032626

Version 1.02
Fixed some minor bugs
Added sensible samples of each type of query
Allow standard email addresses in combination with mantis usernames

dregad

dregad

2012-08-23 09:59

developer   ~0032630

Wouldn't it be better to rely on MantisBT's email configuration (ie. using underlying PHPMailer library through the functions in email_api.php) ?

cas

cas

2012-08-23 10:17

reporter   ~0032631

yes it would but I could not find a function within email_api.php to add attachments.
Did I miss something ?

dregad

dregad

2012-08-23 11:22

developer   ~0032634

Hmmm good point - the email api is mostly targeted at sending notifications, for which we don't need (want) to send attachments, so indeed we lack functions to do that. An idea for future improvement I guess.

cas

cas

2014-04-07 08:05

reporter  

Query.zip (983,619 bytes)
cas

cas

2014-04-07 08:06

reporter   ~0039849

Uploaded a new version which also makes use of phpexcel.

kcastro

kcastro

2015-03-04 15:37

reporter   ~0049138

how can i get the exportable file in .xls? or this only works with .csv?

Regards!

cas

cas

2015-03-05 10:41

reporter   ~0049145

Have a look at the phpexcel sample

vicostas

vicostas

2015-03-05 14:03

reporter   ~0049146

ejemplo

Kunda

Kunda

2015-11-09 07:51

reporter   ~0051827

I'd like to learn more about this. Will this be a plugin ? If so will it live in the github mantisbt/plugins repo ?

Kunda

Kunda

2015-11-09 07:53

reporter   ~0051828

Does this plugin address the fundamental issue in http://www.mantisbt.org/forums/viewtopic.php?f=2&t=23450 which is to be able to automate downloading an attached .patch or .diff to a ticket on mantis ?