I have one table having 50 entries with Name, Type, Status etc. These are user specific columns.
Each such entries are divided in three Status viz. Active, Expired, Expiring Soon.
A particular user has 20 entries out of which 7 are expired, I want this count (7 expired) in User profile table.
I tried but not able to achieve this. I hope you guys already know how to do this.
Thanks in advance.