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

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

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

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

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.

Uploaded a new version which also makes use of phpexcel.

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

Regards!

Have a look at the phpexcel sample

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

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 ?

@cas

Which one the latest?

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

@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...

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

Awesome. Let me know if you need help.

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

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

@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.

Thanks @cas @dregad @atrol