[TYPO3-dev] $this->pi_exec_query doesn't work correct with workspaces?

[Peter Russ]

Johannes Konert schrieb:
> Hi,
> I am astonished that a preview in an draft-workspace produces ugly 
> [PLACEHOLDER]-entries in the listView, instead of displaying the correct 
> title (in singleView then it works).
> This happens if a new entry was made in draft-workspace, which is not 
> there in LIVE-workspace so far. Obviously the title-placeholder is not 
> replaced.
> 
> Moreover:
> If I hide entries in draft-workspace they are still there in 
> draft-preview! (Even other changes like starttime endtime are not visible).
> 
> I do use a normale FE-Extension generated by Kickstarter:
> The data is fetched like this:
> // Get number of records:
> $res = $this->pi_exec_query($this->extTable,1,$whereClause);
> list($this->internal['res_count']) = 
> $GLOBALS['TYPO3_DB']->sql_fetch_row($res);
> 
> // Make listing query, pass query to SQL database:
> $res = $this->pi_exec_query($this->extTable,0,$whereClause);
> $this->internal['currentTable'] = $this->extTable;
> 
> It seems to me, that pi_exec_query does not use the versionOL() for 
> workspaces and does not handle the enableFields correctly in this case.
> But I cannot believe this. Do I really have to handle the 
> workspace-preview and versionOL() myself?
> The CORE API document says:
> "For the frontend the challenges are mostly related to creating correct 
> previews of content in workspaces. For most extensions this will work 
> transparently as long as they use the API functions in TYPO3 to request 
> records from the system."
> So it should work with pi_exec_query.
> 
> has someone the same experiences?
> (TYPO3 v4.0.1, ExtensionKickstarter 0.3.6)
> 
> Thanks for feedback. I am afraid, I have to write the Database-queries 
> and workspace-handling and versioning-filtering myself....
> 
> Greetz
> Johannes
> PS: I apologize that I posted this in typo3.german days ago, but I think 
> the dev-list is a better place to ask...

might help you:
http://typo3.org/fileadmin/typo3api-4.0.0/d4/d1b/class_8tslib__content_8php-source.html#01179

Regs. Peter

-- 
Fiat lux!
Docendo discimus.
_____________________________
4Many® Services
openBC: http://www.openbc.com/go/invuid/Peter_Russ