Hi,

I have added two new CB fields using the latest version of CB Query Field 2.0 with the following SQL syntax:

SELECT `name` FROM jos_cbsubs_plans

SELECT `expiry_date` FROM jos_cbsubs_subscriptions

But I don't get any results in these fields and they are not displaying on the users profile when configure to display like all the other fields.

These CB Query Fields are also not being exported to Excel when using CB Juice.

I'm trying to display the users CBSubs Plan and CBSubs expiry date for exporting to Excel.

Can this be done?

Thanks for the quick reply.

Working on this further, I can see the results of these CB Query Fields with the existing SQL syntax on the frontend in the Users profile and in CB User Lists on the frontend, but can not view these fields based on the CB Query Field in the CB Users profiles from the Joomla Administrator backend... How can these Query Fields be viewable in the Joomla Backend in the CB User Profiles?

We needs to provide a (printable) report listing all active CB Users with their CBSubs Subscriptions Plan and their CBSubs Subscription Expiry Dates, e.g. 30/06/2013.

Is there another method to grab the users CBSubs Plan and CBSubs Expiry Date and write this data to other fields that can then be viewed and exported via CBJuice to Excel?