View Issue Details

IDProjectCategoryView StatusLast Update
0014633mantisbtplug-inspublic2023-04-02 09:39
Reportercas Assigned Tocommunity  
PrioritynormalSeverityfeatureReproducibilityN/A
Status closedResolutionno change required 
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.
Attached Files
Query100.zip (15,722 bytes)
Query101.zip (16,398 bytes)
Query102.zip (19,014 bytes)
Query.zip (983,619 bytes)

Activities

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: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: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

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 ?

sintaq

sintaq

2023-03-03 11:55

reporter   ~0067443

@cas

Which one the latest?

cas

cas

2023-03-04 04:00

reporter   ~0067447

latest version I have is 2.02 which works with mantis 2.x, see https://mantisbt.org/forums/viewtopic.php?p=72173&hilit=query+plugin#p72173

dregad

dregad

2023-03-13 12:54

developer   ~0067480

@cas considering the large number of plugins you have written, it would be truly great if, instead of posting zip files here or in the forums, you could actually publish them as repositories in the https://github.com/mantisbt-plugins organization - then we could close the related issues in this tracker and make them point to the individual repositories, and also reference these from https://mantisbt.org/wiki/doku.php/mantisbt:plugins:start...

cas

cas

2023-03-15 09:16

reporter   ~0067497

@dregad, i am in the process of reviewing all for the last releases and will add them there in the coming time.

dregad

dregad

2023-03-15 10:18

developer   ~0067500

Awesome. Let me know if you need help.

cas

cas

2023-03-16 11:15

reporter   ~0067506

This plugin now can be found here: https://github.com/mantisbt-plugins/Query

atrol

atrol

2023-03-20 14:16

developer   ~0067515

Set to "resolved" as the plugin is now available on GitHub.
@cas let me know if you would like to have a project on this tracker to track bugs and feature requests for the plugin

cas

cas

2023-03-22 10:34

reporter   ~0067517

@atrol, thanks not needed. Issues can be reported via Github.
As far as I am concerned, all sub-projects allocated to me can be closed.
Support will be via Github for all plugins I am still supporting.

sintaq

sintaq

2023-03-22 17:46

reporter   ~0067519

Thanks @cas @dregad @atrol