MySQL field 2

OK, in a previous post i've asked about creation of a mysql field, that i was able to do.

www.joomlapolis.com/forum/153-professional-member-support/219391-solved-mysql-field

Now i need to find where these values are stored because i have Fabrik plugin that i need to connect to that field.

This is because i have the CB fields Firstame and Lastname as Follows:

Firstname: Jonh
Lastname: SMITH

Then, i've created this mysql field to concatenate both values and got the value SMITH, John (with the comma) that i need to use to connect to Fabrik.

Are these concatenations stored anywhere or are just "on time" running queries?

Is there a way to have a field directly in comprofiler table where i can relate the J! user ID and this field, and get it directly from Fabrik?

Reards.

Query fields aren't stored anywhere. I've no idea what Fabrik is or how it integrates with CB, but if it used CB API properly you'd easily be able to use getFields API as shown below to retrieve the query field.

www.allmysocials.com/directory/tutorials/item/235-obtaining-field-values-through-api

I assume you're using CB Query Field, but the query in your first topic isn't even remotely correct so I suspect maybe you're using some other query type field.