Cache fields affect variable sql

hi!

I have found this issue:

I have a select field with the query:

SELECT id as value, name as text FROM #__contact_details WHERE user_id="{item->created_by}"

As you can see, the available values will be based on the current item. But this doesn´t fare well with this cache: github.com/FLEXIcontent/flexicontent-cck...ent.fields.php#L1742

The result is that in category list the first item is properly calculated, but for the rest , no, so when trying to get @element[ $v ], @element is not correctly populated

Caches are always tricky to implement, so on my side I´ll simple comment that line until your intervention.

Maybe you´ll need to detect if is cacheable or simply give the option from the field to turn off or on the cache for that field

Regards!

Hello

Actually checks for this case are implemented,
- and it is supposed to work,
You see we are calculating a "canCache" FLAG, based on if {$item->} is used in the query

But the calculation is not returned / not used, because of a bug that i see now
- the reference "&" that should be before the $canCache parameter of method doQueryReplacements()
is missing

Try adding it

In same file find and replace:
With: