[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