[TYPO3-dev] workspace & filtering on SQL-Level

[Volker Biberger]

Hello @all,

we just worked our way through workspaces & own extensions. Everything 
seems to work. The only downside is, that we cannot filter 
Database-Entries on SQL-Level.

Let's say we have a Entry in our Table with Category 1 Set. Now we 
filter by using SELECT * FROM ourtable WHERE pid > 0 AND category = 
intval($this->piVars['cat']). You get the idea.
If we submit cat = 2 our entry will not be displayed. So far so good.

Now with workspaces this will result in Problems if there is a verision 
of that entry that has category set to 2. In preview it will not be 
displayed since the original Entry is not selected and thus not version 
overlayed.

Did I misunderstand the procedure of selecting Entries from Workspace, 
or is filtering on SQL-level not combinable with workspace.

Thanks for Advance for your comments.

Volker Biberger