TYPO3 Formidable - List bound to a db-datasource

List bound to a db-datasource

What does it do ?

These two lists below demonstrate the usage of renderlet:LISTER in combination of datasource:DB to produce a browsable, sortable and cached view of records in the database.

See code: List bound to a db-datasource

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<formidable version="0.7.76"
	xmlns:datahandler="http://www.ameos.com/formidable/080/datahandler"
	xmlns:datasource="http://www.ameos.com/formidable/080/datasource"
	xmlns:renderer="http://www.ameos.com/formidable/080/renderer"
	xmlns:renderlet="http://www.ameos.com/formidable/080/renderlet"
	xmlns:validator="http://www.ameos.com/formidable/080/validator"
	xmlns:actionlet="http://www.ameos.com/formidable/080/actionlet">

<datahandler:VOID />
		<renderer:STANDARD />

<datasource:DB name="pages">
				<sql><![CDATA[
					SELECT uid, title, tstamp, crdate from pages WHERE pid = 25 AND deleted=0 and hidden=0
				]]></sql>
			</datasource:DB>

<datasource:DB name="fe_users">
				<sql><![CDATA[
					
					SELECT
						fe_users.uid				AS uid,
						fe_users.username			AS username,
						fe_users.tstamp				AS tstamp,
						(fe_users.crdate + 86400)	AS crdate,
						fe_users.usergroup			AS usergroup,
						fe_groups.title				AS groupname,
						fe_groups.tstamp			AS fe_groups_tstamp,
						IF(fe_groups.deleted = 0, "ACTIVE", "DELETED") AS fe_groups_status,
						pages.title					AS pagetitle
					FROM
						fe_users, fe_groups, pages
					WHERE
						fe_users.usergroup = fe_groups.uid AND
						fe_users.pid = pages.uid AND
						fe_users.pid = 76

]]></sql>
			</datasource:DB>

</datasources>

</control>

<renderlet:BOX mode="h3" html="Listing pages table" />

<renderlet:LISTER name="mylist" cachehash="true">
			<datasource use="pages" />
			<columns>
				<column name="title" type="renderlet:TEXT" listHeader="Page title" />
				<column name="crdate" type="renderlet:DATE" listHeader="CR date">
					<data>
						<datetime format="%d %B %Y" />
					</data>
				</column>
			</columns>
		</renderlet:LISTER>

<renderlet:BOX mode="h3" html="Listing fe_users+fe_groups+pages tables and relations" />

<renderlet:LISTER name="mylist2" cachehash="true">
			<datasource use="fe_users" />
			<columns>
				<column name="username" type="renderlet:TEXT" listHeader="User name" />
				<column name="pagetitle" type="renderlet:TEXT" listHeader="User Stored in" />
				<column name="crdate" type="renderlet:DATE" listHeader="User CR date">
					<data>
						<datetime format="%d %B %Y" locale="fr_FR" />
					</data>
				</column>
				<column name="groupname" type="renderlet:TEXT" listHeader="Group name" />
				<column name="fe_groups_tstamp" type="renderlet:DATE" listHeader="Group Mod date">
					<data>
						<datetime format="%d %B %Y" locale="fr_FR" />
					</data>
				</column>
				<column name="fe_groups_status" type="renderlet:TEXT" listHeader="Group status" />
			</columns>
		</renderlet:LISTER>

</elements>

</formidable>

See it in action

Listing pages table

Page title

CR date

Revision 33

04 March 2008

Revision 36

04 March 2008

Revision 37

04 March 2008

Revision 39

04 March 2008

Revision 40

04 March 2008

1 / 16

Next» Last»»

Listing fe_users+fe_groups+pages tables and relations

benoitchambard

Users for example

06 mars 2008

Comment moderators

05 mars 2008

ACTIVE

jeromeschneider

Users for example

06 mars 2008

Comment moderators

05 mars 2008

ACTIVE

johndoe

Users for example

06 mars 2008

Website users

05 mars 2008

ACTIVE

loredanazeca

Users for example

06 mars 2008

SuperPowerUsers

05 mars 2008

ACTIVE

lucmuller

Users for example

06 mars 2008

Comment moderators

05 mars 2008

ACTIVE

1 / 2

Next» Last»»

Download Formidable XML file

This demo uses Formidable version 2.0.495

List bound to a db-datasource

What does it do ?

See it in action

Listing pages table

Listing fe_users+fe_groups+pages tables and relations

Download

Features

Documentation

Many thanks to

Latest snippets