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]>> | Couleur | <<[Color]>> | Type dโรฉnergie |
|
Modรจle | <<[Model]>> | Propretรฉ extรฉrieur | <<[Cleanness Ext.]>> | Niveau dโEnergie |
|
Statut | <<[Vehicle status]>> | Propretรฉ intรฉrieur | <<[Cleanness Int.]>> |
|
|
Immatriculation | <<[Licence plate]>> | Vรฉhicule en panne | <<[Vehicle breakdown]>> |
|
|
Avaries / Damages list | ||||||
Nยฐ | Localisation | Position | Dรฉgรขts | Taille | Sรฉvรฉritรฉ | Origine |
1 | <<Start:[PV_DAMAGES]>><<[Location]>> | <<[Position]>> | <<[Damage]>> | <<[Size (In cm)]>> | <<[Acceptability]>> | <<[Origin]>><<END>> |
Solved! Go to 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)
User | Count |
---|---|
16 | |
13 | |
8 | |
3 | |
2 |