Feature #264
getRecord() on foundsets is zero based
0%
Description
the getRecord() method on a foundset seems to be Java style zero based. In one of my reports I do
$record.record_to_other_table.getRecord(1)
on a 1:1 relation and do not get a record. I get the one with
$record.record_to_other_table.getRecord(0)
From a Servoy perspective, this is confusing.
History
Updated by Patrick Talbot about 13 years ago
- Tracker changed from Defect to Feature
Hum. I get your point but I'm wondering if I can implement this now...
It will break existing reports who where relying on this method to be 0 based.
I should probably make a little poll out of this feature request to check what people are using, and make it very clear that a new version with this change would not be compatible.
I must say that I never had to use this.
I tend to put as much of the logic in the preparation of the objects in the context and only iterate in the template and perform small tests on values to tweak the display, avoiding as much as possible to put too much logic in it.
Updated by Jeroen de Vries about 13 years ago
I don't see how this is going to make our lives any easier. Zero/one based issues are everywhere, this is just another one.
Updated by Patrick Ruhsert about 13 years ago
Leave it as it is. I have already started with 0 based stuff also...
Updated by Sem Tukenmez about 13 years ago
We don't use this (for now), so it doesn't matter for me. But I have to agree with Jeroen.
Updated by Victor Rojo Carballo about 13 years ago
I don´t use it in any report, so I'm safe if you change it.
Updated by Patrick Talbot about 13 years ago
- Status changed from New to Closed
With v1.4.11 I have added a new defaultReportParameter: oneBasedLoop, if set to true, foundset.getRecord() and dataset.getRow() will be 1-based, set to false (the default) they will be 0-based (as it is now).
So the current behavior didn't change, but you will have a choice to set it to match Servoy's 1-based loops if you want to.
Simply add:
plugins.VelocityReport.addDefaultReportParameter( 'oneBasedLoop', true );
or
plugins.VelocityReport.setDefaultReportParameters( { 'oneBasedLoop': true, ... } );
somewhere in your scripts before using the plugin and you're all set!
I have updated the wiki with this information.