[TYPO3-dev] Views in TYPO3 database

[Steffen Kamper]

Hi,

Am 07.03.2011 11:38, schrieb Rik Willems:
> Howdy,
>
> I'm planning an extension that would need to show the same records on
> different pages. For this I'm planning a m2m table like is common in TYPO3.
> But, I'd like my records not the have a single pid where it is
> accessable through the 'list' function. Preferaby I'd like the record to
> be edited through all pages it is on.
>
> Is it possible to make a view of the m2m and record table and add this
> to TCA? This way the record would show up on all pages the m2m says it
> is on.
>
> Looking forward to your thoughts.

sure it's possible to make views. But then you are on MySQL only and you 
have to use raw statements. For sure DBAL compatibility isn't the case then.

vg Steffen