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

Johannes Konert johanneskonert at gmx.de
Thu Sep 21 10:48:18 CEST 2006


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...




More information about the TYPO3-dev mailing list