How to remove used Serials display in user account

-- HikaShop version -- : 4.7.2
-- Joomla version -- : 4.2.9

Hi,
I have added the ability to customers to see their own serials (coupon codes), in their account, but, is there a way to show only the not used once, or, add a row with the status of it. In the db there is a serial_status, but where or how to use it to get the right info displayed?

Thank you
Xavier

Hi,
ok, thanks, but the db contains a value status, this value is updated when a serial is used and becomes useless for an other use, so it should be possible to change the 'listing' display to only show the serials not used, or do I missunderstand something?

Merci
Xavier

Hi,
yes, ok, I agree, but as the hikashop_discount_code is the same as hikaserial_serial_data, the search is easily done with an inner join, to display the hikashop code used yes or no (if 1 then used else available) in the hikaserial list shown on the user page.

I'm ok with sql, should find how to display it in php, but never 'played' with joomla code

Merci
Xavier

Hi Jerome,
thanks for the answer. Could you please have the patience to explain me how, because I cannot find the right way to do so.

Thanks