needs some idea on Filtering list..

13 years 11 months ago #16928 by pacochin
needs some idea on Filtering list.. was created by pacochin
Hi,

I am learning how to filter a list. The story goes like this...

I have a website that do Health club membership whereby a principal account holder (i.e the main member) will first register and Admin will then assign a membership id (e.g MY0001) in a customize field in CB call "cb_membershipno"

Then, this member can also apply for his wife, 2 kids to have this membership card too. I have decided that these supplementary card holders SHOULD register with CB individually first, and then allow them to be LINKED by the lists using MY0001 using another customize field call "cb_AssociatedToMainAccount". Supplementary member will enter manually "MY0001" into "cb_AssociatedToMainAccount".

So, the main account holder can logged in and click this special list and SEE his 3 other member linked to him using "cb_AssociatedToMainAccount".

And this list is take 2 criteria for filtering.

1. The Logged in user value for cb_membershipno, in this case (MY0001)
2. Use the value of cb_membershipno to Match against all others CB user whose "cb_AssociatedToMainAccount" has the same value.
3. voila ! thats the list i want !

But i dont know the SQL for this...can someone help ?

thks in advance !

Please Log in to join the conversation.

13 years 11 months ago #17016 by pacochin
Replied by pacochin on topic Re:needs some idea on Filtering list..
Hi,

Anyone can help please....

Please Log in to join the conversation.

13 years 11 months ago #17050 by mikko
Replied by mikko on topic Re:needs some idea on Filtering list..
This is not possible currently without hacking the component. If you really need it, try www.joomlancers.com

mikko

Please Log in to join the conversation.

13 years 11 months ago #17052 by pacochin
Replied by pacochin on topic Re:needs some idea on Filtering list..
thanks mikko..

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.420 seconds

Facebook Twitter LinkedIn