Dear sir,
I have used the below query to display the cb users,
but the name field is not displaying, so please help me out.
SELECT
C.cb_regnoyearofpassing,
C.cb_fathername,
C.cb_address,
C.cb_sdob,
C.cb_semisteryear,
C.cb_qualification,
C.cb_subject1,
C.cb_subject2,
C.cb_subject3,
C.cb_subject4,
C.cb_subject5,
C.cb_subject6,
C.cb_gender,
C.cb_category,
C.cb_totalfeeksou,
C.cb_branchname,
C.avatar,
C.user_id
FROM
#__comprofiler C INNER JOIN #__users U
ON C.user_id = U.id
INNER JOIN #__user_usergroup_map UM
ON U.id = UM.user_id
INNER JOIN #__usergroups UG
ON UM.group_id = UG.id
WHERE
U.block = 0
AND
UG.title = 'Client'
You're not selecting the name column, which is in _users. So you need to add U.name to your select.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
krileon
