Having a sub list in a template - getting crazy here

Hi,

I am getting crazy here and everything attempted does not seem to work!

Here the matter: I have a table of PV (PV_VIN with id idPV) each PV have at least one Damage (from table PV_DAMAGES with idDamage (also external key idPV))

I want in the template to have data of the PV and list of som of the items of PV_DAMAGES
like this (see below) 

the issue is with the formating on the start that does ,not seems to work  depending how I do it 
<<Start :select(PV_DAMAGES[Location],[idPV]=[idPV])>><<[Location]>>  

or <<Start:[PV_DAMAGES]>><<[Location]>>

nothing is working any clue what might be wrong here?

Information du Vehicule / Vehicle informations

VIN

<<[VIN]>>

Vehicle protection

Covering

<<[Vehicle protection]>>

KM

 

Marque
Brand

<<[Brand]>>

Couleur
Color

<<[Color]>>

Type dโ€™รฉnergie
Energie Type

 

Modรจle
Model

<<[Model]>>

Propretรฉ extรฉrieur
External Cleanliness

<<[Cleanness Ext.]>>

Niveau dโ€™Energie
Energie level

 

Statut
Vehicule Status

<<[Vehicle status]>>

Propretรฉ intรฉrieur
Inside Cleanliness

<<[Cleanness Int.]>>

 

 

Immatriculation
License Plate

<<[Licence plate]>>

Vรฉhicule en panne
Vehicule breakdown

<<[Vehicle breakdown]>>

 

 

 

Avaries / Damages list

Nยฐ

Localisation
Location

Position

Dรฉgรขts
Damage

Taille
size

Sรฉvรฉritรฉ
Gravitรฉ

Origine
Origine

1

<<Start:[PV_DAMAGES]>><<[Location]>>

<<[Position]>>

<<[Damage]>>

<<[Size (In cm)]>>

<<[Acceptability]>>

<<[Origin]>><<END>>

Solved Solved
0 8 138
1 ACCEPTED SOLUTION

First check that the column name you use with the START: expression is the key column. Then you need to use something like SELECT(....,[idPV]=[_THISROW].[idPV)

View solution in original post

8 REPLIES 8
Top Labels in this Space