Hmmm..

Query Check Box (Multiple)
Query Drop Down (Multi-select)
Query Drop Down (Single Select)
Query Radio Buttons

Those options are not available in the 'Type' field.

If I look at the tutorial at www.joomlapolis.com/support/tutorials/107-use-cases/18377-configuring-a-country-field-with-cb-query-field-plugin , it shows that the drop-down says 'Query Drop Down (Single-Select)'.

If I select Drop Down (Single Select), the right side changes to:

Field-specific Parameters
There are no parameters for this item

My CB Configuration Manager is version 1.9.1 which it indicates is the most recent version but the tutorial shows CB Query field plugin (version 3.0 or better). I checked on the Addons, but did not see a CB Query field plugin. So how can I determine if I have the most recent version of the Field Management / CB Query field plugin?

Kyle,

I searched the CBSubs and CB Manual for documentation on the CB Query plugin but could not find any. Without documentation on the CB Query (the tutorial was for adding a Country field which doesn't really match up with what I was needing), I put on my developer thinking cap.

From what I can see, when adding a new field, the query function allows you to do database queries which can then be used to populate the 'name' value, in my example "cb_expiredsubscriptionquery" with the COUNT of expired subscriptions. As we are not allowing multiple subscriptions, this should find their current subscription and increment COUNT by 1 for an expired subscription.

Here is how I have that setup with 'nothing' to be displayed on the users profile as this is only an internal query:



But what would happen in the situation where someone has 'upgraded' from one plan to another? As the original plan is still in the database, will this be considered as an expired plan since another plan record has been created for the new plan? If so, that defeats the purpose of the query which is to determine if the user's subscription (current) has expired because it would show a COUNT of '1' but the user has an active subscription.

So now I have a field 'cb_expiredsubscriptionquery' that has a COUNT of 1. I updated my CB Auto Actions 'Redirect after expired subscriptions' adding a 'Conditional' to check this field for a positive value. However, this didn't work.