Please Log in to join the conversation.
The below appears to work fine in my tests to show connection requests I sent that are still pending.What is the advanced query filter needed, to show only the user's pending connections in a user list?
( ( SELECT COUNT(*) FROM `#__comprofiler_members` WHERE `memberid` = u.`id` AND `referenceid` = '[user_id]' AND `pending` = 1 ) > 0 )
No.Also is it possible to call a list in the content module using substitutions?
Please Log in to join the conversation.
Please Log in to join the conversation.
Below should do that.One more thing: what is the query to show the incoming pending requests towards the user? (i.e. the ones made by others to him)
( ( SELECT COUNT(*) FROM `#__comprofiler_members` WHERE `memberid` = '[user_id]' AND `referenceid` = u.`id` AND `pending` = 1 ) > 0 )
Please Log in to join the conversation.
Please Log in to join the conversation.