USER on dyna_list where |
How filter a record based on connected user
Insert in a where field:
tx_faohlpe_work_experience.deleted=0 and tx_faohlpe_work_experience.cruser_id=###USER:uid### |
Massimiliano Fani (18/02/2010 09:54:04) |
pagelink tag |
How use the pagelink tag in dyna_list <fields> <tx_mblnewsevent_from> <eval>date("j M Y",|)</eval> <label>Date from</label> <width>50</width> </tx_mblnewsevent_from> <tx_mblnewsevent_to> <eval>date("j M Y",|)</eval> <label>Date to</label> <width>50</width> </tx_mblnewsevent_to> <title> <label>Title</label> <width></width> <wrap><![CDATA[<b>|</b>]]></wrap> <pagelink>14778,dyna_fef[uid]={uid}</pagelink> </title> <countryName> <label>Country</label> <width>50</width> <nowrap>1</nowrap> <wrap><![CDATA[<b>|</b>]]></wrap> </countryName> <user_extextender_order> <label><![CDATA[Type: <br>Public:0,Planning:1,Private:2]]></label> <width>50</width> <nowrap>1</nowrap> <wrap><![CDATA[<b>|</b>]]></wrap> <usergroup>276</usergroup> </user_extextender_order>
<tx_mblnewsevent_organizer> <label>Organizer</label> <width>50</width> <nowrap>1</nowrap> <wrap><![CDATA[<b>|</b>]]></wrap> </tx_mblnewsevent_organizer> <icon_edit> <label>Edit</label> <value><![CDATA[<img src='http://t3admin.com/typo3/sysext/t3skin/icons/gfx/edit2.gif' border=0>]]></value> <link>14699,dyna_fef[uid]={uid}</link> <usergroup>276</usergroup> </icon_edit> <icon_delete> <label>Delete</label> <value><![CDATA[<img src='http://t3admin.com/typo3/sysext/t3skin/icons/gfx/garbage.gif' border=0>]]></value> <link>14699,dyna_fef[duid]={uid}</link> <onclick>return confirm('Are you sure you want to delete?')</onclick> <usergroup>276</usergroup> </icon_delete> </fields> |
Massimiliano Fani (21/01/2010 11:06:10) |
Dyna List external_data |
XML Settings external_data <fields> <links> <label>Countries</label> <external_data> <sql>SELECT cn_iso_3,cn_short_en FROM static_countries</sql> <key>cn_iso_3</key> <label>cn_short_en</label> <wrap><![CDATA[<i>|</i>]]></wrap> <separator>,| - </separator> </external_data> </links> </fields> |
Massimiliano Fani (28/12/2009 15:24:15) |
target link |
use target in dyna_list xml <fields> <imagealttext> <label>Description</label> <width>20</width> </imagealttext> <keywords> <label>Description</label> <width>20</width> </keywords> <bodytext> <label>Description</label> <width>20</width> </bodytext> <image> <label>Image</label> <path>fileadmin/user_upload/sifsia/docs/medium_</path> <image_wrap><![CDATA[<img src='|'>]]></image_wrap> <link>14104,dyna_fef[uid]={uid}</link> </image> <title> <width></width> <wrap><![CDATA[<b>|</b>]]></wrap> <linkurlfield>news_files,fileadmin/user_upload/sifsia/docs/|</linkurlfield> <target>blank</target> </title> <short> <label>Subtitle</label> <width></width> </short> <author> <label>Author</label> <width></width> <wrap><![CDATA[<b>|</b>]]></wrap> </author> <status_desc> <label>Status</label> <width>20</width> <usergroup>267</usergroup> </status_desc> <icon_edit> <label>Edit</label> <value><![CDATA[<img src='http://typo3.fao.org/typo3/sysext/t3skin/icons/gfx/edit2.gif' border=0>]]></value> <link>14002,dyna_fef[uid]={uid}</link> <usergroup>267</usergroup> </icon_edit> <icon_delete> <label>Delete</label> <value><![CDATA[<img src='http://typo3.fao.org/typo3/sysext/t3skin/icons/gfx/deletedok.gif' border=0>]]></value> <link>14002,dyna_fef[duid]={uid}</link> <onclick>return confirm('Are you sure you want to delete?')</onclick> <usergroup>267</usergroup> </icon_delete> </fields> |
Massimiliano Fani (25/11/2009 11:23:58) |
linkurlfield |
linkurlfield = field , wrap <fields> <title> <width></width> <linkurlfield>news_files,fileadmin/user_upload/sifsia/docs/|</linkurlfield> <wrap><![CDATA[<b>|</b>]]></wrap> </title> </fields> |
Massimiliano Fani (23/11/2009 14:38:12) |
XML where (dyna_list) |
XML setting to replace SQL where in dyna_list <records>
<where> <sql>tt_news.deleted=0 and tt_news.hidden=0 and tt_news.pid=14105</sql> <overwrite>1</overwrite> <usergroup>267</usergroup> </where>
<where_gpvars> <sql>title='test'</sql> <overwrite>1</overwrite> <usergroup>250</usergroup> </where_gpvars>
<where_lang> <sql>sys_language_uid=5</sql> <overwrite>1</overwrite> <usergroup>233</usergroup> </where_lang>
<where_page> <sql>pid=11467</sql> <overwrite>1</overwrite> <usergroup>10</usergroup> </where_page>
<andwhere> <querystring> <wrap>( (lcase(title) LIKE '%|%') or (lcase(bodytext) LIKE '%|%') or (lcase(author) LIKE '%|%') or (lcase(keywords) LIKE '%|%'))</wrap> </querystring> </andwhere>
</records> |
Massimiliano Fani (16/11/2009 16:15:17) |
Dyna List XML Setting |
XML Settings <fields> <title> <label>Title</label> <width></width> <wrap><![CDATA[<b>|</b>]]></wrap> <link>396,dyna_fef[uid]={uid}</link> </title> <datetime> <eval>date("j M Y",|)</eval> <label>Date</label> <width>50</width> </datetime> <bodytext> <striptags>1</striptags> <words>50| [...]|7,dyna_fef[uid]={uid}</words> <label>Abstract</label> <width>50</width> </bodytext> <author> <label>Author</label> <width>50</width> <nowrap>1</nowrap> <wrap>Author: |</wrap> </author> <conditions> <label>Conditions</label> <width>50</width> <serialized>tx_mblnewsevent_where</serialized> <nowrap>1</nowrap> <wrap>Conditions: |</wrap> </conditions> <icon_edit> <label>Edit</label> <value><![CDATA[<img src='http://t3admin.com/typo3/sysext/t3skin/icons/gfx/edit2.gif' border=0>]]></value> <link>393,dyna_fef[uid]={uid}</link> <usergroup>14,18,67,13</usergroup> </icon_edit> <icon_delete> <label>Delete</label> <value><![CDATA[<img src='http://t3admin.com/typo3/sysext/t3skin/icons/gfx/garbage.gif' border=0>]]></value> <link>393,dyna_fef[duid]={uid}</link> <onclick>return confirm('Are you sure you want to delete?')</onclick> <usergroup>14,18,67,13</usergroup> </icon_delete> <image> <label>Image</label> <path>fileadmin/user_upload/test/small_</path> <image_wrap><![CDATA[<img src='|' style='border:1px solid black;margin-top:5px;margin-right:10px;float:left;'>]]></image_wrap> </image> <ext_url> <label>URL</label> <linkurlfield>ext_url</linkurlfield> </ext_url> <news_files> <label>URL</label> <path_file>fileadmin/templates/website/files</path_file> </news_files> </fields> |
Massimiliano Fani (24/10/2009 23:20:04) |