UPDATES EasySocial 4.0.13 Released! Update to the latest version now!


Your Time
Our Time
Response Time
24 — 48 hours
We strive to provide the fastest ever response possible. However, we are not super beings.

Allow at least 24 — 48 hours
  Support is offline
It is currently off working hours and most of us aren't around

Rest assured that we will get back to you as soon as the day starts tomorrow!
  Support is offline

Custom SQL query

Michael Stanek · ·
9:04 PM Tuesday, 29 November 2022
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
The replies under this section are restricted to logged in users or users with an active subscription with us