I have a CB Query Field that count the number of users in a group. This also counts the owner for instance if there is 4 user the query fields returns 5 since it adds the owner. My question is how can I subtract one from the CB Query Field?
I want to do the following too:
If CB Query Field is equal or greater than 12 display a message
My question is how can I subtract one from the CB Query Field?
You want to count active users without the owner? I suggest the below query as it only counts active users (excludes owner, pending, and banned).
Code:
SELECT COUNT(*) FROM `#__groupjive_users` WHERE `status` IN ( 1, 2, 3 )
To include the Owner use the below.
Code:
SELECT COUNT(*) FROM `#__groupjive_users` WHERE `status` IN ( 1, 2, 3, 4 )
To count for a specific group use the below.
Code:
SELECT COUNT(*) FROM `#__groupjive_users` WHERE `group_id` = GROUP_ID_HERE AND `status` IN ( 1, 2, 3 )
I want to do the following too:
If CB Query Field is equal or greater than 12 display a message
It depends entirely where you intend on using this at. If the locations supports substitutions you could try the below.
[cb:if cb_queryfield>"12"]There are more than 12 users.[/cb:if]
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
