By Michael Stanek on Tuesday, 29 November 2022
Posted in General Issues
Replies 3
Likes 0
Views 666
Votes 0
Hi Stackideas, I would like to ask you for a paid custom query that can be saved here: https://www.redmine-x.com/administrator/index.php?option=com_mijosql&controller=queries. The goal is to display all customers who bought a plan with an Addon so we can contact them. I want to see who it is and what Addon they bought. The columns I would like to see are as follows (divided by a semi-colon):


Columns: Name; Email; Plan (bought as an Addon); Expiration date
Example: Diego Rodríguez; diego.rodriguez@nvlspain.es; Project Templates Plugin for Redmine; Saturday, 25 November 2023 14:54

There will be a few JOINS and my SQL knowledge is very poor. You will have it much quicker. Pls send a quote. Thanks a lot. Michael
Hey Micheal,

Columns: Name; Email; Plan (bought as an Addon); Expiration date
Let me know that you just want to get the addon name not the subscription plan name.

Update us with the response.
·
Wednesday, 30 November 2022 11:16
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Manisha, yes, that is correct. Just the Addon name.
·
Wednesday, 30 November 2022 16:08
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey there,

Thank you for updating us on this.

Please submit a request at https://stackideas.com/customization-works. Our salesperson would gladly send you a quote for the customization that you have requested.

Thank you!
·
Thursday, 01 December 2022 11:39
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post