how to search for a promotion user?

[ws4210]

I am trying to list all users who used a particular promotion code

How to search for it?

[WHMCS John]

There isn't I'm afraid.

[ws4210]

Hi

 

John then it is needed . Please remind that

I am sure people will need to have a list of users who have used a particular promotion code

Any other way I can search?

 

Thanks

[laszlof]

You could do it with a sql query. Something like this would work:

 

SELECT h.id, h.domain, c.firstname, c.lastname, c.email
FROM tblhosting h, tblclients c, tblpromotions p
WHERE h.promoid = p.id
AND h.userid = c.id
AND p.code =  "YOURPROMOCODEHERE"

[ws4210]

wow that was complicated