[TYPO3-dev] Problem with selected records in pi_flexform

[JoH asenau]

>> Taking a look at phpMyAdmin also only shows a "2" instead of the tag
>> uids in pi_flexform. Somewhere the correct uids must be stored, but
>> where?
>>
>
> maybe this is because tagpack does not add a 'tag' column to the
> foreign table as usual for MM, but uses "virtual column".

No - when using MM tables this is the default behaviour of TYPO3.
The field is containing the number of relations stored in the MM table,
while the MM table itself will point to the uids.

You are right about the "virtual fields" that are assigned when activating
the tagging for any kind of records. So the number of relations will not be
saved if you just activate tagging for a table, because there won't be any
field in this table.

But in this case, there _is_ a "real field" in the flexform which is
containing the expected value.

This is the behaviour I would expect for any kind of relation in relational
databases.
Unfortunately TYPO3 is using normalised MM relations only for special field
types, while other fields will still use the dirty and performance eating
CSV list of related records.

HTH

Joey

-- 
Wenn man keine Ahnung hat: Einfach mal Fresse halten!
(If you have no clues: simply shut your gob sometimes!)
Dieter Nuhr, German comedian
Xing: http://contact.cybercraft.de
Twitter: http://twitter.com/bunnyfield
TYPO3 cookbook (2nd edition): http://www.typo3experts.com
TYPO3 workshops: http://workshops.eqony.com